Question Steve Pisani · Jul 3, 2022 Errors installing OpenExchange git-source-control using ZPM Hi, I have tried to install the module git-source-control into my USER namespace, but get the following error. ERROR! ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={2763|2764}> > ERROR #6084: Unknown errors detected, but no error code reported #Open Exchange 0 3 0 283
Question Steve Pisani · Jun 8, 2022 PowerBI and IRIS generating "The column '...' of the table wasn't found." Hi, I have 3 simple tables: Encounter, Patient and Immunizations. Encounter makes a reference to Patient, and Patient contains a list of Immunization objects. I've tried using PowerBI to access IRIS (using ODBC connector, not InterSystems BI connector), PowerBI reports the error: Expression.Error: The column 'Patient' of the table wasn't found. Details: Patient it does this for two of the three tables I need only (Patient and Encounter), but not for Immunization IRIS table.. #Analytics #InterSystems IRIS BI (DeepSee) 0 1 0 114
Question Steve Pisani · Apr 1, 2022 Hiding Inverse Relationship entries project in DTL graphics Hi I have an a Ens.Request subclass (Invoice) that has a relationship property to another persistent class (InvoiceItems), with properties of its own and the inverse relationship defined referring back to Invoice. When building a DTL with these classes, the Relationship’s inverse relationship (Invoice, within InvoiceDetails) is displayed. #DTL #Interoperability #Ensemble #InterSystems IRIS 0 5 0 187
Question Steve Pisani · Feb 10, 2022 Interoperability debugging, Containers and the Foreground Window Hi, Is it possible to use the IRIS' Interoperability's Foreground Window option for Business Operations when IRIS is running in a docker container ? Thanks - Steve #Debugging #Interoperability #InterSystems IRIS 0 11 0 351
Question Steve Pisani · Jan 29, 2022 Calling Python Class Methods Hi, What is the Python syntax I can use from a ClassMethod (developed in an IRIS using embedded Python), in order to invoke another class method, - in the same class; and - in another class. I see 'self' is synonymous to use $this (..) in ObjectScript, but these are ClassMethods I am invoking, and self did not seem to work. thanks - Steve #Embedded Python #Python #InterSystems IRIS 1 5 0 300
Question Steve Pisani · Feb 1, 2021 VS Code's Server Source Control and Server Command Menu Hi, When wanting to use VS-Code for server-side editing.. - In VS-code I can right click on a server item (eg a class) to see a set of menu options including 'Server Source Control... ' and 'Server Command Menu...' at the bottom. I noticed that these options are somewhat connected to my server-side source control hooks class that inherits from %Studio.SourceControl.Base, however, I am seeing different behavior between my custom subclass of this, and, the provided %Atelier.SourceControl subclass. #Change Management #Git #SVN #VSCode #InterSystems IRIS 1 1 0 342
Question Steve Pisani · Jul 15, 2020 Context Object visibility in Business Rule Custom Utility Function Hi, Business Rules can define a context object, whose properties are exposed and used in the expressions of the rules. For example, my context object is an object with 3 properties. PropA, PropB and PropC. When constructing my rules, I can call a custom function, and I have one I built myself called 'myFunction' which takes arguments and I pass in properties of my context object. (I can pass in the value of the context object's PropA, B or C). #Business Rules #Interoperability #Ensemble #InterSystems IRIS 0 6 0 241
Question Steve Pisani · Oct 19, 2019 Common Testing Frameworks. Hi, I'm after feedback and comments on the sort of tools and approaches the wider InterSystems community uses for QA Testing applications written in Cache/Ensemble or IRIS. I am aware of the %UnitTest package, and understand how that works... but: - Do you use an alternative or framework built around this native Unit Testing tool ? - What is your experience with %UnitTest if you use it ? - Is there a tool you would recommend for your UI (I know this is not specifically an InterSystems' related question) #Testing #Caché #Ensemble #InterSystems IRIS 0 4 0 406
Question Steve Pisani · Nov 21, 2018 Synchronous Calls in a routing rule Hi,I need to route a message synchronously to multiple targets using a routing rule.In IRIS I built a general routing rule set, made up of a couple of rules. For one Rule in particular, and based on a common condition, I want to send the incoming message to 2 different targets. (no transformation is used)I can select, in the single SEND action, multiple target names, or, I can create consecutive SEND actions, one after the other, each sending to their specific target. #Business Rules #Interoperability #InterSystems IRIS 1 1 0 315
Question Steve Pisani · Jun 6, 2018 SQL Inbound Adapter - Last Row ? Hi,The Ensemble SQL Inbound Adapter executes a user defined query, and calls the OnProcessInput method of the Business Service with information about an individual row of the executed query.If the query provided by the user (and executed by the adapter), returned multiple rows, then, OnProcessInput is called multiple times, once for each row.Within the OnProcessInput method, however, is there a way to know that the row that is currently being processed is actually the last row of the query.ThanksSteve #Ensemble 0 7 0 466