go to post Alexander Koblov · May 16, 2016 As far as I know it is not possible to switch it on. You might find function DESCENDANTS (http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...) helpful. For time dimension, all members of the level are generated and available to queries that show empty. This means SELECT DESCENDANTS([DateOfSale].[YearSold].&[2015],DateOfSale.DaySold) ON 1 FROM HoleFoods will show all days from 2015 on rows, whether there are facts recorded for those days or not.
go to post Alexander Koblov · Apr 21, 2016 SQL Adapter does some metadata caching. See, for example, doc for method EnsLib.SQL.Common:ExecuteProcedure http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P... "Appending a '#' to the pIO argument (or passing only '#') prevents the adapter from using cached DescribeColumns() results for the procedure call output, forcing a fresh call to ODBC DescribeColumns() every time the stored procedure is invoked. This can be necessary if the procedure is capable of returning different sequences of result types from consecutive invocations" I'm not sure if this is what happened in this case, though.
go to post Alexander Koblov · Apr 14, 2016 You can run tPatient.%ValidateObject() and check returned status before doing XMLExport
go to post Alexander Koblov · Mar 29, 2016 By default %ToJSON method prints empty properties. If you pass pFormat without "e" flags (that is passed by default), then empty properties are skipped: USER>set p = ##class(%ZEN.proxyObject).%New() USER>set p.a = 1 USER>set p.b = 2 USER>do p.%ToJSON() { "a":1, "b":2 } USER>set p.b = "" USER>do p.%ToJSON() { "a":1, "b":"" } USER>do p.%ToJSON(,"alotw") { "a":1 } I encourage you to use Caché 2016.1 with native JSON support. Don't start with %ZEN.proxyObject. See great article by Stefan Wittman about JSON support in 2016.1: https://community.intersystems.com/post/introducing-new-json-capabilitie...
go to post Alexander Koblov · Mar 17, 2016 Why do you need this? For example, for debugging purposes you might use second argument of Get method: do request.Get(,1) In that case "instead of connecting to a remote machine httprequest will just output what it would have send to the web server to the current device".
go to post Alexander Koblov · Mar 14, 2016 And you need to do this why? I mean what is the end goal? To show user some menu when they open Terminal? You can specify "Startup Tag^Routine" for this purpose: http://docs.intersystems.com/cache201513/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Mar 7, 2016 Hi Nicki. Delete menu item for packages should be back again in latest 2016.2 field test release -- build 605 Also, there is $system.OBJ.DeletePackage method: http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls?...
go to post Alexander Koblov · Mar 2, 2016 The first time a message is added to a domain by $$$Text, $$$SessionLanguage is used: http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls?... $$$SessionLanguage is determined by locale of current process, that is by default is the same as locale of Caché instance http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls?... Default locale for Caché instance is determined during installation based on OS locale. For example, on English Windows that has Russian in Regional Settings, Caché is installed with locale rusw (ruw8 for 8-bit installation). You can change locale after installation. There is no option to select locale during installation. You can change current session language with ##class(%MessageDictionary).SetSessionLanguage("ru")
go to post Alexander Koblov · Feb 16, 2016 Good! Now it would be good if we would be able to sort comments based on rating (as on reddit)
go to post Alexander Koblov · Feb 5, 2016 Hi Blaise. There is query ErrorLog in %CSP.UI.System.BackgroundTask class so you can print errors like follows: USER>do ##class(%ResultSet).RunQuery("%CSP.UI.System.BackgroundTask","ErrorLog",3932) 3932 here is task id. And print errors to file: USER>set file="c:\temp\sqlerrors.txt" USER>open file:"NW":5 USER>use file do ##class(%ResultSet).RunQuery("%CSP.UI.System.BackgroundTask","ErrorLog",3932) USER>close file Notice that %CSP.UI.System.BackgroundTask is marked for internal use only.
go to post Alexander Koblov · Jan 25, 2016 «And I want to be able to post new comments to any old post without any restriction.» I agree with this. «I want to be able to edit my comment while topic is visible. At any time.» Why? If something is changed, so that comment is no longer relevant, you can post a new comment. If you made mistkae during posting -- you have 10 minutes to fix it.