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

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.

I need to iterate over a few very large tables to generate consistent batch outputs for different partner applications that need to be working on the same "version" of the source data.

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.

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: 

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

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

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?

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.

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.

Hi -

I was recently working with an HL7 message processing production, and some of the HL7 messages were failing the HL7 message router's configured validation. In this basic context, the messages were delivered and then the router would log an event for the message and move on to the next message in the inbound queue.

Hi -

I'm wondering if there is any sort of experience with trying to leverage things like fingerprint readers into any identity management interface. I'm wondering if the "output" of some fingerprint scanner (or face scanner, or eyeball scanner for that matter) is something that HealthShare Patient Index might be able to use?

Hi -

I was wondering how if the "old FHIR gateway" works with the latest release of HealthShare Information Exchange. Since there is an impact on the amount of storage needed to use the "FHIR Gateway 2 which uses the Operation Data Store (ODS)", my question is how (if at all) can FHIR access to Information Exchange work without ODS?

Thanks

Hi -

I'm having odd behaviors on my EC2 hosted IRIS Community instance.

When I configure a "custom login page" in the System Management Portal for my web application I'm seeing a few different behaviors that are under documented (and also undesired)

The old Caché documentation indicates that the custom login page could be a ".csp" file, but this seems to nor be the case (i kept getting "not found" errors, even though I could bring up the page directly from the url FOR the login.csp file. To get around this, I created an HTML file and then, at least, the login page could be found to be rendered.

Hi -

I'm trying to follow the documentation, but I seem to end up in a circular reference, where the docs say "Login to TrakCare" to get access to the Layout Editor, with a link to "Logging Into TrakCare", and then that whole sections assumes that the account being used has been created, but doesn't seem to point to any means of actually creating the account in the first place.

Where is it described in the HealthShare Documentation, how to create a TrakCare login account?

This is on:     Cache for Windows (x86-64) 2017.1.

Hi -

I'm wondering if anyone has coded up a means to create an extension for a %Persistent class from a base class to a sub-class without making a ton of assumptions about the Global structure. I'm trying to create a new "extension" record that would have the same ID as the Base Class 

Class BaseRecord Extends %Persistent

and

Class SubRecord Extends BaseRecord

where I would have an instance of a "BaseRecord" and I want to turn it into a "SubRecord" instance and have all of the existing references to the BaseRecord survive.

Hi -

I'm trying to get my Combo Chart to dynamically scale the Y axis, but it's not doing what I would like. The 1st Y series, if the MAX value is set to null, scales the chart and the series fine, but then the subsequent Y axis are not to that same scale. Each "null" Max'ed series is setting it's own scale based only on it's own ranges and not in sync with anything else.

Is there a way to force all of the "null" scaled columns to be in the SAME scale as each other AND be dynamic.

Hi -

I'm working on a project that will be dealing with depression screening and I'm not certain where any of this information would belong in the HL7v2.x world.

Can anyone suggest what the proper placement of "has this person been screened" and if so, "this was what the screening showed"?

At first thought I was thinking that this is an "Observation" of some sort (and ORU message) for the "what the screening (or perhaps testing) showed", but I'm not sure if the screening was performed yes/no qualifies as an "ordered test".

Just looking for a starting point I guess. Thanks

Hi -

I'm trying to figure out an elegant way to select a row on a table pane when I don't have an index, but I DO have a value.

My page has a typical tablePane (with a tableNavigator) which is being populated from a table of records, and the value for each row is the object instance ID for the class that has the rest of the columns being displayed. What I'm trying to do is add in a URL parameter for a targeted object ID that will populate the specific "fields" elsewhere on my page, which are the same fields that are populated when I do an onSelectedRow() from my tablePane.

Hi -

In HealthShare clinician user specifications (as well as in the the clinical viewer), there are locations for specifying "proxy" user(s), but there doesn't seem to be anything in any of the documentation that explains what this actually means/enables.

Hi -

I know that when specifying Caché password rules (i.e. what constitutes a valid password definition) that the "Pattern Matching" logic is what is getting leveraged under the covers to enforce the "A Password Must conform to X" rule. I was hoping that people could share some more sophisticated pattern matching rules. (in particular, I was wondering what a rule that would require non-repeating mixture of letter, numbers, & punctuation of an overall minimal size)

In writing some code on:

Cache for Windows (x86-64) 2015.1 (Build 429U) Fri Feb 13 2015 14:37:23 EST

I noticed an unexpected "ROLLFAIL" error when a Unique Index fail was generated in a %Save() call.

The object SHOULD fail to save, since the Unique criteria is not met, but I didn't expect to see a ROLLFAIL error as the "Last Error".

When running the following class code:

Class BUG.Test Extends %Persistent
{

Property Field1 As %String;

Property Field2 As %String;

Index idx1 On Field1 [ Unique ];

ClassMethod Test()
{
    kill ^BUG.TestD
    kill ^BUG.

Hi -

When upgrading a Health Connect deployment from 2014 to 2016 do I HAVE to recompile? or is the "just upgrading" enough?

Hi -

How do the various components of DeepSee (Architect, Analyzer, User Portal) map to the "Out of the Box" user Roles associated with HealthShare?

I'm VERY novice on all things "OpenAM", and beyond knowing that Caché supports working with OpenAM, I have nothing else to go on.

The documentation doesn't seem to be very deep on the nature of how this works beyond a single paragraph saying it's supported for Single Sign On (SSO).

For Caché to use this, I get that there is an environment variable (REMOTE_USER) which is set to "something", but it's not clear to me how this ends up mapping to a provisioned caché user (or LDAP provisioned user for that matter) and ultimately to the %Roles in effect and subsequent system access.

Hi -

I have 3 classes: "Class A" has a property X, "Class B" has a property which is a Class A, and I have a "Class C" which has a property of a Class B.

Class A definition

Class USER.ClassA Extends %Persistent

{

Property Propx as %String;

}

Class B definition

Class USER.ClassB Extends %Persistent

{

Property Record as USER.ClassA;

}

Class C defintion (which is where I'm having my problem)

Class USER.ClassC Extends %Persistent

{

Property BRecord As USER.ClassB;

Property ARecord As USER.ClassA [ Calculated, SqlComputeCode = { ????? }, SqlComputed ];

Method ARecordGet() as USER.ClassA

{

 quit .

Hi -

I'm trying to rewind a cursor back to the first row after looping part of the way through the implied result set, but I'm not finding a way to make this happen, is there some such iterator variable or directive that I can leverage to accomplish this?

I could code around it by pulling identifiers and/or values into a local array, and then hand code up an iterator over my local results copy, but this feels like a "redesigning of a wheel" approach, and I thought I would check before I start down this path.

Thanks

Hi -

I'm trying to figure out what is the best (or at least pros & cons) on how to manage login accounts in a multi-tenant SaaS web based application context.

Assume that a company is designing a collections of web based applications that they will be selling as "services" to their clients, and that these clients will each have their own "users" and "customers" that will be logging into these services.

In setting up these login accounts for the "users/customers" of the "clients" of the "company", does setting up a unique domain/user-pool context for each "client" make the most sense?

Hi -

I'm trying to create a method that will automatically create something I can save and use later, which will let me automate data migration from one version of a class to the next.

When I compile a normal persistent class, a "storage" gets created, and I would like to be able to archive some code that would let me recreate this "old storage" so I could access an "older version" from a global and map the values into the current mapping of the class.

Hi -

I was looking at the “Purge Data Management” page, and one of the “Record Types” is the “I/O Log” which sometimes doesn’t clear when you purge all of the message.

But I’m not sure what it’s actually reporting as “I/O Log” messages (and I can’t find anyplace to view what is being considered I/O Logged Messages - so I can understand what’s happening)

Can anyone shed some light on these messages?

Hi -

I need an example of what I need to "map" to have a common dashboard defined so it will visible/usable in multiple namespaces.

I have created a dashboard in "SAMPLES" (namespace and database) and I would like to have this dashboard be accessable/useable from a 2nd namespace, but I'm not having any success in doing mappings (global/package/routine/data) to be able to get DeepSee to be able to see/display the dashboard.

What is the minimum that I need to map?