All time

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 221
InterSystems Developer Community is a community of 25,569 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hey Community!

New video is already waiting on InterSystems Developers YouTube:

⏯ Introducing the InterSystems IRIS Smart Factory Starter Pack for Manufacturing

https://www.youtube.com/embed/ip2si0XpbFs
[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
0 225

Hey Community,

Join the next InterSystems webinar "Implementing Your Data Fabric with InterSystems IRIS" on June 22 at 11:00 AM EDT to learn:

  • How you can access, transform, and harmonize data from multiple sources, on demand, and make it usable and actionable for a wide variety of business applications at the convergence of transactions and analytics.
  • Why leading analysts are predicting that data fabrics are the future of data management, and how a modern data platform can speed and simplify these kinds of initiatives.
  • How the features and benefits in the new release of InterSystems IRIS® data platform and InterSystems IRIS for Health™ 2021.1 can help your organization.

2 0
0 225

Hey Developers,

Enjoy watching the presentation of the IRIS-REST-API-DATABASEMANAGER app that allows you to create persistent Tables and Data in InterSystems Cache Database:

⏯ IRIS-REST-API-DATABASEMANAGER Demo

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

7 1
0 205
Article
· Mar 2, 2021 1m read
Vote for us 
Hotel Overbooking in hospitality industry

This is the first InterStstems programming contest that we participated in! Come check out and vote for us!

3 1
0 205

Hi Community!

Please welcome the new video on InterSystems Developers YouTube:

⏯ Get InterSystems IRIS from the Docker Store

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

Hi

My HIS System is a Microservice architecture base dubbo. To call remote service must through dubbo rpc.

But , I canot direct call his's dubbo service because ensemble cannot support dubbo protocol.

So I want to add support to ensemble.

where Can I start?

Does ensemble has low level interface like dll or linux so, I can add dubbo support to the ensemble just by implementing these interfaces.

I known java Gateway maybe ok, but I want to direct not throught middle layer to do this.

0 1
0 224
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 225

Since .Net has a unified package manager system (Nuget.org) why doesn't Intersystems create and add a nuget package (.nupkg) containing the InterSystems.Data.IRISClient.dll file.

This would make it easier for external .net developers to obtain the package for creating tools and/or applications that utilize Iris/Iris4Health

Can Intersystems create a nuget package?

1 5
0 219

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 222

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 222
Question
· Apr 12, 2024
HowTo VSCode O

Hello all !!! I have a question: i heard it is possible to write Object Script code for Intersystems in VSCode. How it is possible to connect the InterSystems terminal to VSCode terminal ? I heard there should be a special docker. Currently i am trying to run a simple code which will communicate with the user through the terminal but it throws an error. thank you in advance for the answer !

0 3
0 221

IRIS is known to have a built-in Python bridge and even allows you to write Python server code but what about JavaScript? Let's say I need a JavaScript expression interpreter. What would you recommend as the most effective way to get one? It is highly desirable that the solution does not require administrator privileges and uses in-process communication (I mean not http and not unix-specific interprocess-communication via command line)

0 2
0 222

Hi,

Looking for some guidance on setting up IRIS to use single sign on to authenticate with ADFS.

We have a request for users to automatically launch IRIS without the need to login, the user will be authenticated by Single Sign on (SSO) against ADFS.

Do we need to have a authorization server as well as a client, ADFS will handle all the authentication side, so would it be a case of configuring IRIS client up to communicate with ADFS, following the link below?

0 0
0 224

Any ideas on how this can be solved?

I need to use it with some Unicode text, in Docker image. And get this error. And documentation says nothing about it.

USER>do $zf(-100, "/SHELL", "echo", "test")
test

USER>do $zf(-100, "/SHELL", "echo", "test тест")

DO $ZF(-100, "/SHELL", "echo", "test тест")
^
<TRANSLATE>

I know that it works in some Linux environments without Docker, but no idea where is the difference.

0 2
0 222

Listen to CEO George James chat with Derek Robinson, host of the InterSystems DataPoints podcast talk about source control, developer tools and how our solutions are beneficial for InterSystems IRIS users.

 

In this short 17 minute episode, George and Derek discuss our work with developer tools, and how choosing the right source control can provide users with a seamless solution - which is why Deltanji is seen as the go-to source control for InterSystems IRIS users.

Listen now on the InterSystems website > https://bit.ly/3Jp5py5
or wherever you get your podcasts - just search for 'InterSystems DataPoints'.

3 0
0 224

Hi developers!

If you missed our presentation at the InterSystems UK&I Summit and our demo during the Source Control roundtable, but you still want to find out more about source control for Interoperability Productions... there’s another chance to see it at our User Group Session next Thursday, November 3rd at 3pm (GMT). 

The new driver enables highly granular management of Interoperability Productions with tight integration into the InterSystems IRIS management management portal. 

Sign up via eventbrite here >> https://bit.ly/3yqzfvS

Open Exchange app
4 0
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 224
Question
· Aug 25, 2022
SAM - Adding node_exporter

Note sure if anyone would know this.... But I presented my team with a Proof of Concept of running SAM to monitor our IRIS Development and Test Clusters. In talking with them we would like additional OS metrics that aren't provided by what is built into SAM. Looking at more OS detail I found node_exporter from Promethus. I added node_exporter to our server that we want to monitor, but then tried to config isc_prometheus.yml to use node_exporter. That did not go well and when I restarted SAM, it would not download the built in metrics to SAM.

0 3
0 221