All time
InterSystems Developer Community is a community of 26,019 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi, Community!

Please find a new session recording from Global Summit 2017:

Optimizing SQL Queries

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

Has anyone tried adding syntax highlighting to GitHub for Caché CLS files?

Looking at the list of supported languages and extensions...

https://github.com/github/linguist/blob/master/lib/linguist/languages.yml

It looks like Mumps is supported, and there is also an existing language with a .cls extension, which would account for why I see some very odd highlighting going on with some of my code.

There is a page on contributing a new language here...

1 6
0 496

NewBie's Corner Session 6 If and Kill commands

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Click on the Caché Cube in your system tray and select Terminal to try out the commands.

As in other computer programming languages, the If command is the primary decision makes.

If command with numeric operands

0 0
0 502

Two extended maintenance releases of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect are now available.

✅ 2022.1.4

Release 2022.1.4 provides bug fixes for any of the previous 2022.1.x releases.

You can find the detailed change lists / upgrade checklists on these pages:

0 1
0 481

Hello everyone!
I need to build something that will receive a REST request. As of now I have tried my luck with using an EnsLib.HTTP.InboundAdapter. But i am not so sure how I am supposed to configure it to be able to receive the REST request together with the JSON body.
I have specified the OnProcessInput in the adapter so that it receives a GlobalCharacterStream. However, I have not had any good luck finding out to actually make the request to the EnsLib.HTTP.InboundAdapter.

0 8
0 493

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

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

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria
🥈 @Luis Angel Pérez Ramos, Sales Engineer, InterSystems, Spain
🥉 @Pietro Montorfano , Systems Management Specialist, InterSystems, Italy

Learn more about the competition and our awesome winners below.

6 5
0 401

InterSystems technologies are renowned for their high performing databases, which support the systems and operations of many organisations. However a key ingredient to this success is the quality and maintainability of their code.

The quality of code can impact everything from speed and ease of fixing bugs and making enhancements, to the overall performance of your organization and your ability to get ahead in the marketplace.

By ensuring your code is maintainable, you can reduce approximately 75% of the systems life cycle costs*. This is why, at George James Software, the solutions we build are always straightforward and written in high quality code - because we know that this solid foundation can positively impact the rest of your organization.

With a maintainable system you're able to reduce your overall maintenance as any issues that occur are significantly faster to identify and fix. This means you're free to allocate that time and budget to enhancements, enabling you to get the most value out of your applications and ultimately better support your organization.

Keep an eye out for our next few posts about what a maintainable system looks like and the tools that can help you keep your code maintainable, in order to help you to reduce those maintenance costs.

3 1
1 481

Hello,

First of all thanks for your time to read and reply,

We would need some help,

We have an ORM_O01 which has a NTE.3 with a Line Feed

Our Process converts the XML to ER7 using the ITB as follows:

set context.mensajeHL7 = ##class(ITB.HL7.Util.Convert).XMLToER7(hl7,.tSC,"2.5")

When we show the ER7 we observe:

INTE|1||Psa libre\X0A\ Indice psa

We have thought about the following solution, where mensajeXML is the XML representation of the ER7 shown:

0 1
0 500
Question
· Oct 29, 2019
Cache Update Query

Hi,

     I am trying to update an year on a date field in a cache database table but it showing an error message. But the functions are working on select query. The query I used is

update RB_ResEffDateSessPayorRestr SET RESTR_DATETo = DATEADD(YYYY,1,RESTR_DATETo) where YEAR(RESTR_DATETo)=2020

I tried to update only the year which are 2020.

Can anyone please help me, Is there any error in the query?

Thanks

0 12
0 489

We just faced an issue of the Atelier main menubar being disabled (greyed out) after upgrading the macOS development machine to High Sierra. I would like to share my findings about the issue and how to fix it.

This seems to be a known problem affecting several Java applications including Eclipse if the macOS user's primary language is not English: https://www.eclipse.org/org/press-release/20170925criticalbug.php

4 0
0 501

I am using a method: %OverrideGuidAssignment("NEW GUID HERE") to override my GUID, and would like to know if there are any parameters, which allow this method to return a status & or error msg?
If you currently set it to a variable it returns the new GUID you originally passed in, regardless of if it failed to override or not.

Thank you in advance

0 5
0 496
Question
· Apr 24, 2017
Atelier and TFS

Has anyone begun working with Atelier and TFS for source control?

If so, experiences to share?

Thx!

0 1
0 500

Hi,

I am using the &sql () tag to retrieve the value from the Cache DB.

below is the piece of code i am using:

script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String"
&sql( select columnA,
into :tempVariable1
from TABLE
where COLUMNC = pVariable

quit tempVariable1

i have to return the ColumnA value back to the calling procedure.

can i know how it can be done ? since i am getting an javascript error.

1 4
0 497

Zen Reports has offered multiple choices for direct printing including use of Adobe Reader or Foxit reader. Recent changes in Windows 10 and in the readers themselves have made it no longer possible to invoke these readers from background processes in Windows 10 and all future versions. Because of this Zen Reports will no longer support printing with these tools on Windows 10.

Windows 10 support was added for 2015.1 and 2015.2. On Windows 10, the only option for direct printing with Zen Reports will be Qoppa JPDFPrint.

0 3
0 441

Based on your experience, do you know any reason why IRIS would enter a deadlock/hang state ?

When such thing occurs, it's no more possible to connect to Portal or Studio, despite IRIS service (IRIS.EXE processes) being still active. CPU/memory/network usage are usually very low (eg: it does not occurs because server is overloaded). The only fix is a full restart of IRIS (eg: by clicking on IRIS icon in notification toolbar and choosing appropriate action).

0 6
0 494

Hi

I'm trying to migrate a database from cache to iris but i get this from one of the classes on compiling.

ERROR #9101: Global name 'Jobcosting.JobActivityGroupGroupD' for 'IDLocation' is too long, must be no more than 31 characters in length.
> ERROR #5030: An error occurred while compiling class 'Jobcosting.JobActivityGroup'

0 2
0 498
Question
· May 4, 2022
HTTP post request

Hi Guys,

How do I do a HTTP post request using a curl and get a response, the response should be a JSON file ? a sample code would be really appreciated.

Thanks

0 4
0 496

I would like to know any experience working with OPC UA standard in industry sector or IoT. Currently there is no adaptor implemented in IS IRIS for it but it seems to be pushed as the main standard in industry. Did anyone had to implement their own libraries or adaptors to deal with it? Or do you advice to use any already implemented library in Java, Python,...? Any feedback would be appreciated.

0 1
0 499

Hey developers!

Sometimes we need to insert or refer to the data of classes directly in globals.

And maybe a lot of you expect that data structure of global with records is:

^Sample.Person(Id)=$listbuild("",col1,col2,...,coln).

And this article is a heads up, that this is not always true, don't expect it as granted!

8 1
0 480