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

Our Organization is working towards a long term contract with regards to HealthShare implementation in the US and are interested in speaking with HealthShare unified care record certified consultants who reside in the continental united states. Send me an message if you are interested in knowing more.

1 1
0 252

Welcome to the May'22 Community Release!

We’ve made some enhancements to your experience recently in the InterSystems Community:

🆕 Improved current events tracking

🆕 Scheduled posting

🆕 Enhanced code formatting

🆕 Faster table creation

🆕 Enriched reply experience

🆕 Changed post teaser design

Let's have a closer look at all of these below.

9 6
0 388

Hi Developers!

We are introducing a new feature on Dev Community site – Key Questions by InterSystems Developers.

We've added a new special #Key Question tag to highlight questions related to InterSystems Data Platforms considered as having the biggest impact.

Each month InterSystems Experts will choose such questions, and those authors will be awarded with all the honours!

What honours? Details in this post!

5 6
0 748

Good morning. Perhaps someone can tell me if this IRIS health communit version (IRISHealth_Community-2022.1.0.209.0-lnxubuntu2004x64) is supposed

to work in an Ubuntu 20.04 LTS installation in an Oracle Virtual Box .

I am trying to install different versions on Ubuntu . I tried with the 18 version. No luck. Than I've tried with the 20.04 version. No luck either.

The error I am having now is below

///////////////////////// error message from the install ////////////////////////////////

0 3
0 505
Question
· Jul 20, 2022
Default Database Resource

Can I please check if anyone know why the data base resource is created differently when creating a namespace after specifically selecting it to use the default resource %DB_%DEFAULT?

I created a namespace and when creating the DB I selected the option to use the default resource

When the namespace creation was complete , database is using a new resource instead of the default.

0 2
0 426
Question
· Jul 21, 2022
Zen Page source url

Hi Guys,

usually when I want to find out which class is a zen page is, I just right click on the page and go to properties and this will show me the class url, but with this client I don't get properties as below !?

Thanks

0 3
0 298

This is the third in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready. Many updates, fixes and enhancements have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. Please share your fe

1 1
0 255

I am reaching out to find out if anyone has come across a similar dilemma.

In my current role, I have been asked around the best way to design some patient labels for a client.

I primarily would stick to what I know and veered towards designing the label in ZPL and then creating a Abstract Class to call the ZPL code, however I have been asked why not to design via JReport. The patient labels will be processed via thermal ink printers primarily Zebras, I am wondering if anyone out there has come across this or would recommend to stick to what you know.

0 4
0 340

I'm getting wrapped around the axle with CAST and CONVERT and can't seem to find a way to do this (short of adding a stored procedure wrapping $zdt($zdth(posix,-2),3), which I'm refusing to do on principle, because there has to be some way to make this work).

Any ideas?

1 4
0 307

You know several languages and wish to share your knowledge with users in different parts of the world who don't speak English?

Now it's your time to shine! 🤩

With our Developer Community, it is easy to link your original article and its translation in a different language (or even ask for a translation).

So let's talk about creating your own translation:

7 2
3 525
Article
· Jul 21, 2022 11m read
ECP With Docker

Hi community,

This is the third article in the series about initializing IRIS instances with Docker. This time, we will focus on Enterprise Cache Protocol (ECP).

In a very simplified way, ECP allows configuring some IRIS instances as application servers and others as data servers. Detailed technical information can be found in the official documentation.

This article aims to describe:

4 0
2 967

Hi Guys

how do I deal with single Quote inside string in an SQL query?

currently this type of query is failing with an error asking me for a closing quote :

Select * from cnd.Facilities where name like ''%Grill's BBQ%'

Thanks

0 5
0 1.6K

I am trying to use EnsLib.SQL.Operation.GenericOperation for retrieving (multiple) rows. But I am looking for a way to handing a StreamContainer returned by the operation, in my business process such as receiving it in the Context object and packing it to a request to call another business operation.

Does anyone have sample code to do this?

Thanks.

1 2
0 289

Hi Community!

We are proud to announce that InterSystems will be hosting the Women's Health - FemTech: Much More than A Niche Market!

⏱ Time: July 28, 6:00 PM – 7:00 PM EDT
📍 Location: Online event

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

I am calling a stored procedure over an ODBC connection and every time I call it there are several warnings written to the log event {Found no Parameter 1 (used as 1) for query}.I seem to be getting this on every query executed and that seems to happen a number of times the query parameters are per query and its filling up my disc.

1) Is there a way to suppress these warnings as the query seems to be executed and data written to the database?

1 1
0 298
Question
· Jul 19, 2022
Empty HTTP response

Hi Guys,

We use the below code to send JSON file to one of our clients and was working fine but I think lately they did a windows update and now whenever we send file we aren't getting any HTTP responses, success or Error, just empty response ()

the think is that it works fine and we get 200 response if we send the JSON file using our client's portal called swagger which is a website where you can assign the token and url (Swagger UI (vibra-api-prod.azurewebsites.net))

0 6
0 579

Hello, I'm using the InterSystems IRIS connector for Power BI to connect to our Iris for Health database, using Direct Query.

I have a column [Company] which is datatype bigint, and as far as I can tell the data is 2 for most (or all?) records.

When I bring the data into Power BI, every row shows as NULL (I think it should be 2 for most)

= Table.SelectRows(Table, each [Company] <> null and [Company] <> "")

-- removes all rows

0 0
0 235
Article
· Jul 19, 2022 4m read
Caution with Mixing OO and SQL

Mixing Object syntax with SQL is one of the nice features in Object Script. But in one case, it gave strange results, so I decided to isolate the case and describe it here.

Let's say you need to write a classmethod that updates a single property on disk. Usually, i would write that using SQL like this :

2 5
0 364