Question Andy Stobirski · Nov 14 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 116
Question Andy Stobirski · Jun 29 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 124
Question Andy Stobirski · Mar 17 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 #Caché 0 7 0 340
Question Andy Stobirski · Jan 16 %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 189
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 285
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 228
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 221
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 #Caché 0 1 0 124
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 158
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 226
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 202
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 227
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 #Caché 0 3 0 376
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 #Caché 0 4 0 251
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 185
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 184
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 #Caché 0 5 0 301
Question Andy Stobirski · May 21, 2022 ZEN - Getting currently logged in user name Hi all I'm working in Zen - how might I get the name of the currently logged in user? Andy #ZEN #Caché 0 2 0 202
Question Andy Stobirski · May 19, 2022 %CSP.StreamServer not fully downloading file Hi I have a few Zen pages, one of which is implementation of %CSP.StreamServer which I'm using to download a PDF file, however, any file downloaded is 5Kb smaller than the original. This is the code I'm using: #ZEN #Caché 0 1 0 197
Question Andy Stobirski · May 18, 2022 Downloading files from ZEN pages Hi all I have a Zen page which displays the contents of a table. One of the columns is a file path to a file on a local disk. Is it possible, on a Zen page, to allow that file that described by the file path to be downloaded when a hyperlink is clicked on? Cheers #ZEN #Caché 0 7 1 308