Question Andy Stobirski · Jan 23 Sharing code across namespaces Hi I'm having a tidy up of code across my multiple namespaces, and have moved the common code to a new database called DEVTOOLS. Currently, I'm copying code and updating code into new namespaces. How might I make code from namespace available to others? Cheers Andy #Namespace #ObjectScript #InterSystems IRIS 1 2 0 100
Question Andy Stobirski · Jan 21 How I access a REST web service I've created? I've created a Rest Service as described here Configured the webapplication as described in the previous link, and now have a URL which I call in PostMan #REST API #HealthShare #InterSystems IRIS 0 6 0 120
Question Andy Stobirski · Jan 20 Using ^%REST to Create a Service - Correct OpenAPI 2.0 version was not specified Update - I answered my own question, so I'll just leave this here in case it can help someone. Hi All I'm following the tutorial Creating and Editing REST Services and have reached the step Using ^%REST to Create a Service and have encountered an error. #REST API #InterSystems IRIS 0 4 0 80
Question Andy Stobirski · Nov 14, 2023 Cleaning text, removing characters which break XPATH Hi All I'm having a problem with cleaning user inputted text from a HealthCare system my HealthConnect system interfaces with. The input can be anything posted into an RTF box on an app which stored in oracle, and extracted by HealthConnect from oracle via an XML based API. When the XML is returned, various values are read out of it using %XML.XPATH.Document and it is the presence certain characters entered into the RTF fields cause XPATH to throw an error. For example, #XML #HealthShare 0 4 0 217
Question Andy Stobirski · Jun 29, 2023 Preventing healthconnect services from restarting after restarting the OS Hi all I need to do hardware maintenance on a physical HealthConnect server which forms one half of a mirrored pair, and It will require multiple restarts. So, I will need to prevent any HealthConnect services from restarting until all maintenance is completed. Is this just a case of disabling the service "HealthConnect Controller for <SERVERNAME>", or is there anything else I need to be aware of? Andy #InterSystems IRIS 0 2 0 144
Question Andy Stobirski · Mar 17, 2023 XML.Reader correlate produces ERROR #6277: Type attribute does not specify valid type for XML input tag I'm using %XML.Reader to open an XML file and use it's correlate method to try and convert it to a class. The conversion fails with an error of: ERROR #6277: Type attribute, LimitedFreeTextFieldInstance, does not specify valid type for XML input tag: Field (ending at line 3 character 118). This is the XML #ObjectScript #XML #InterSystems IRIS 0 7 0 385
Question Andy Stobirski · Jan 16, 2023 %SQL.Export.Mgr not formatting exported data correctly Hi Guys I've been using the example code %SQL.ExportMgr taken from here (an example from the intersystems community) an am having a few problems with it. The code I have is below, and I'm having the following problems: #ObjectScript #SQL #Caché 0 4 0 215
Question Andy Stobirski · Nov 30, 2022 Left outer join on tables returns no matches Hi I have two tables: one a local table using cache and the other is via an SQL gateway connection to an MSSQL Server via a 64bit ODBC driver (ODBC Driver 17 for SQL Server). When I try to join them on a date field I don't get any matches, and I know that there are matches, e.g. running both views separately returns resuls for 30/11/2022. The following statement returns rows for the first table r, but nothing for the table l #SQL #Caché 0 5 0 310
Question Andy Stobirski · Nov 7, 2022 Displaying custom icons in Zen TablePane Hi Can anyone explain how to display custom icons in a TablePane? Andy #ZEN #Caché #TrakCare 0 3 0 259
Question Andy Stobirski · Nov 1, 2022 tablePane with OnCreateResultSet returns no results when referencing other namespace Hi I have a Zen Page with tablepane which has a datasource in a different namespace to that of the Zen Page. When the page is run, no data is returned and the tablepane is not populate, even though the rerferenced table contains dat. The tablePane code is as follows: #Namespace #ObjectScript #ZEN #Caché 0 4 0 248
Question Andy Stobirski · Sep 27, 2022 Hyperlinks on Zen Toolbar menu items - how to add? Hi So, I have a zen toolbar and I've figured on how to populate with menu items. How do I add a hyperlink to menu items - I've been all over the support docs, and don't seem to be able to find anything. Also, I see that this component is marked as deprecated - is there a recommended replacement? Andy #ZEN #InterSystems IRIS 0 1 0 153
Question Andy Stobirski · Sep 26, 2022 Populating a toolbar Hi I have a Zen toolbar which I want to share across many pages as common feature - I know it can be populated with a javascript clientmethod that returns a JSON on each page as per this example - https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY... #ZEN #Caché 0 1 0 171
Question Andy Stobirski · Sep 10, 2022 Copy code to clipboard button zen control Hi Guys Is there a zen control that exposes the "Copy code to clipboard" functionality , as seen in the code sample of this page? Cheers #ZEN #Caché 0 0 1 243
Question Andy Stobirski · Sep 5, 2022 Hl7 viewer component Hi All I'm building a ZEN page that will dispay HL7 from a database, and am currently displaying it an textarea. Is the HL7 viewer that is displayed when HL7 message is selected in a visual trace available as an out of the box tool I can plug into a webpage? Andy #ZEN #Caché 0 2 0 219
Question Andy Stobirski · Sep 2, 2022 Where can I find the The Zen Demo Hi The following page references the Zen Demo https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY... Where can I find it to download. I'm drawing a blank here. Cheers #ZEN #Caché 0 2 0 255
Question Andy Stobirski · Aug 24, 2022 Accessing databases in other Namespaces Hi Guys I have a table data in one namespace that I want to access from another Namespace - is that possible? Cheers #Databases #InterSystems IRIS 0 3 0 480
Question Andy Stobirski · Aug 5, 2022 Monitoring the status of all mirror members from one instance Hi all I have a pair of servers configured as a mirror, each server sits in a separate data centre. I have noticed that occasionally, the primary will report that the backup is disconnected in the Mirror Monitor, and I believe this to be due to connection conditions between the two data centres. #Mirroring #InterSystems IRIS 0 4 0 296
Question Andy Stobirski · Aug 1, 2022 Mirror remote control command requested access to instance directory not found in registry. Hi This morning I noticed that the ISCAgent.log for one of my high availabilty healthconnect servers has many entries that say: "Mirror remote control command requested access to instance directory not found in registry." Requested:d:\intersystems\healthconnect\ In addition, Messages.log has many of the following entries: #Mirroring #HealthShare 0 1 0 209
Question Andy Stobirski · Jun 30, 2022 How to searching text stream columns in SQL I have a table with a Varchar(max) column that I have created via the HealthShare SQL portal, and I see that in it's underlying class that column corresponds to a %Stream.GlobalCharacter When I try to do a text search on that column (referenced as cd.Code in the example below) I get an error #SQL #Caché 0 1 0 232
Question Andy Stobirski · May 28, 2022 Why doesn't this %Library.ResultSet ClassName/QueryName doesn't work? Hi Guys, So I've been following this guide in using a %Library.ResultSet with a ClassName / QueryName as described in the first example. https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic.... The code I've got so far doesn't work and is as follows: #SQL #InterSystems IRIS 0 5 0 342