All time
Question
· Aug 31, 2021
Understanding process jobTpe

I have a client running cache on an AIX platform. I put together a objectscript to allow for the viewing the processes running against the database using a select from SYS.Process. One of the values I want in the view of the processes information is Jobtype but I want to convert it from the numeric value to a string value. In the Intersystems documentation there is a reference to an include file $syPidTab.inc that should include macros that make this translation. I have not been able to track down this include file.

0 2
0 227
InterSystems Developer Community is a community of 25,647 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Announcement
· Oct 28, 2020
New Video: ZPMshow Demo

Hi Community,

Please welcome the new video recorded by @Robert Cemper on InterSystems Developers YouTube:

⏯ ZPMshow Demo

https://www.youtube.com/embed/y_RYE9n_EWw
[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]

Open Exchange app
3 0
0 229
Announcement
· Aug 26, 2019
Learning News: August 2019

Now available from InterSystems Learning Services: the August 2019 newsletter!

See what's going on with Learning Services at the Global Summit, including:

  • Achieve certification in one or more subjects

  • Dive into InterSystems IRIS™ on your own machine

  • Attend a Personal Training session to get your questions answers

  • Optimize your training plan for yourself or members of your team

  • Get steep discounts on classroom courses

0 0
0 229

I am trying to help another group within our organization access a SQL Table that I have created to populate Epic Department Data within our environment and came across the ability to use SQL Seach REST Interface using iKnow.

However, I am having issues trying to get it to work via POSTMAN before I hand off the solution...

the POST URL... https://<servername>/api/iKnow/latest/TESTCLIN/table/osuwmc_Epic_Clarity.DepartmentMaster/search

where osuwmc_Epic_Clarity.DepartmentMaster is the table

In the body...

2 15
1 213

For 15 over years I have been playing with ways to speed up the way I use InterSystems systems and technology via AutoHotkey scripting. As a power keyboard user (I avoid my mouse when possible) I found it very helpful to set up hotkeys to get to my most frequently accessed systems and research utilities as quickly as possible. While I have used this approach for many years, this is the first time that I am introducing my approach and a customer-facing hotkey script to the D.C. and OEx...

Open Exchange app
7 1
1 208

We need to generate a PDF file from an HL7 message as it passes through an Ensemble production. Looking for examples, tutorials, documentation aligned to our scenario.

We are currently using Ensemble (so can't use InterSystems Reports at the moment). Thinking Zen reports...

We can get from HL7 to XML OK, following Introduction to InterSystems Health Connect - YouTube (see c.1:11:00-1:13:00)

1 2
0 226

Hello everyone,

I have an issue related to Visual Studio Code and its InterSystems extension when exporting routines from the database to the file system.

The code entered via the terminal editor is encoded in DOS code page 437, but when I export it to my file system, even if I set the file opening to DOS CP 437, the accented characters which are two bytes long cause problems.

0 0
0 228

Hi Developers,

This September, you've posted 78 new questions on the Developer Community:

Questions

0 0
0 228
Question
· Aug 18, 2023
GetEnviron() on CentOS

Why I'm not getting OS level environmental variable in the IRIS for below actions:

CentOS termial:

[root@]# export TEST="test"
[root@]# echo $TEST
test
[root@]# iris session MYIRIS

Node: myiris01, Instance: MYIRIS

Username: User
Password: ********
NSPACE>s test = $SYSTEM.Util.GetEnviron("TEST")

NSPACE>w test

NSPACE>

0 8
0 220
Question
· Jan 30, 2023
SQL Query Help in $ListGet

Hi All,

I want to run an SQL like below

Select ID,Rollno,Marks,Name,Section,Teacher from Marks left outer join Student on Marks.StudentID=Student.ID

Now, the Student.ID is having the encrypted value which is not matching with Marks.StudentID (as this is clear value).

I can get the clear value using encrypted value as follow

^StoreValue("EncryptStudentID",Student.ID)=$LB("123"). That 123 is the clear Student.ID which I need to match in SQL query (ON clause).

0 2
0 226

Hello!

I'm new to the system I'm working on, and I have a part of a statement that needs to grab the previous month.

....and MONTH(TX3.date_of_service)= MONTH(dateadd(mm,-1,GETDATE()))

However, when it hits January, I'm left with month 0.

Does anyone know a workaround to grab December of the previous year, while still functioning normally for the rest of the current year.

Thank you!

0 4
0 224

Hey Developers,

Join us to review the latest additions to Health Insight and future product plans for analytics in HealthShare:

⏯ Health Insight New and Next @ Global Summit 2022

https://www.youtube.com/embed/A1LPBSEWRjQ
[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 228

Hi developers, 

We've incorporated VS Code's support for multiple concurrent debug sessions and consoles into the latest release of Serenji. 

So if you're working with processes that relate or are dependent on each other, you can now debug them together. Just launch a second Serenji debug session (F5) whilst the first one is still active. 

This short video below shows how it works. We hope you find this feature useful! 

Laurel 

Serenji 3.2 multiple concurrent debug sessions

0 0
0 228

Hello,

I am a clinician and we use Trakcare Lab LIMS at our institution.

We understand histopathology reports are directly typed, stored and uploaded directly to the LIMS.

For clinical audit purpose we need to download these reports directly in text format in bulk. Can anyone offer some technical assistance in retrieval of these histopathology reports? Is there any script that can be run to access, retrieve and download these reports?

0 1
0 227

Let's say I have a persistent class Sales.
I need to create a report that shows the amount of sales for each branch.
By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown.
Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?

0 3
0 225