go to post Robert Cemper · Oct 16, 2017 ERROR 5540 - User "UnknownUser" is not privileged for the operation.This tells me that you don't login with a managed user with enough privileges.So you could have a dedicated user just for this purpose.ORgive "Unknown User" enough rightsORmake use of a Privileged Application to assign temporary required Resources (my guess "%Developer") more on this and pp.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.PortalHelpPag...
go to post Robert Cemper · Oct 16, 2017 Adding a recipient to your mail could could eventually improve your result significantlyIf no other part of your code does it. http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...
go to post Robert Cemper · Oct 16, 2017 Alexey,You are totally right.Indirection just does a mimic of "address" while it's in fact the "name" of a variable or global.A kind of "symbolic addressing".
go to post Robert Cemper · Oct 10, 2017 I used this rule of thumb:selectivity > 8 % candidate for bitmap indexselectivity < 2 % normal indexin between it's a mater of investigation and other side conditions beyond selectivity
go to post Robert Cemper · Oct 9, 2017 Olga,You made my day.It's really easy to follow and helps much more then the "short cutted" version.I wish I had 5 votes.
go to post Robert Cemper · Oct 3, 2017 I'd recommend Java as you are platform independent then.Atelier + Eclipse are just another goody for developers
go to post Robert Cemper · Sep 30, 2017 Hi Ken,There is an easier way.Instead of fiddling around with unpredictable params you just pass your whole symbol table = local variablesto your background job like this and use what you need in backgroundJOB ##class(%SYSTEM.OBJ.FM2Class).All():(:1):5look for process-params + switch herehttp://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
go to post Robert Cemper · Sep 30, 2017 Evgeny, in SQL you have a CASE ... END block for selection http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... CASE WHEN search_condition THEN value_expression [ WHEN search_condition THEN value_expression ... ] [ ELSE value_expression ] END CASE value_expression WHEN value_expression THEN value_expression [ WHEN value_expression THEN value_expression ... ] [ ELSE value_expression ] END
go to post Robert Cemper · Sep 29, 2017 That's fine and nothing new.You missed my point:With the Class Query it's not self explaining if params got to Prepare() or to Execute()http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...I just learned from John Murray a few comments abovePrepare() is for dynamic SQL, but in your case it's a class query you want to run.So change your rs.Prepare call to be an rs.Execute one.that you don't need a prepare with a Class Query.I wasn't aware of that until a few hours ago.Then it's obvious that any param has to go to Execute().
go to post Robert Cemper · Sep 29, 2017 SQL Error 417 = Security ErrorYou should check your access rights inside - Windows- Caché
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),""",")