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.
go to post Eduard Lebedyuk · May 13, 2016 Some comments on code.rename fileToImport to mysqldumpFileremove 2 references to other classes That said, it does not work on my sql script on the table creation part, despite throwing no errors (data insert throws an error - Table not found, but previous statement which creates the table seems to run okay, but the table does not get created) UPD: Reread your post, only INSERT, ok.
go to post Eduard Lebedyuk · May 13, 2016 Documentation, Measures That Refer to Other Cells. There is an example in Samples which shows how to implement 'relative' measure: "Pareto Chart for Category" dashboard.
go to post Eduard Lebedyuk · May 12, 2016 Tried it again, got the same results as you. $find performs better on both short (20 chars per piece, 100 pieces) and long strings (2000 chars per piece, 100 pieces).
go to post Eduard Lebedyuk · May 12, 2016 Graphs (and measurements in a method) include conversion times. >$find I tried this: $$$START("Using $find (hardcoded delimiter): ") For i=1:1:pIterations { Set tPosition = 0 Do { Set tNewPosition = $Find(tString,",",tPosition) Set tValue = $Select(tNewPosition'=0:$Extract(tString,tPosition,tNewPosition-2),1:$Extract(tString,tPosition,*)) Set tPosition = tNewPosition } While tPosition '= 0 } $$$END It was slow. Is there any way to write this faster - eg. without select (or other condition for the last piece)?
go to post Eduard Lebedyuk · May 12, 2016 Also Set a = $List(list, *) is slower than Set a = $List(list, 3) for 3-element list, on the other hand: Set a = $List(list) is faster than Set a = $List(list, 1)
go to post Eduard Lebedyuk · May 12, 2016 > Pros/Cons for multiple simple deployments vs single more complex deployment)If you have a virtualization platform and clients are heavy users, it would probably make a lot of sense to go with multiple simple deployments, and if you'll have many clients who can't load a single smallest node then "single complex" would be better.Developing "lots of simple" system (so 1 simple system with multiple deploys) would be cheaper (as you don't have tyo think about domains and security would be simpler, maybe some other simplifications would be possible), but hosting would (maybe) be more expensive as there is a lot of overhead in resources (to run OS/Cache for each deploy).
