All time

If both fields are numeric and the result of subtraction of field1-field2 is positive, only then put the result is a data field.

I am doing this within an Iris DTL.

I don't find any functions like IsNumeric(). Once I get that, I can test if field1>0 and field2>0, do the subtraction, and test if diff>0.

I just need a function to determine if they are numeric, rather than some cumbersome way like a regex where the only characters are 0-9.

I see functions in documentation but don't see them used at tests, only in WRITE statements.

Thanks,

0 10
0 160
InterSystems Developer Community is a community of 23,521 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Question
· Aug 28, 2024
JOB $SYSTEM.obj

IS THERE A WAY TO JOB A $SYSTEM.OBJ FUNCTION AND FIND IF THE JOB IS RUNNING OR FINISHED TO ASYNCHRONOUSLY CONTINUE OR HALT THE PROCESS?

1 5
0 165

It's time to announce the Winners for April! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in April:

🥇@David Hockenbroch, senior analyst, WoodWare Systems, United States
🥈@Sylvain Guilbaud, Sales Engineer, InterSystems, France
🥉@Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

Learn more about the competition and our awesome winners below.

2 2
0 130

Hi Community, we continue to gather feedback about Data Loading & Packaging. In particular, we're interested in hearing your impressions on some of the new capabilities added with InterSystems IRIS 2021.2 We'll be using this feedback to improve InterSystems IRIS, so please feel free to share any details and feedback:

>> Link to the survey (14 questions, 5 min) <<

Note: this is the same survey we already published during the contest, on Global Masters and Discord. If you already participated, you don't have to do it again. Thank you for the feedback!

0 0
0 170

Get your hands on our technology with On-Demand Experience Labs available now through November 6th. Each lab is paired with an office hour session scheduled for this week. Learn more about how you can get hands-on with our technology.

Join the office hours to get answers your questions about the labs, talk about how the technology fits into your environment, and discuss implementation. Sign up for the Office Hours/On-Demand Experience Labs today. The labs have gotten great reviews so far!

0 0
0 170

Hi Developers:

There's lots of news in this month's Developments newsletter for customers and partners. InterSystems made the Gartner Leaders Quadrant and ranked high in other analyst reports. There have been several major product releases. And the recent "AI Robotization (Python, R, Interoperability) for InterSystems IRIS"(Anton Umnikov, Eduard Lebedyuk, and Sergey Lukyanchikov) is now available on demand.

You can download the latest issue from our landing page.

0 0
0 170

Hi Community!

Here is a digest of the Developer Community postings in March 2019.

Most viewed

CachéQuality for VSCode now available 364

Studio debugger since 2018.1.1 149

Job Opportunity - Relocate from Europe to UK 137

InterSystems IRIS version 2019.1 released 127

Tar compress tool in ObjectScript 125

A Tutorial On WebSockets 122

Embedded SQL vs ObjectScript SQL. What do you prefer and why? 121

A Deep Learning Demo Kit with Python3 Binding to HealthShare (Part I) 118

Side Effects of Quit and Return Commands with $Increment, or "I.E.Repin. Unexpected..." 117

String to date 116

Behind the scene of isc-tar project 100

Using Docker with your InterSystems IRIS development repository 99

Global Data converted to CSV file 87

CSP: Dynamically Generated Table 79

Behind the scene of isc-tar project and story about Continuous Integration using Github Actions 66

Run A Deep Learning Demo with Python3 Binding to HealthShare (Part II) 62

Most voted

InterSystems Partnertag Österreich 2019 7

Adopted Bitmaps example now on Open Exchange 7

ObjectScript error handling snippets 7

Tar compress tool in ObjectScript 6

InterSystems DACH Symposium 2019 6

Synchronize Data with DSTIME 6

A Tutorial On WebSockets 4

CachéQuality for VSCode now available 3

A Deep Learning Demo Kit with Python3 Binding to HealthShare (Part I) 3

InterSystems IRIS version 2019.1 released 3

Most commented

CachéQuality for VSCode now available 36

HL7 message import to sql server 16

Studio debugger since 2018.1.1 12

Rule to validate SQL syntaxis 12

No 'Access-Control-Allow-Origin' header issue with Cors 11

Cache docker image 9

Creating multiple Record Map Records from a single HL7 message 8

Quick way to check if an SSL/TLS configuration name is valid? 7

Sending Messages on the Top of Queue 7

Ensemble to Spring Boot Java app using RabbitMQ 6

Top 10 Authors to Follow by Views

Dmitry Maslennikov, Posts, 291

Zhong Li, Posts, 180

Lily Taub, Posts, 122

Alexey Maslov, Posts, 117

Evgeny Shvarov, Posts, 99

Ponnumani Gurusamy, Posts, 87

Robert Cemper, Posts, 85

Gevorg Arutunyan, Posts, 79

Pravin Barton, Posts, 61

Stuart Byrne, Posts, 40

Top 10 Experts to Follow

Eduard Lebedyuk, Answers, +8

Aviel Klausner, Answers, +7

Alexander Koblov, Answers, +4

Kyle Baxter, Answers, +4

Vitaliy Serdtsev, Answers, +4

Jeffrey Drumm, Answers, +4

David Van De Griek, Answers, +3

Stephen Canzano, Answers, +3

Dmitry Maslennikov, Answers, +2

Robert Cemper, Answers, +2

0 0
0 170

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Leveraging Automation Tools for Deploying InterSystems IRIS Applications @ Global Summit 2024

https://www.youtube.com/embed/pxHrYN7_iKk
[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
1 169

Hi

Is there a way to generate an MD5 checksum of a file by performing a checksum against the file's parts? We potentially have to process large files and therefore cannot keep the entire file in memory. From what I understand checksum related logic is typically stateful, allowing file data to be passed through sequentially, however it appears cache script offers only stateless functions offering a simple method of generating a single checksum hash from a single string (or stream), correct me if I'm wrong?

0 2
0 167

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

0 2
0 167
Question
· Jun 16, 2024
Securing URL

Hi Guys,

Not really familiar with how to secure URLs and using SSLs, but we currently looking to change our url from http:/www to https:/www so my understanding is once we get a certificate its a matter of creating a new SSL/TLS configuration and assign the certificate to it, then what how to apply it in out URL, or do we have to do this in IIS?

Thanks

0 5
0 164

Data Analysis

This is the sequel to Data Collection. If you have not had a chance to go through and install that you should first do that.

What is provided here is the analysis for the collection of that data that was collected earlier.

In much the same way as was done in that repository you will need to import the xml that makes up this repository.

Starting at the topmost level there is a task:

Open Exchange app
5 0
1 169

Is it possible to authenticate an xDBC (ODBC/JDBC) connection to InterSystems IRIS via (a 3rd party) OAuth server?

For REST APIs this is possible, but could this be achieved with OAuth?

Out-of-the-box the ODBC/JDBC Drivers don't seem to have this option, but maybe some custom code could enable this? perhaps via Delegated Authentication and some OAuth classes customization, or some other way?

Has anyone done this already and can share how it was implemented, or someone with some guideline suggestions?

1 0
0 169
Announcement
· Nov 21, 2023
[Video] Bulk FHIR Export

Hi Developers,

Watch this video to learn about the Bulk FHIR server and client and the latest version of our Bulk FHIR implementation:

⏯ Bulk FHIR Export @ Global Summit 2023

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

1 0
0 169

Prediction of server configuration for entry

The platform server entry configuration prediction application connects to Iris in Java and uses its Integrated ML technology to analyze data such as hospital outpatient volume, number of services, number of messages, and message save time. It can predict the server configuration required for the hospital entry platform before the hospital integration platform enters, providing convenience for customers.

Open Exchange app
2 0
0 169
Question
· Apr 17, 2023
Find a specific column in a dataCombo

Hello,

I've the below datacombo definition and when selecting an item from it and make this call:

var component=zen("Component").getProperty("value");

I would get the ID (first column) which is what I'm looking for

0 0
0 169