Question Robert Hanna · Aug 23, 2019 Traverse Global Subscripts while using Indirection Hi all, I am trying to create a method to count the number of entries in a global, including all subscripts. I am having a bit of trouble getting the code to make it to the second subscript. When I get to the position where my key is "Canada" and I add a comma and empty quotes to it, it returns USA as the new key when I do the order function. Is the $Order or the global not able to use a single string to represent multiple subscripts?Here is my global structure: #Globals #Caché #Ensemble #HealthShare 2 20 0 690
Article Robert Hanna · Jul 22, 2019 1m read Queue Logging Hey everyone!I had looked around a bit and couldn't find a native way to log queue counts in Ensemble/HealthShare so I wrote a quick task and persistent class to do it. Hope this saves someone a bit of time. Let me know your thoughts! Thanks! Bobby Hanna #Ensemble #HealthShare #InterSystems IRIS #Open Exchange Open Exchange app 1 4 1 417
Question Robert Hanna · Apr 4, 2019 %GSIZE vs %SYS.GlobalQuery for Estimating Size of Globals Hey everyone, I stumbled across a comment in this post that mentioned that the %SYS.GlobalQuery is a potentially faster alternative to %GSIZE. I tested it out and while I like the %SYS.GlobalQuery I noticed that it has some size discrepancies against a %GSIZE with details. Can anyone tell me which is more accurate for estimating the size of globals? #Caché #Ensemble 0 2 1 2.4K
Question Robert Hanna · Oct 23, 2017 Routing Rule Condition based on RecordMap property I am currently trying to add a condition to a routing rule that uses the %Source property of a routing rule. Unfortunately I am getting compile errors when I use the "%", and if I get PROPERTY DOES NOT EXIST if I try and use any of field. I have tried referencing the messages as "Message." , "Record.", "FullRecordMapClassName." , "Document." . Does anyone know how to reference the properties of a record map in a routing rule, or if it is even possible? Thanks! #Compiler #Business Rules #Ensemble 0 10 1 870
Question Robert Hanna · Oct 19, 2017 Process Single Messages from Queue I was wondering if anyone has a good way to process individual messages from a queue. I run into this fairly often where I have test data coming in that I am queuing at the disabled business process, while I am working on the DTL or class to process the messages. What I would like to do is be able to send one message through to see the effects of my changes. What happens is I turn the business process back on and all of my test data goes through the current DLT/class set up. If anyone has any insight it would be greatly appreciated.Thanks! #Ensemble 0 5 0 901
Question Robert Hanna · Apr 24, 2017 Connect PRTG to Cache I am trying to set up a sensor in PRTG to connect to Cache, specifically the ens_util.log, so that I can have a live feed of my error count. I am having trouble getting the sensor to log in to Cache. Has anyone had any luck getting PRTG to connect on the database level? Thanks! #JDBC #ODBC #Caché 0 2 0 534