#HealthShare

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan.  My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect.  If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for.

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.

set performInsert = 1
set performUpdate = 0
...
set sqlQueryText = "SELECT id FROM table_name WHERE accession_number= ?"
set sc = ..Adapter.ExecuteQuery(.resultSet,sqlQueryText,accessionNumber)

  if $$$ISERR(sc) {return sc}

  while (resultSet.%Next() '= 0){
    Set performUpdate = 1
    Set performInsert = 0
  }

  Set par = p

Title.

I've searched the forum and documentation with no luck.  Thanks!

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.

Has anyone done anything like this before that they would be happy to share with me so I could use it as a starting point rather than re-invent the wheel again?

Regards

MikeD

Hi,

We have an immediate requirement for an experienced Intersystems Ensemble/Healthshare Connect developer to join our team with a good grounding programming ,Healthcare Integration and experience with InterSystems Ensemble/Healthshare Health Connect.

Contractor or Full Time.

 Please if you are interested and need more info contact :

Perez.bertamaria@srft.nhs.uk

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!

Hello All,

InterSystems Certification has designed another certification exam and we need input from our community to help validate the exam topics. Here's your chance to have your say in the knowledge, skills, and abilities that a certified InterSystems CCR Technical Implementation Specialist should possess. 

Here's the exam title and the definition:

InterSystems CCR Technical Implementation Specialist

A development professional who:

• Uses Tier 1 CCRs to document and process change workflow
• Makes code changes in their Integrated Development Environment of choice.

Hello Again,

InterSystems Certification is still looking for people to beta test the HealthShare Patient Index Technical Specialist Certification exam. We have extended the deadline of the beta test to July 6th, 2021. For details, see the original announcement.

Thank you!

Hello!

The schedule into October 2021 for live virtual classroom training with hands-on exercises is available at classroom.intersystems.com.

In particular, we'd like to highlight a few courses currently only available once through October:

• July 13-15: HealthShare Patient Index
• July 19-23: InterSystems Change Control - Tier 1 Basics (CCR)
• September 13-17: Using InterSystems Embedded Analytics
• September 14-15:

Click here to register for a course!

As always, we also provide the option to schedule a class specific to your company. Simply fill out the contact form

(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

Hello All,

InterSystems Certification has developed a certification exam for HealthShare Patient Index and, if you match the exam candidate description given below, we would like you to beta test the exam.

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:

<Items>
<Item DocType=""  PropName="MSHTypeName" Unselective="true">{1:9.1}_"_"_{1:9.2}</Item>
<Item DocType=""  PropName="MSHControlID" PropType='String:CaseSensitive' >{1:10}</Item>
<Item DocType=""  PropName="PatientID"   >[PID:2.1]</Item>
<Item DocType=""  PropName="PatientID"   >[PID:3().1]</Item>
<Item DocType=""  PropName="PatientID"   >[PID:4().1]</Item>
<Item DocType=""  PropName="PatientName" >[PID:5()]</Item>
<Item DocType=""  PropName="PatientAcct" >[PID:18.1]</Item>
</Items>

I need assistance to delete an instance of HealthShare that I am sure it way out of date.  From the VM Server Control Panel when I try to Uninstall, I get the error Message: "Error: Could not detect INSTANCE name!" 

Are there commands in SQL that may help uninstall the instance of the application?  Other Suggestions?  

Hello everyone :-) A colleague wants to use data got from a stream into another type of object: %xsd.base64Binary (related to a webservice context).
His code works for regular data, but the following error appears when parsing large streams (~43 MB): "ERREUR #5002: Erreur Cache:    <MAXSTRING>"

Here is below his code:

Class (...).StampDataRequest Extends Ens.Request [ ProcedureBlock ]
{
…

Property DocumentData As %xsd.base64Binary;
…

}

Method OnRequest(pRequest As Ens.StreamContainer, Output pResponse As Ens.Response) As %Status
{              
       ...

       set fileStream = ##class(

I am looking for if any configurations are available to display the Lab Results Flag from abnormal to low or high based on the results. Below is the snapshot of the example, Result is 1.5 and reference range is 0.28-1, So if i want to display this as High, are there any config available in track care or layout editor. 

Hello,

I created a custom business operation to copy PDF files in Intersystems Healthshare. To copy the files I used:

$ZF(-100, "", "cp", "-f", tSource, tTarget)

tSource contains the source file e.g. "/opt/var/data/dir/1821008687135422926_5849146876.pdf".

tTargetSource contains the target file "/opt/targetdir/Müller_Jörg_1821008687.pdf".

Copying files without german Umlaute works fine (e.g Smith_Robert_1821081542.pdf), but when the string contains special characters like "ä", "ö", "ü" or even  "ß" copying is not successful.

Awhile back the Developer community helped me with a situation I was having... How to loop through a Repeating Segment and Single Filed, example OBX().5, within a Business Process Rule and compare it against a Data Lookup table.

Well now I need to take it a step further. I need a way to loop through OBR() segment, and loop through OBR().4() and the subfield 4.1 and compare it to a Data Lookup table.

So I thought I could copy my existing function code and add another level to it, but its not returning what I would expect.

Hi all,

I'm wondering if is possible to get the values of itself to run a query.

I want to create some query to find a value into a %Persistent class but each one use diferent values.

Class Kurro.MyClass Extends %Persistent
{

/// Key of process
Property KeyProcess As %String(MAXLEN = "");

/// Specialist
Property CodeSpecialist As %String;

/// Provider
Property CodeProvider As %String;

/// Center
Property CodeCenter As %String;

/// Date
Property Date As %TimeStamp;

/// IdList
Property IdList As %String;

/// IdProcess
Property IdProcess As %String;

/// Duration
Property Duration As %String;

Query GetInfo(pObject AS Kurro.MyClass) As %SQLQuery(CONTAINID = 1, ROWSPEC = "IdList:%String,IdProcess:%String,Duration:%String")
{
    SELECT IdList, IdProcess, Duration
    FROM Kurro.MyClass
    WHERE KeyProcess = :pObject.KeyProcess
    AND CodeSpecialist = :pObject.CodeSpecialist
    AND CodeProvider = :pObject.CodeProvider
    AND CodeCenter = :pObject.CodeCenter
    AND Date = :pObject.Date
}

}

Hello Community,

I need to create a new menu in the inside viewer to create a ZEN screen to make an external call outside the SDA, how can I do this or configure a new menu by calling a .cls?

Hi,

we have a EnsLib.Workflow.TaskRequest wich is been send to an operation. The Task request contains a simple object, for that we´ve extendd EnsLib.Workflow.TaskRequest and added the object as an aditional property. The request is successfully created. But how to access the contents of this object from within the user portal when showing the task.

Our TaskRequest contains an object named Patient with some properties. We´d like to display the contents in the tasks description area. WE´ve created an additional template but have a hard time to access the values of the patient object.

We are seeing more and more customers being lured with latest infrastructure technologies, particularly Composable Infrastructure. Coming with all sorts of data center consolidations and costs savings.

Question is: are there any concerns for HealthShare/TrakCare being run on these platforms or things to look out for? Anyone out there, already on these platforms?

To be more specific this is HPe Synergy with 480 Compute blades booting as bare metal.

Regards;

Anzelem.

If you work with Portal on multiple instances of Caché, Ensemble or HealthShare you might find it useful to set the System Mode of the various instances, so as to give yourself a visual reminder of the role of the one you're currently working on.

For instance:

I was interested in accessing IRIS (Healthshare) using Python.  I found instructions how to this here: https://github.com/intersystems/quickstarts-python/tree/master/Solution…

The installation went well using pip and when python executes "import irisnative" it works fine.  It just fails with a connection timeout when I try "irisnative.createConnection(...)."  Below is my code:

import irisnative

# Modify connection info based on your environment
ip = "10.10.74.225"   # VPN connection to server
port = 58772
namespace = "HSREGISTRY"
username = "my-user"
password = "secret"

# create database connection and IRIS instance
connection = irisnative.createConnection(ip,port,namespace,username,password)
dbnative = irisnative.createIris(connection)

Hello, Community!

Did you know that InterSystems Learning Services has a comprehensive exam for Technical Specialists on HealthShare Unified Care Record? It really is the gold standard to show that you have the skills and abilities required of competent technical specialists in Unified Care Record. Depending where you are in your career, it can be a valuable door opener or escalator to new opportunities. 

Interested? 

1. Here's what's on the exam. 

2. Here's the publishable credential, valid for 5 years, that you get when you pass the exam.

3.

Does anyone know how to disable the auto-refresh in Healthshare, especially for Message viewer , Business process designer, DTL editor pages?  

These pages in management portal refresh every 15min( i.e. as per the session time out setting) . I tried to  set the following two configs to disable the auto refresh but both had no impact. 

set ^EnsPortal("DisableInactivityTimeout","Portal") = 1

set ^%SYS("Portal","EnableAutoRefresh") = 1

Thank you for your help. 

Mary

My dilemma is that I'm working with a file that has three different data records plus the header and trailer.  The record type is in positions 21-23.  The header and trailer have spaces in positions 1-20.  The data records have a variable data in positions 1-20.

I tried to use pattern matching in the leading data field however that field is treated as a literal string for matching.

Dear All CCR Users

Please note that All Perforce Systems will be unavailable from 6:00 p.m. EST on Friday, April 9th, 2021 to 3:00 p.m. EST on Sunday, April 11th, 2021.
During this time users will be impacted when trying to perform Perforce Activities when using the CCR Application.

CCR actions you can do while the InterSystems Perforce Server is unavailable:

• Create a new CCR and markPrepComplete
• Open the BASE Environment and Checkout changes
• Bundle and Upload (You will receive a message similar to the following: Attempting to upload ItemSet to CCR Server for ISCX17999.

We are still looking for 5-6 people to review the design for the HealthShare Patient Index Technical Specialist Certification exam. for details, see the original announcement.

Regards --- Kate Schell

 Hi, I would like to ask how to develop the socket API with HealthShare, such as developing the socket external BS, and the socket-call BO. Thx!

Three new sets of maintenance releases are now available: 

• Caché  2018.1.5, Ensemble 2018.1.5, and HSAP 2018.1.5
• InterSystems IRIS 2019.1.2, IRIS for Health 2019.1.2, and HealthShare Health Connect 2019.1.2
• InterSystems IRIS 2020.1.1, IRIS for Health 2020.1.1, and HealthShare Health Connect 2020.1.1

Installation kits and containers can be downloaded from the WRC Software Distribution site.

These are maintenance releases with many updates across a wide variety of areas.