Question Chip Gore · Jan 12 Needed Class Parameter specification and use that works SQLComputeCode In trying to define a Class Parameter that I can use in SQLComputeCode I can't seem to get any of the syntaxes for the using of the parameter where the SQL compute code will actually evaluate the parameter values. There is nothing specific that I can find in the docs about SQLCompute Code and Parameter usage. Is there some specific syntax for accessing a class defined parameter in the SQL Compute Code that works? This is on: IRIS for Windows (x86-64) 2022.1.1 (Build 374U) Tue Oct 18 2022 17:37:34 EDT #ObjectScript #Caché 0 4 0 131
Question Chip Gore · Nov 18, 2022 DTL to Record-mapped Batch output creation In terms of general through-put design and long term support, I'm considering what would be a "best approach" for needing to create multiple batch files in a few different layouts from the same data-sets. #Data Import and Export #DTL #Mapping #Performance #InterSystems IRIS 2 0 1 332
Question Chip Gore · Sep 20, 2022 Launching an application from a CSP Page Hi - I'm looking for some help in getting an OS level application on my server to startup from a csp page and I'm just missing something. I have a routine (and I've tried the same code from an instance method, with the same results) that will launch an application at the OS level using the $zf(-100,keywords,program,parms) from a terminal session, but it won't/doesn't seem to work when I call the code from a #server() call from my webpage. I don't know if there is some combination of keywords or perhaps a different version of the $zf() call that should/would work. #CSP #Caché 0 7 1 183
Question Chip Gore · Oct 29, 2021 Calling a Function from the WHEN directive in a Business Rule specification In specifying a "WHEN" condition statement, I don't seem to be able call a function directly from this declaration, as the generator seems to get confused In the graphical editor: %request.GetValue("MRN"))=123453 (%request.GetValue("MRN"))=123453) In the DTL directly: <when condition="(%request.GetValue("MRN"))=123453)"> <when condition="(%request.GetValue("MRN"))=123453)"> #DTL #InterSystems IRIS 0 2 0 180
Question Chip Gore · Apr 15, 2021 Renaming and installed Instance of IRIS Is there any way (on a Window machine) to rename an installed instance? I installed my instance as 20201 and now I've upgraded in place to 2020.4 and I would like to change the instance name to be 20204, but I'm not sure how/where/or-even-if-possible to rename the instance. Am I out of luck, or is this possible? Thanks #System Administration #InterSystems IRIS #InterSystems IRIS for Health 1 5 0 615
Question Chip Gore · Feb 2, 2021 How do I pull a class from a connected IRIS server to my local machine using VSCode for editing? Hi - I know this is very "newby" of me, but here goes.. I have moved some classes onto my server, but these have never been in VSCode as edited files, and I'm just not finding the magic command or button or drop-down that says "pull this file from the server and make me a local copy to edit. I can see the class files on the server using the ObjectScript plugin - but I just can't find out where to make a local copy for editing Thanks #VSCode #Open Exchange 0 2 0 148
Question Chip Gore · Sep 22, 2020 VSCode and CSP - what did I miss? Hi - I'm trying to get my VS Code instance that is connected to an AWS IRIS instance to edit/save/compile .csp files, but it's failing to work and I'm not sure why. The ".csp" is associated with the objectscript-csp code, and the server is connected, but things just don't act like they are enabled. Should this work? and if so, what might I have missed in configuring things? #AWS #CSP #VSCode #InterSystems IRIS 0 5 0 569
Question Chip Gore · Apr 15, 2020 InterSystems IRIS Business Intelligence - Limiting the source data for a cube I'm looking for a means to dynamically specify and/or limit the data from the source that goes into a cube at build time. I have a single data class that defines my source, and as the data within this table/collection grows/changes over time, I would like to be able to control which records actually make it into the indexed cube, but I'm having a hard time (short of defining a stored procedure to use instead of the extent query) for populating my cube indexes. #Cubes #InterSystems IRIS BI (DeepSee) 0 2 0 132
Question Chip Gore · Oct 30, 2019 How do you sort a DeepSee Pivot Table by Row Label? Working on "HealthShare 2019.1 [HealthShare Modules: Core:17.0.9941 + Patient Index:17.0.9941 + Clinical Viewer:17.0.9941 + Active Analytics:17.0.9941] - Cache for Windows (x86-64) 2018.1.1 (Build 312_1_18859U) Tue Mar 19 2019 00:43:30 EDT" In creating a DeepSee Cube - Pivot - Dashboard I am not finding out how to sort my rows by the row label value. My Rows are numeric values, but they are sorting lexically not numerically. By this I mean that given the Row Values 1, 2, 3, 10, 100 the rows ar being displayed in the Analyzer in the alphabetic order of: #Cubes #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 1 0 138
Question Chip Gore · Oct 11, 2019 How do you Resend Messages from Event Logged sessions? Hi - #HL7 #Message Search #InterSystems IRIS for Health 0 1 0 293