go to post Eduard Lebedyuk · Jun 9, 2016 > EnsLib.SQL.Snapshot.GetRowList().Thank you.> additional field in the external databaseWould have been nice, but not happening unfortunately.
go to post Eduard Lebedyuk · Jun 9, 2016 Here's CRC hashing method (accepts any number of arguments): ClassMethod hash(in...) { set delimiter = $c(255) set str = delimiter for i=1:1:in { set str = str _ in(i) _ delimiter } return $zcrc(str, 7) }
go to post Eduard Lebedyuk · Jun 7, 2016 Wait interval can be very small so it's okay.You could, I suppose, add some %ZSTOP code but that would be an overkill.
go to post Eduard Lebedyuk · Jun 6, 2016 Yes. Use resources instead. Read the docs. $ZPARENT value is also a "resource" that's getting created with the process, so children processes can communicate events to a parent process easily. As processes you want to pass messages between are not parent and child, you need to create and use explicitly named resources.
go to post Eduard Lebedyuk · Jun 6, 2016 Jobbed process runs independently of parent process.Killing a parent does not kill its children.That said, you can use events for interprocess communication.
go to post Eduard Lebedyuk · Jun 6, 2016 I think only profiler for the exact case can really answer this kind of questions. Too many nuances in the real-life code for one-fits-all solution of any kind to be feasible.
go to post Eduard Lebedyuk · Jun 6, 2016 > one "extremum" version: Does not really count. The method signature must be: ClassMethod ToPhone(t As %String) As %String {}
go to post Eduard Lebedyuk · Jun 6, 2016 Hello.While there is currently no way to it, you can see %DeepSee.UI.MDXExcel class, which does excel export and write your own csv exporter. It would be a simplified copy of %DeepSee.UI.MDXExcel.All output is done via &html so you need to replace that with the usual write.
go to post Eduard Lebedyuk · Jun 6, 2016 I knew about the second option (my original question was not clear on that I guess), but I'm really interested in the first option: how do I open *.cls directly?Here's the sample process:when I click on ContractFinalApprovalProcess BPL opens instead of cls.
go to post Eduard Lebedyuk · Jun 2, 2016 You can use %SerialObject for that: Class Utils.Serial Extends %SerialObject { Property Payload As %String; /// zw ##class(Utils.Serial).Test() ClassMethod Test(input As %String = {$lb(1,2,3,",",5)}) As %String { set obj = ##class(Utils.Serial).%New() set obj.Payload = input do obj.%SerializeObject(.str) kill (str) set obj = ##class(Utils.Serial).%Open(str) return obj.Payload } } For example: zw ##class(Utils.Serial).Test("1,2,3,,,5") >"1,2,3,,,5" zw ##class(Utils.Serial).Test($lb(1,2,3,",",5)) >$lb(1,2,3,",",5)
go to post Eduard Lebedyuk · Jun 1, 2016 Q1: 1. JS client sends URL encoded string automatically or almost automatically (most frameworks do URL encoding for any URL) 2. In your broker override OnPreDispatch method and unescape pURL with: set pURL = $ZCONVERT($ZCONVERT(pURL,"I","URL") ,"I","UTF8") Q2: It is against core REST architecture principles, so I hope not.
go to post Eduard Lebedyuk · May 31, 2016 You can use MDX2JSON or DeepSee REST API for pivot execution -> JSON conversion.
go to post Eduard Lebedyuk · May 31, 2016 Here it is: /// Returns MDX string used to create pivot.<br> /// <b>pPivotName</b> - fullname of pivot. Eg: "KPIs & Plugins/HoleFoods.pivot". Case insensitive.<br> /// <b>pStatus</b> - Status of query execution.<br> /// <b>MDX</b> - MDX query with filters<br> /// <b>BaseMDX</b> - MDX query without filters<br> ClassMethod GetMdx(pPivotName As %String, Output MDX, Output BaseMDX) As %Status { #dim tPivot As %DeepSee.Dashboard.Pivot #dim tPivotTable As %DeepSee.Component.pivotTable set MDX = "" set BaseMDX = "" set tPivot = ##class(%DeepSee.UserLibrary.Utils).%OpenFolderItem(pPivotName,.pStatus) return:'$IsObject(tPivot) $$$OK return:$$$ISERR(pStatus) pStatus set tPivotTable = ##class(%DeepSee.Component.pivotTable).%New() set pStatus = tPivot.%CopyToComponent(tPivotTable) return:$$$ISERR(pStatus) pStatus // returns tQueryText - mdx without filters set rs = tPivotTable.%CreateResultSet(.pStatus, .tParms, .tFilterInfo, .tAdvancedFilters, .BaseMDX) return:$$$ISERR(pStatus) pStatus set pStatus = tPivotTable.%GetFilterInfo(.tFilterInfo, .tAdvancedFilters) //return:$$$ISERR(pStatus) pStatus if (($d(tFilterInfo)=0) &&($d(tAdvancedFilters)=0)) { set MDX = BaseMDX // no filters, so we're good } else { // returns tQueryText - mdx with filters set rs = tPivotTable.%CreateResultSet(.pStatus, .tParms, .tFilterInfo, .tAdvancedFilters, .MDX) return:$$$ISERR(pStatus) pStatus } // Remove \n set MDX = $TR(MDX, $C(10), "") set BaseMDX = $TR(BaseMDX, $C(10), "") return pStatus } It is a part of MDX2JSON REST API.
go to post Eduard Lebedyuk · May 25, 2016 If you're okay with /api/deepsee as it is - use it.If, however, you want to change some settings (auth methods for one), then it's better to define your own application, since your changes may be lost during system update.
go to post Eduard Lebedyuk · May 24, 2016 Save timestamp with user timezone (get timezone from request), for example (returns server timezone): write $ZDATETIME($HOROLOG, 1, 5) Return timestamp to a client, there are a lot of js libraries which automatically convert incoming timestamp with a different timezone into user's local time. The advantage of this approach is that you only need to convert timezone once, the rest would be done on client. Check out ISO 8601 for timestamp formats with timezone support and which js understands. This approach works best, when you don't need to access your application data from the systems without support for this type of timestamp.
go to post Eduard Lebedyuk · May 23, 2016 s array = [] While (result.Next()) { s object = {} s object.data = {} s object.data.id = result.Data("ID") s object.data.reg = result.Data("Registration") s object.data.snNum = result.Data("SatNavVehNumber") do array.$push(object) } w !!,array.$toJSON() This should produce the desired output.
go to post Eduard Lebedyuk · May 19, 2016 1) I tried all three with the same result.2) I linked the procedure, and it does not work when I select data from a linked table. When I check the int code for a query, there is no call to my procedure or linked procedure to be found.
