Hello My Friends,

I have a question how to use order by %DLIST, this is my code:

SELECT

$ListToString(%DLIST(DISTINCT MRDIA_ICDCode_DR->MRCID_Code),', ' ) ICDX,

$ListToString(%DLIST(DISTINCT (MRDIA_ICDCode_DR->MRCID_Desc || ' (' || MRDIA_DiagnosisType_DR->DTYP_Code || ')')),', ' ) Diagnose

FROM SQLUser.PA_Adm

LEFT JOIN SQLUser.PA_AdmInsurance ON (PAADM_RowID = INS_ParRef AND INS_Rank = 1)

LEFT JOIN SQLUser.PA_AdmPackage ON (PAADM_RowID = PACK_ParRef)

LEFT JOIN SQLUser.MR_Adm on MRADM_ADM_DR = PAADM_RowID

0 0
0 41

Hi everybody,

I'm modifying a REST interface for a client but it seems impossible to me to modify HTTP Response Status and including custom HTTP Headers either.

My dispatch class (extending %CSP.REST) is contacted through a POST request and the latter is processed in a custom class (extending %CSP.REST as well) accessed as shown in the example below:

<Route Url="/test" Method="POST" Call="Custom.Test:Process" />

Within the processing class I tried executing the following statements with no success:

0 6
0 91

The InterSystems Certification Team is building an InterSystems TrakCare Integration certification exam and is looking for Subject Matter Experts (SMEs) from our community to help write and review questions. You, as a valued InterSystems community member, know the challenges of working with our technology and what it takes to be successful at your job. A work assignment will typically involve writing 15 assigned questions and reviewing 15 assigned directly to you.

1 0
0 60

Hy Friends,

I have a question, how to change multiple rows into 1 row

This data already in the right order, but I need to change the Diagnose into 1 column with this order 1,2,3,4

So it should be Acute...,Fever..., Dyspepsia, Dengue fever

Does anyone could help me ?

Thank You

Best Regards,

Steven Henry

0 8
0 182

Hi. I am struggling to understand the meaning of different elements of an order in my hospital's EHR.

Page: EPR > All Orders

Question: What is the difference between Start Date and Date Executed and Order End Date? If an order was started on Monday and executeed on Tuesday.. does this mean the patient received the order on Monday or Tuesday? and what is End date?

Also, how do I interpret order status? What is the difference between discontinued, verified, and executed?

0 1
0 88

We are investigating option of populating .pdf Custom Properties Name-Value pairs with episode/billing information from the TrakCare database, using Logi Reports. Resulting .pdf would be stored in a designated network folder. Would welcome suggestions on feasibility / technique to achieve / code to achieve (or alternative approach).

Intent is for further (watcher) process to detect new .pdf file in network folder and determine actions and/or process flow based on Name-Value pair information in pdf's Custom Properties.

0 2
0 145

Hi all,

Does anybody have the same issue?

$ZF(-100) to run python script not work when directly execute in studio or in storedproc called by TrakCare, but can work when do in iris session.

The python script imports a "barcode" package. It seems that when directly execute in studio or in storedproc called by TrakCare, the package can not be imported.

1 2
0 166

The InterSystems Certification Team is building an InterSystems TrakCare Reports certification exam and is looking for Subject Matter Experts (SMEs) from our community to help write and review questions. You, as a valued InterSystems community member, know the challenges of working with our technology and what it takes to be successful at your job. A work assignment will typically involve writing 15 assigned questions and reviewing 15 assigned directly to you.

2 0
0 147

Hello Everyone,

The Certification Team of InterSystems Learning Services is in the process of developing an exam focusing on creating and working with TrakCare Integration, and we need input from our InterSystems TrakCare community. Your input will be used to evaluate and establish the contents of the exam.

How do I provide my input? We will provide a list of job tasks. You will rate them on their importance as well as other factors.

How much effort is involved? It takes about 15-20 minutes to fill out the survey.

1 0
1 181

Hi Developers,

Watch this video to learn about some recent machine learning engagements InterSystems is driving, including TrakCare predictive analytics and examples from our Developer Community and partners:

Artificial Intelligence Healthcare Solutions - Time to Take Action @ Global Summit 2023

https://www.youtube.com/embed/Xminu9GmwEc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 221

Hey Developers,

Watch this video to learn how InterSystems TrakCare connects care teams, breaks down data barriers and improves safety, efficiency, and the patient experience.

What is InterSystems TrakCare

https://www.youtube.com/embed/w9HcEQ6GFvE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 1
0 431

Hello Everyone,

The Certification Team of InterSystems Learning Services is in the process of developing an exam focusing on creating and working with TrakCare Reports, and we need input from our InterSystems TrakCare community. Your input will be used to evaluate and establish the contents of the exam.

How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance as well as other factors.

How much effort is involved? It takes about 10-15 minutes to fill out the survey.

How can I access the survey? You can access it here:

InterSystems TrakCare Reports Specialist

1 0
0 202

Hello Hello,

I am building a patient room door signage for a customer who has Trakcare already deployed. The app will reflect patient's data upon admission in the hospital (eg. name, male/female, doctor, mrn, special diet, etc...)

When the patient is discharged, "something" will tell the app that the patient was discharged and the screen will be reset.

Appreciate any kind of direction and help.

Thank you!

0 0
0 193

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

Introduction to InterSystems Products

https://www.youtube.com/embed/oUhOUaUrh-s
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
1 220

Hi,

I am trying to load all the data tables from one iris server to a client server but some of the tables data failing to load all the time. But I can load around 100 tables successfully but 8 to 10 tables are failing all the time. I made an IRIS odbc connection using odbc driver to load the data from tables.

Also I can see read server loop error message on the iris server side as the same time the table loading fails.

Please find the screen shot attached which shows the error on client server.

0 15
0 1K

Hey Developers,

Watch this video to learn about InterSystems TrakCare Innovation Toolkit which is a free download that enables TrakCare users to quickly access their data in standard HL7® FHIR® format, making the system of record a system of transformation:

Introduction to the TrakCare Innovation Toolkit @ Global Summit 2022

https://www.youtube.com/embed/hIGE5GdJaTE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 356

I have a question for people currently in the community who support TrakCare implementations.

Are you all currently working through the migration from Crystal/Zen over to Logi Reports?

What are you plans for the Zen reports you can't migration off for example the HTML letter template?

I have spoken with a few people regarding this topic but starting to get concerned if there is a call in the near future to decommission ZEN/

0 1
0 208
Question
· Dec 20, 2022
TrakCare iprint

Hi,

I'm trying to configure iprint for trakcare.

My trakcare runs on linux IRIS(SUSE).

iprint is from MicroFocus [previously Novell]

iprint is a print facility that many printers support where there is a virtual queue for each AD user.

You can log onto any iprint printer using your AD credentials and you can access your virtual print queue. You can then physical print from that virtual queue.

Has anyone configured this for their trakcare?
In order to do this I need to:
- map each trakcare user to their equivalent AD user

0 0
0 171
Article
· Oct 24, 2022 10m read
PerfTools IO Test Suite

Purpose

This set of tools (RanRead, RanWrite, and the combined RanIO) is used to generate random read and write events within a database (or pair of databases) to test the IO speed of IRIS running on a specified hardware setup. While Read operations can be measured in the usual Input/Output operations per second (IOPS) since they're direct disk reads, write events are sent to the database and thus their physical writes are managed by IRIS's write daemon.

Results gathered from the IO tests will vary from configuration to configuration based on the IO sub-system. Before running these tests, ensure corresponding operating system and storage level monitoring are configured to capture IO performance metrics for later analysis. The suggested method is by running the System Performance tool that comes bundled within IRIS. Please note that this is an update to a previous release, which can be found here.

5 1
1 742