Hello everyone

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries.

I want to know what will be the answer for how to optimize SQL query in cache.

Thanks in advance!!

0 2
0 156
Question
Virat Sharma · Sep 5, 2021
Global Access command query

Hello everyone,

I am new to cache. I want to know is there any direct command to know how to find maximum number of subscripts in global A through direct command.

I mean the answer is 9 but how to check it using a direct command on terminal.

Thanks in advance!!

^A(1)="A"

^A(1,2)="B"

^A(2,1)="CVB"

^A(3,2,7)="'DFGH"

^A(4,1,8,9)="ASDASD"

^A(5,1,2,4,5,6,7,8,9)="ASDASDASD"

0 3
0 207

Hello Everyone

I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()).

I want to know the difference when to create a instance method vs when to create a class methods.

Thanks in advance!!.

0 3
0 155
Question
Shreya Patkar · Aug 15, 2021
Post Deployment Support

Hello,

Does anyone know if intersystems has a support document/ support guide on "Healthshare"? We need to share it with our L1 support team.

Any support document with a few known issues with their resolution, that the L1 team can expect and resolve?

0 1
0 105

Hi!

I am looking for examples of implementations of a more robust forgot username and forgot password implementation. Does anyone have one to share, even just a link to the page so I can see how it works, or screenshots? We would like to implement a secure system for requesting username and resetting password.

2 2
0 196
Question
Neil Thaiss · Jul 28, 2021
%XML.Reader Limitations

Hi all,

Are there limitations to the size of a file or stream that %XML.Reader will parse?

I am trying to parse a large, 573MB, XML file using either the 'OpenFile' or 'OpenStream' methods, but both return errors.

When I try to use the 'OpenStream' method I get a 'ERROR #6301: SAX XML Parser Error: input ended before all started tags were ended' error',

and when I try the 'OpenFile' method I get a 'ERROR #6301: SAX XML Parser Error: <STORE>'.

0 2
0 227
Question
Warren Oyco · Jul 27, 2021
How To Pass Custom Class

I've created a custom class that extends to the standard HS.Message.PatientSearchRequest. Inside the custom class i just want to pass the data as input only.

But i am getting ERROR #6277: Type attribute, s01:AcoPatientSearchRequest, does not specify valid type for XML input tag: pRequest (ending at line 5 character 171)
</error>

I tried adding Parameter XMLIGNOREINVALIDTAG = 1; and

0 8
0 298

Hi! I am working on a project where I use record map to transform a flat file and split it into two output text file and in the future will need to split four output files.

I only want to use one target business operations instead of multiple. Is there a way to set the output file and the target folder path in my business process class?

Any advice on how I can achieve this or is this possible? Thanks!

0 5
0 289

Hello everyone,

I have a question and if you have some code, it would be lovely.

I had to create a connector which is biredictionnal. What does I mean by this?

I have to send ADT to an certain ip +port by TCP but I have to receive query A19 by this same ip+port.

Is it possible to create such a connector that can do both?

I read about pipe but i think it's too low-leveled .

Thanks,

Thomas

0 6
0 122

Hi InterSystems Architects,

Please may I know the relationship between

1. Menus, Workflows, Workflow Items, Components, Code Tables, etc

Detailed relationship diagrams, how each element in each of the above are related to another.

2. When I extracted the data. I see ID number, but they aren't unique or related. I wanted to build a relationship between them myself in the absence of documents but I am missing the critical unique primary key of each and how they are referred in another table.

0 3
1 123

Hello All

I'm running into an issue performing UPDATES that I'm not getting on INSERTS. It's probably obvious, but I'm just not seeing it and could use a little help.

I'm going over an HL7 message and depending upon varying criteria, the relevent variables will get items added to them like the following:

Set patientId = pRequest.GetValueAt("PID:3")
Set sqlColumns = sqlColumns_",patient_id"
Set sqlValues = sqlValues_",?"
Set par($i(p)) = patientId

After compiling the variables, I check to see if accession number is found in the table.

0 14
0 266

Hi all,

is there a way to remove a specific property path from a DICOM document created within Ensemble/IRIS for Health etc. I had a look at class EnsLib.DICOM.Document to see if there is something like RemoveAt.

The reason for my question resides in the need to filter certain fields for specific DICOM devices. Maybe you have an idea?

best regards,
Sebastian

0 2
0 93
Question
Ahmad Bukhtiar · Jun 10, 2021
HealthShare UCR User Roles

Hi anyone has created the user roles for UCR pls share details like if we want to create following roles what access rights should be give to each role.

UCR Admin - This user can stop/start productions, can enable/disable services, can run sql queries, can make changes in facility registries, assigning authority and other configuration.

UCR Developer - This user can add new services in the production but can not make any change in the registires and other configuraiton

0 1
2 206

We need to upgrade from Healthshare 2016.2 to HealthConnect latest but we are too far behind the current version to do an upgrade in situ.

So I need to create a new instance of HealthConnect and the copy across all the database definitions, namespaces and classes.

I know its possible to script this stuff and pull all the definitions out of the old Healthshare system and then apply them to the new HealthConnect instance.

0 3
0 169

(2021.1.0 isn't an option in the Product dropdown, but that's the version of HS I'm asking about!)

In the past I've used HS.Util.Installer.InstallBusDemo() to set up a local HealthShare environment (registry, edges, access gateway, etc.) I don't see an equivalent in HealthShare 2021.1. I tried importing the bits and pieces from a lower version but always seem to be missing something. Is there an equivalent utility to do a local setup in HS 2021.1?

Thanks,

Lori

0 2
0 164

I've poked through the class documentation and globals and I can't seem to find what I'm looking for, namely a mechanism that will give me the PropName key and value for each of the Items in an EnsLib.HL7.SearchTable definition. Is there some sort of query that will turn the list of Items in the XData SearchSpec section into a key/value pair of some sort?

For example:

0 1
0 135

I am working on tweaking our current patient load process. The roster input is in text pipe delimited format, parsed out and transforms it to a standard HS.Message.PatientSearchRequest, and send to business process for patient matching. Result is transformed into a standard ADT HL7 message using EnsLib.HL.Message class. I would like to know if there is another class I can use that will transform my output to a text flat file pipe delimited instead of HL7 format? any advice on how to do this is greatly appreciated.

Thanks!

0 2
0 206