go to post Robert Cemper · Sep 29, 2017 Hi Ken,For some odd reason Execute() requires he same parameters as Prepare() again !%SYS>set rs=##class(%ResultSet).%New("Config.MapGlobals:List")%SYS>write rs.Prepare("ENSDEMO","*")1%SYS>write rs.Execute("ENSDEMO","*")1%SYS>write rs.Next()1%SYS>..... Just hacking around.
go to post Robert Cemper · Sep 28, 2017 If the owner of a table is _PUBLIC, users do not need to be granted object privileges to access the table.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...based on that you can build an OWNER that has also limited rights (only SELECT, REFERENCES, .. or whatever) So you do it for this Owner only
go to post Robert Cemper · Sep 26, 2017 As you said all are uniqueI try to summarize it simple:IDkey is used in storing object s. Best to be translated : Global subscript of data store.Could be defaulted to %Integer >0Unique key defines an index with unique values of a property in parallel to IDkey. Checked during object save.PrimaryKey comes from SQL world and could be interpreted mostly as a synonym to IDkey
go to post Robert Cemper · Sep 25, 2017 ENSDEMO>d $system.SQL.Shell()SQL Command Line Shell---------------------------------------------------- The command prefix is currently set to: <<nothing>>.Enter q to quit, ? for help.ENSDEMO>>select * from Ens_Config.Credentials1. select * from Ens_Config.Credentials ID BusinessPartner PasswordObject Password SystemName Username .... Rows(s) Affected
go to post Robert Cemper · Sep 25, 2017 or more object stylewrite ##class(%Library.TimeStamp).XSDToLogical(obj.biometrics.%Get(0).timestamp)
go to post Robert Cemper · Sep 22, 2017 Just add another IF condition and replace all "Country" by " Relation"If ($g(pInfo:filters("Relation"))'="") { Set tWHERE = tWHERE _ $S(tWHERE="":"",1:" AND ") _ "Relation %STARTSWITH '" _ pInfo:filters("Relation") _ "'"}
go to post Robert Cemper · Sep 22, 2017 assuming variable payload holds your content of "payload"set profileId=$piece($piece(payload,"profile_id"":""",2),""",")set timestamp=$piece($piece(payload,"timestamp"":""",2),""",")
go to post Robert Cemper · Sep 20, 2017 try Do ##class(%SQL.Util.Procedures).CSVTOCLASS(2, .rowType, pFileName, pDelimiter,,1) ;; no defaults if not required or the EXACT count: 9 params = 8 comma ;; I counted 9 and/orProperty Name As %String (MAXLEN="");and/or;; the last comma in rowType looks also suspect to me.set rowType=" . . . . ,ActiveStatus Boolean" HTH
go to post Robert Cemper · Sep 20, 2017 yeah,that's for slow typing senior writer's without autocomplete. BTW. wrapping of this editor is sometime more than disturbing.
go to post Robert Cemper · Sep 20, 2017 It's still the same answer as in one of your previous questions:only difference 1 hour instead of 24 hourshttps://community.intersystems.com/post/configure-business-serviceSee the example on ENSDEMO namespace
go to post Robert Cemper · Sep 20, 2017 like this:set ts=20160105125915 ;; convert to $Hset th=$zdth($e(ts,1,8)_" "_$e(ts,9,10)_":"_$e(ts,11,12)_":"_(ts#100),8) ;; convert to UTCset tu=$ZDTH(th,-3) ;; show $ZTS format (on UTC+0200 Vienna,Austria)write $ZTD(tu,3)2016-01-05 13:59:15You can of course do it in a single unreadable long cascaded function chain.HTH
go to post Robert Cemper · Sep 19, 2017 Sebastian,I share your considerations.My personal interpretation of the IRIS message: - go for Java for any application code and make use of the large developer market - stay in COS ( or .int) for internal DB manipulation with in depth "System Engineers"
go to post Robert Cemper · Sep 19, 2017 my full support to 3 !!!! and to 5, 2, 4 in this priority.The difference between ANSWER and COMMENT causes more confusion than being helpful.Especially in the actual sequence.Comment to Answers eventually may make sense. More than once I found myself in a Comment where it should have been an Answer. My suggestion: -handle all editing just in a modal pop-up .- allow deleting (or hiding) your entry if you don't feel it appropriate anymore.
go to post Robert Cemper · Sep 15, 2017 WebServerPort =Web Server port number. Setting this number to any non-zero value enables the Web Server on that port. If you set this number to 0, the Web Server is disabled.
go to post Robert Cemper · Sep 15, 2017 For the cube you have servermgr.exe where you define the ports you want to use docs: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... In CSP gateway (from Mgmt Portal) you have Configuration -> Deault Parameters ->Instance Host Name: to set server + portdocs: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
go to post Robert Cemper · Sep 15, 2017 in namespace ENSDEMO use Demo.Dashboard.Production as an example for repeating calls
go to post Robert Cemper · Sep 15, 2017 if you disable authentication for Username / PW you always come in as "UnknownUser"in Mgmt Portal go to System > Security Management > Users > Edit User for "UnknownUser"and set Startup Tag^Routine: ^%zmyLOGINand then do your own authetication.if you intend to go to Prorammer Mode you just have to call "do ^%PMODE" at the end.otherwise the terminal closes.
