All
Accepted answers
Enrico Parisi · 14 hr ago go to post

For example, if you instruct it to extract data where a column value equals “Support,” it may generate a condition like = 'Support' in the SQL query.

However, since the actual returned value is “SUPPORT,” the condition does not match.

Not really, when using the default %String collation (SQLUPPER) the SQL "=" condition is case insensitive, for example:

WHERE name = 'Enrico'
WHERE name = 'ENRICO'
WHERE name = 'enrico'

All match the record/row with my name regardless of the case is stored in the table.

If collation is changed to SQLSTRING, then only exact case will match the condition.

Enrico Parisi · Apr 7 go to post

$$$ThrowOnError(##class(Ens.BusinessService).SendRequestAsync(tServiceConfigName, tRequest))

SendRequestAsync() is an instance method, not a class method, how can this line possibly work?

Enrico Parisi · Apr 7 go to post

You are not supposed to call OnProcessInput() method.

You need to IMPLEMENT OnProcessInput() and call ProcessInput().

Enrico Parisi · Mar 31 go to post

Meet so many old friends, colleagues and new people that share the same interests and passion for InterSystems Technology!

Enrico Parisi · Mar 18 go to post

It's not easy but you may find ways to narrow the origin.

One possibility is to check the journal file entry where the corresponding global node of the HL7 Message
To identify what journal file to check/search look for a non empty HL/ message this ID cose to the empty orphaned message and find the date/time it was created.


HL7 messages (not segments) are stored in ^EnsLib.H.MessageD(MessageID).
Find in the journal file the entry of the creation of the empty orphaned message, it contains the process id ($job) that created the message and exact date-time of creation.

The process id may be used to point what Business Host (BS, BP or BO) created the message.

Then I'd look for the trace of messages sent/received by that Business Host "around the time" the empty message was created.

All this is possible and relatively easy if the empty orphaned message is relatively new (the newer the better), if old, then you may not have the journal file and/or the job that created it may not be still running (restart production or host, etc.).

Enrico Parisi · Mar 5 go to post

Where else you can get in touch with so many IRIS delevopers, including InterSystems products developers?

Enrico Parisi · Mar 3 go to post

If you need " official recommendation" you should contact InterSystems WRC, this is a Developer Community.

Enrico Parisi · Mar 2 go to post

What type of ResultSet? Can you please provide the exact class name of the ResultSet you use?

Enrico Parisi · Feb 25 go to post

To get it working using DBeaver Community 25.3.5 I had to put the SSLConfig.properties file in C:\Program Files\DBeaver and then it works!

Thank you @Benjamin De Boe 🙂

Enrico Parisi · Feb 25 go to post

One option could be:

Set last=$o(^A(""),-1)

Set ^A(last_"z")="new last value"

In fact you can concatenate anything, not necessarily a "z"..

If the first subscript is always numeric, then:

Set last=$o(^A(""),-1)

Set ^A(last+1)="new last value"

Enrico Parisi · Feb 24 go to post

The first parameter is a $list, try with:

do ##class(%SYS.TaskSuper).ExportTasks($lb(1022,1023),"/opt/contenedor/tasks.xml")

Note that the documentation for the ExportTasks() method you linked in your post says:
List of task IDs to export $lb(1,2,3)

Enrico Parisi · Feb 20 go to post

Hi @Vitaliy Serdtsev thank you for your answer, however I need to reproduce the same interface/definition as currently implemented in Oracle that is using a CLOB column.

The JDBC client access the Oracle table and is implemented (for that column) using a CLOB that (I believe) it's different than accessing a LONGVARCHAR. The idea would be to use IRIS instead of Oracle without changing (most of) the code.

Where is defined/documented the JDBC LONGVARCHAR maximum length?
My search cannot find any reference on max size of 2147483647

Enrico Parisi · Feb 16 go to post

I think this is the expected behavior, in your sample code you are importing JSON to the same existing object, so it "add" (or update if you prefer) to the existing object.

If you want/need to import the JSON to a new object, then do so, and create a new instance before importing:

set r = ##class(User.ADGroup).%New()

Enrico Parisi · Feb 16 go to post

@Robert Barbiaux 


"return" is equivalent to "quit" with argument, thus is has only one form and one, clear meaning : returning a value.

Both Quit and Return can be used with or without an argument (returned value),  see the documentation for details.

RETURN and QUIT differ when issued from within a FOR, DO WHILE, or WHILE flow-of-control structure, or a TRY or CATCH block.

You can use RETURN to terminate execution of a routine at any point, including from within a FOR, DO WHILE, or WHILE loop or nested loop structure.

In the context of the main post/question example Quit and Return can be used and there is no difference, the behave the same way.

Personally I never use Return simply because I don't consider a good practice to exit a method in the middle of a FOR, DO WHILE, or WHILE flow-of-control structure, or a TRY or CATCH block, to me it's like, or worst, than using a GOTO command. In my opinion good code should have one exit point at the end of a method, not a random number of exit point in the middle of nested structure inside the method, therefore the newly introduced Return command is of no use for me. Again, this is my very personal opinion.

Enrico Parisi · Feb 7 go to post

How  can anybody help you without any detail of the routing rule used by your business process?

Enrico Parisi · Feb 6 go to post

I'm not sure it's a great idea, think about this code:

Set true="it's a good idea"
Set false="it's a bad idea"
Set dObj={"idea":true, "doubt":false}

😉

Enrico Parisi · Feb 5 go to post

Add %XML.Adaptor to the superclasses of all your classes, the trace message content viewer represents the class as XML.

Enrico Parisi · Feb 5 go to post

What's the line (segment) delimiter used in the stream? Maybe (likely?) $c(10), there maybe a message delimiter.

My suggestion is to save the stream into a file and then using an hex editor check what your stream actually contains and how is delimited.

Then, with this accurate info, you can split your stream in HL7 messages.