Hi community,

I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow:

Hi! I have a complex SQL select query which I execute via %ResultSet. It also includes a UNION. The select statement within the union should only be done when an external parameter is set, and I'm not sure of way of doing that within SQL, other than something like

SELECT FOO FROM BAR

WHERE (some conditions)

UNION

SELECT FOO2 FROM BAR2

WHERE :doUnion = 1 AND (some conditions)

this works, but I don't think it's particularly optimal as I believe it will still execute the second SELECT regardless of :doUnion.

Hi developers!

We are glad to share what we have new in March Open Exchange release:

• New editor for long text inputs    
• Table support  
• New analytics views and conversion
• Local GitHub links and images support

Hi,

I have to create to a web socket client, but I'm unable to read any data from the server, after flushing the buffer. I have no access to the server, only two examples for the client, one in java and the other one in php:

java example:

socket = new Socket("192.168.0.1", 2003);

DataOutputStream out = new DataOutputStream(socket.getOutputStream());

out.writeUTF("aPassword");

out.writeInt(websiteId);

out.flush();

DataInputStream in = new DataInputStream(socket.getInputStream());

int orderId = in.readInt();

in.close();
out.close();
socket.

In previous versions of cache I used to be able to write click on a class and get a delete class option but in this version I can not find the delete class option was wondering if there is another way to delete a class if you wanted to do some house keeping.

N.B. These are the classes I create not the ones that comes with cache.

Is there any reason that property method  DisplayToLogical() is not calling before object saving?

I have such situation and do not know how it is possible

My response definition is below.  I keep getting ERROR #9406: Unexpected format for value of field, physicianFirstName, using class base mapping. Any ideas would be helpful.

Hi all,

I have a very weird error when I'm calling to a SOAP Webservice as client.

I've create all objects to invoke to this SOAP using the add-in "Assistant SOAP" in Eclipse, it has created all objects (Response, Request, Business operation WS class, etc...).

When I call to this service it retuns the following error message:

ERROR #6243: HTTP request to SOAP WebService returned unexpected CONTENT-TYPE response: text/html.

However, If I call the same WS using SOAP UI or Postman, the header of response has the content-type "text/xml", as expected.

What is

Can a license be reserved for a specific user or group of users? So if I have 20 available licenses, only allow other users to use 19 of them while keeping one open for this specific user?

Hi all

I've been looking into how to convert some images with IRIS and saw some recommendations on the forums around using image magick.

However I can't seem to get this working using ZF100 and on windows server and I'm wondering if I'm missing something really obvious as I've not used IRIS to call third party applications before.

If I run via a Windows CLI on the server, it works fine, e.g:

magick "D:\1221701739_20190716134351965_1_0.jpg" -resize 640x480 "D:\1221701739_20190716134351965_1_TEST.jpg

But I keep getting NOTOPEN when I attempt this in IRIS.

I want to operate on the class in enslib, but I don't have write permission. How can I modify the permission with code, or which table is given write permission

ERROR:#5388 - You do not have write permission on the database class ,so class lock cannot be obtained .

Hey everyone,

The InterSystems Grand Prix Contest is over. It was an incredible competition with a record number of participating apps and developers! 

Thank you all for participating! And now it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Until what version of HTML and CSS can I use on zen pages? 

Hey Developers,

Enjoy watching this brief explanation of a new feature in IRIS RAD Studio – a new project by @José Pereira and @Henrique.GonçalvesDias:

⏯ Automated user management in IRIS RAD Studio

I need some compasion between these two products， Thx!

Hi 

we are implementing HIE and wan to get expert opinion on facility registry setup. Below are some example and which method we should adapt.

Transition and transfer from Caché to Iris databas. I have a question about import-export from Caché to Iris. Someone will tell you how to do this with a regular one, i.e. using standard procedures from Caché itself or Iris? I am asking in connection with the planned transition from Caché to the new IRIS DBMS.

Hey developers,

We want to hear from you! Give us your feedback on the InterSystems Grand Prix Contest! Please answer some questions to help us improve our contests.

👉🏼 Quick survey: InterSystems Grand Prix Contest Survey

i have a problem with CSP files, i can create a CSP file with termination ".csp" or ".CSP" and this configuration is case sensitive, but a CLS file, this configuration is not case sensitive. there is a way i can change this to the CSP file don't be case sensitive?

First of all thank you for your time in reading this question and writing a response,

We would need some help,

What is the best method for save a %CSP.BinaryStream to a file?

Thank you in advance!! 

Hi Developers!

This is a release of how did we improve the Developer Community in February 2021. The key features:

• Updates on the user profile page:
  • New Subscriptions page
  • New Bookmarks page
  • New Drafts page
• Discussions in related posts (Prev & Next posts)
• Short link to community posts

See the details below.

Hi Developers, 

We hope that you enjoy participating in our Global Masters Advocate Hub and have fun completing our exciting challenges. 

And now it's time to announce the Winners for February 2021! Please welcome our awesome Global Masters Heroes!

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

🥇 @YURI MARX GOMES, Software Architect, YM Services, Brazil

🥈 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Germany

🥉  @Oliver Wilms, Integration Engineer, Take2 Consulting, USA 

Learn more about the competition and our awesome winners below.

Hi Community!

We want to invite you to join the InterSystems Gamification Platform called Global Masters Advocate Hub!

The Global Masters Advocacy Hub is our customer engagement platform where you will be invited to have some fun completing entertaining challenges, earning badges for the contribution to Developer Community, communicating with other advocates, and accumulating points which you can redeem for a variety of rewards and special honors.

Hi Developers, 

For the first time, we announce the winners of our monthly Global Masters competition here, on the Developer Community! Please welcome our awesome January 2021 Global Masters Heroes!

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

🥇 @Yuri Marx, YM Services, Brazil

🥈 @Sergey Mikhailenko, AO Mosvodokanal, Russia 

🥉 @Yone Moreno, Everis, Spain

Learn more about the competition and our awesome winners below.

Bulid REST API application built with ObjectScript in InterSystems IRIS. It also has OPEN API spec,  can be developed with Docker and VSCode, can be deployed as ZPM module. can be used as Overbooking System data REST api.

What's Hotel Overbooking Management System?

The overbooking management system combines the unique conditions of the hotel, such as room prices, order channels, customer needs (etc.).

I have a quick question regarding swizzled objects.

I have an original object, say Object a, I am working with.

I set a property a.something.somethingother.somethingelse.myNewProperty  to some value x.

Then at some point I am saving a and continuing to work with it.  I assume here by saving a, I saved myNewProperty as well. (as it should work)

At some point  I would like to make certain that I have correct value in my myNewProperty, so since I happen to know it's ID I 
open it directly:
Set ref=##class(somethingelse).%OpenId(Id)
but when I try to look at my ref.

Hi,

When I'm using Cache Studio and save and compile some .cls file, it automatically generates the .xml file:

How can I have the same behavior  in Vscode, when I use the export command:

This are my Vscode configs:

any help will be most welcome

thank you

Hi!

I am making a request to an API and JSON is coming as follows:
SET %httprequest = ##class(%Net.HttpRequest).%New()
DO %httprequest.Get(URL)
SET %responseBody = %httprequest.HttpResponse.Data.Read()
 

W %responseBody
{produto:"CHP0001",Local:{IDMV: "000000001",LOTE: "",DtFabric: "null",DtVenc: "null",Atributo06: "0000000002",Atributo07: "",QtdeDisp: "10.00000",QtdeAloc: "0.00000",QtdeSep: "0.00000",QtdeTotal: "10.

I'm participating in the Developing with InterSystems Objects and SQL with Joel Solon. The course is very nice and I will share with you some tips I got during the training. Tips presented in the day 4:

1. All data are stored in Globals and Global names start with ^. Example of global: ^animal. Global can have multiples locations to the data ("sub data"). Example: ^animal(1).
2. ^%* globals are accessible from any system-wide (from any namespace).
3. Globals enables IRIS to support multimodel data (object, relational, document, multidimensional, etc).

Congrats for women.

"I was born in rough times. I accepted contradictions, struggles and stones as lessons in life and I use them. I learned to live". (Cora Coralina, Brazilian poet)