New post

#HealthShare

39

InterSystems HealthShare is a healthcare informatics platform for hospitals, integrated delivery networks (IDNs) and regional and national health information exchanges (HIE). HealthShare includes health information exchange, data aggregation, workflow, text analysis, and analytics technology.

Learn more

Hi!

I have a question regarding SQL insert/update from the mananger portal's SQL window.

I am trying to do an insert with a value that contains multiple spaces ($32) between two words. This is needed for a comparative reason. But the spaces are automatically trimmed away all the time. How should I write to keep these?

Example:

Insert into TableA
(MyColumn) Values('xxxx yyyy')

then the spaces are trimmed away and it becomes: 'xxxx yyyy'

But I want to keep the spaces. How do I get around the problem?

Regards,
Michael

0 4
0 128

Hi there have been various posts around how to clean up globals without parent data but none have gone into how you solve these issues.

Our database is approaching 600gb in size so i am looking into how to reduce this.

We use standard purge tasks.

Our cache stream class has a global size of 2463243 from running global size so it is what i would like to tackle first.

1) is there any way i can find based on my oldest message session for where most of these globals

0 3
0 307
Question
Jordan Everett · Aug 1, 2022
Email Template

Does anyone have any pointers or maybe familiarity of making Email templates in Objectscript?

I'm currently trying to implement Televisits with our system and am needing to send an email to the patient. I'd like to make it a nicer looking email which will require a good amount of inline CSS. I currently have a method, but is very much a sore sight for the eyes.

I was wondering if there was a way I could use Embedded HTML and pass that into the DO msg.TextData.Write command with the ##class(%Net.MailMessage)?

0 2
0 207

I running a query and get the results inside a result set. Now I have to iterate through the result set many times. From the doc I've seen only the Next() method. Is there a way to reset the cursor? Otherwise what is a good data structure to save multiple rows of a table?

My code in this case is something like this:

set sql = "SELECT * FROM MY_TABLE WHERE X= '"_Y_"'"
set status = ..Adapter.ExecuteQuery(.rs, sql)
// somehow iterate the rs more than one time

0 6
1 703

Hi guys,

Does rebuilding of Data Quality Manager cubes affect patient index linkage definition data?

What I want to understand is, does DQM have any negative impact on the data each time you rebuild the cubes.

Additionally, if I make changes to the cube and rebuild it..will this have any impact on the original data?

0 6
0 190
Question
Paul Hula · Nov 2, 2016
Healthshare FHIR Subscriptions

Hello All,

Having a recent project to create a FHIR repository, I want to know (as looking at the code) if HealthShare FHIR implementaton supports subscriptions?. I know it records the subscriptions ok, BUT does it handle sending the subscription out (based on the tags) to an endpoint (i.e. when a new FHIR request commits data that would trigger the subscription) ?, I'm 50% it doesn't, but would rather find out for sure before shoe horning something in.

Regards

1 9
0 894

Hi:

Had an issue after upgrading to 2021.1 where search bar for interoability will bring up "INVALID ACTION".

On upgrading to 2022.1 this still occurs.

It did not occur on another environement that was upgraded from 2017.2 straight to 2022.1

Is there any solution? Loads up SYS in url rather than customnamespacename

Issue is the url for instance brings through ip/csp/sys/EnsPortal.DTLEditor.zen?$NAMESPACE=X

0 1
0 146

Can I please check if anyone know why the data base resource is created differently when creating a namespace after specifically selecting it to use the default resource %DB_%DEFAULT?

I created a namespace and when creating the DB I selected the option to use the default resource

When the namespace creation was complete , database is using a new resource instead of the default.

0 2
0 144

Hi,

I'm trying to load some data into IRIS using LOAD DATA in the IRIS terminal however I am getting blocked by this error. I have read the documentation on this page trying to set up a gateway connection but get the same Connection cannot be established error.

This is what is in the %Java Server activity log

0 2
0 217

What's a good way to add a custom hyperlink to a table item in Clinical Viewer (CV2)? I am customizing the Diagnostic Studies page, and have a custom transform that returns the HTML code for the hyperlink. The hyperlink is supposed to open a custom CSP page in a new window or tab.

Using the layout editor, I then tried adding several "items" to the table like an Icon or External Viewer Link, and use the custom transform to get the hyperlink, but these items only show up as plain text and do not link to any page. How do I turn these items into a hyperlink?

0 2
0 197

Hi All,

When I log into Backup mirror member it becomes too slow to load and navigate, I tried to check message log and I saw the error message about Database mirror latency and database disk issue which when I check it looks fine to me. Please have a look at the below screenshots and advise what the issue could be.

When I run df -h through SSH :

200G is the volume size, 194G is used space, 6.5G is available space and 97% IS %Use

0 3
0 208

Is it a good practice to set the MAXLEN value of %Library.String property type? Will it lead to wasted storage if its not really using it?

For example, I have to store a 5 characters long string into the below str field. Which of the statement is recommended?

Property str As %String;

vs

Property str As %String(MAXLEN="5");

0 2
0 423

I'm hoping someone here has some tips. I'm trying to filter by d/t in a routing rule. Basically if before a specific d/t, send to one feed. If after, send to another. The d/t time is in a yyyymmddhhmmss format. I've tried a couple things but can't get it to work as expected. Any tips to accomplish this would be appreciated.

0 2
0 117

Hi all!

I'm currently trying to find out how to have one Web Gateway route to multiple servers Management Portal. The only thing that I have come up with so far is to potentially make different routes per server?

I have a development, test, and production server and I want to use the same Gateway server using IIS to do SSL/TLS encryption for the CSP pages.

Any ideas or recommendations to pull this off?

0 4
0 189
Question
Warren Oyco · Jun 13, 2022
Comparing Dates

Hi,

Any suggestion on how to compare dates? Below is my code but it does not seem to work.

USER>w $zdate(zdateh(x,8),1) > $zdate($zdateh(y,8),1)

When I set x to "06/01/2022" and set y to "04/01/2022" gives me an output of 1

When I set x to "09/01/2019" and set y to "04/1/2022" still gives me an output of 1

Any help is appreciated.

Thanks!

0 7
0 272

I have been asked if we can capture the FHIR request and responses.

My first thought was to look at the ODS NameSpace to see if there was already a table with this info being written to.

There are a couple of tables that looked promising HS_FHIRServer_Interop.Request and HS_FHIRServer_Interop.Response. However, they did not pan out.

Is there a table which is capturing the request and responses by chance?

0 2
1 156

Hi my fellows camrades,

I have a question that seems really simple but it's quite a pain in my ass right now.

I had to rename (take a file from a directory and move it to another) which is a .hl7. Whenever this file has been displaced, I have to change the extension from .hl7 to .OK without using the rename method. Maybe using the attribut?

Do you have any ideas how I could do it?

This should follow the step i have explained right before.

I have a service to take the file but i need an operation to rename it then change his name.

0 2
0 227

Hi Team

I have enabled Data Quality manager on InterSystems healthshare Patient Index and the SSN field holds south african Identity numbers on our system.

I would like to modify the rule to validate according to South African ID number and not SSN. Data quality manager classifies this South African Identity numbers as Invalid because the rule is based on SSN.

Please see the current and default SSN rule below and advise how I can go about accomplishing this task, if anyone has that rule please share how it's done.

0 3
0 144

Hi All,

I have been given the following xml class file with objectscript code that has methods that I need for file conversions. These method implementations will do necessary conversions but I don't know how to add it to Iris studio and run it as a task or maybe if it must be put on any location and call each method from the terminal and even if so how do I then call it.

Please advise how to go about this.

0 6
0 169

Hi All,

We have a requirement for one webpage that should be access in our VPN with out authentication. If it asks user name password that also fine.

This page should be a dashboard for the ensemble health monitoring. Support Team seating Area we have big SMART Monitor which always shows this webpage. Support engineers keep on eye on this monitor, if it shows action required then . they will act upon immediately. Expecting some widgets like

3 2
0 302