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 312
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 734
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 410
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 #Health Connect #HealthShare 0 1 0 303
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 319
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 410
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 323
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 #InterSystems IRIS 0 1 0 289
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 508
Question Andy Stobirski · May 6, 2022 User code location Hi Does anyone know where the user generated code resides, the stuff one might write for a production, I presume it lives in a table somewhere within a database? Basically, I want to do some dependency analysis of what I've written - find out what's in use, how it's referenced, etc. I know I can export it to an XML file and work on that, but direct access on a table would be quicker for me. Cheers #Databases #Caché 0 1 0 215
Question Andy Stobirski · Apr 21, 2022 Using host variables with embedded SQL isn't working for me Hi I'm using an embedded SQL statement with a a cursor-based Embedded SQL query that uses host variables in the where clause, however, what I'm doing doesn't seem to work. Can anyone help? The code I'm using is #SQL #InterSystems IRIS 1 15 0 350
Question Andy Stobirski · Mar 15, 2022 How to use LOAD DATA How do I use the LOAD DATA command as described here. I have the following LOAD DATA statement: LOAD DATA FROM FILE 'E://Temp/Values.txt' into PARIS.UAGU_MNDOOUT1 (AHSU_ID, AHSU_UAG_ID) Where do I run it? It doesn't work in the SQL Gateway, in the terminal, in an embedded SQL command. What am I missing? #SQL #InterSystems IRIS 0 2 0 390
Question Andy Stobirski · Feb 12, 2022 Encoding XML carriage return / line feed Hi I'm using %XML.Writer to write XML files from a database source, and I see that it is not encoding carriage return or line feed as 
 and 
 respectively, and is instead leaving them unencode. What can I do to have them encoded? Andy #ObjectScript #XML #Caché 0 3 0 3.4K
Question Andy Stobirski · Dec 29, 2021 Adding multiple namespaces in an XML file Hi I'm using a class which extends %XML.Adaptor adaptor and I want to create an XML file with multiple namespaces, like the following: <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> </soap> However, I don't see how to do this with the code I have. So far, I have #ObjectScript #XML #InterSystems IRIS 0 2 0 572
Question Andy Stobirski · Dec 22, 2021 Studio classes tree items with italics Hi I have a question about something in Studio that has been bugging me for a while. Why does the font of some items in the Classes treeview (View > Class View) appear in italics whilst others do not? Cheers Andy #Studio #Other 0 2 0 402
Question Andy Stobirski · Dec 13, 2021 Log4Shell Apache exploit / Intersystems products Hi everyone I see that a new Apache bug has been discovered, and since various InterSystems products use an Apache webserver, have Intersystems released any news or updates on this? I'm not seeing any updates, press releases from them. Anyone know anything? Andy #Caché 0 7 0 850
Question Andy Stobirski · Nov 23, 2021 Not all XML child items are loaded into a class list when using XML.Reader correlate Hi all I'm new to ObjectScript and I've been experimenting the correlate method of %XML.Reader to convert an XML file I've loaded into its corresponding class. But, I have found that I am not getting all the child items of an element in a List contained within the converted class, only the last item. The XML file content is as follows: #ObjectScript #XML #InterSystems IRIS 0 6 0 498
Question Andy Stobirski · Nov 11, 2021 Alternative applications to SQL Portal Hi Guys I'm rather new to HealthConnect, and I've been doing a lot of work with the browser based SQL portal and don't particularly like it. Is there an alternative application that I can use, something like SQL Express or VScode with a plugin? Andy #SQL #Health Connect #InterSystems IRIS 0 4 0 432