Hi,

I have a problem with my production. I have coded two service classes for production, first class is a searching service which seeks the messages going through the production. The second service is a collector service, which collects certain data from the messages.

 

Below is my code:

00
0 0 41

I need to execute multiple DELETE statements in a single query like this

DELETE FROM TableName WHERE ID = 2;
DELETE FROM TableName WHERE ID = 3;
DELETE FROM TableName WHERE ID = 4;

However It does not work when there're more than 2 statements and gives me an error

Expected FROM found WHERE^DELETE FROM TableName WHERE

Using IN is not an option.

00
0 6 75

Quite a complex scenario we are trying to solve but should be able to understand.

We're developing a task executer that runs on a server with a certain timezone.

The tasks run every day at a defined time, but in different timezones.

We're saving in database at what time we want to execute the task, and in what timezone (don't go to the save in UTC pitfall, as with DST it will be at different times)

What I want to do if when opening a task from the database, convert 02:00 Europe/Madrid, either to UTC or to local (server) time.

00
0 8 131

Once a week we are attempting to load an XML file from Workday into a MS SQL table using JDBC and Store Procedures. There is approx 102999 records in this XML file. We are struggling with processing the entire file within a reason amount of time. We feed the XML through a BPL to then populate values in a stored procedure then call the stored procedure through a Business Operation. I have tried splitting out the Business Operations to make two calls, but we still continue to see an issue loading the XML into MS SQL.

00
0 4 56

I need to remove content below, from PID-3/HL7 message, in IRIS. However, I need to keep the content in PID-3.1. For example, I’d need to keep only, “5050532”. Can this be done in Data Transformations? If yes, how?
Thank you!

MSH|^~\&|TEMPUS|TEMPUS LABS|EPICEMR|YRMC|20210930100824||ORU^R01|4823623379495310173|T|2.3|
PID|1||5050532^^^YRMC~09abefb8-872b-4147-8e4b-77463bb235cb^^^^TEMPUS||

00
0 4 82

If I open a terminal and type the following commands, sc is an error:

set validator = "sc = ##class(%Library.Numeric).IsValid(""BLAH"")"
set @validator
write sc

At the end, when I write sc I get:

0 L'BLAH9
             DOCXT010,#e^zIsValid+1^%Library.Numeric.1^1e^^^1

However, if I call the following class method using the arguments "%Library.Numeric" and "BLAH", sc is undefined

00
0 12 217
Question
Rochdi Badis · Oct 14
Lock the Modal View

Hi Guys,

I'm using a Modal Group but whenever I click outside it the Modal gets minimised, so How can I change the view so that whenever pops up the view get locked until I'm finished with my modal then click exit to endModal ?

 

thanks

 

00
0 0 31

Is there an ObjectScript analog of Find with Match Element Type option? I know there is an  ObjectScript analog of Find in Files, Studio.Project.FindInFiles and Studio.Project.FindInProject, but I failed to locate so far an analog of Edit/Find. I am specifically interested in Match Element Type option so I could search across selected files for globals. Somehow Studio.Project.FindInFiles does not offer this option natively.

00
0 2 81

Hello All,

I am receiving this error when attempting to place a file in a local SFTP server. 

ERROR <Ens>ErrFTPPutFailed: FTP: Failed to Put file '101320210700.RAW' (msg='Error in SFTP Put('/healthshare/mgr/Temp/VPacx9a1eq0b5g.iostream','/SFTP/unmhsmcsa/OUT/101320210700.RAW') ERROR #7504: Timeout',code=0)

Any help is appreciated.

 

Below are my settings

 

00
0 4 100

Hi everyone!

I am trying to localize text in an XData block using the $$$Text macro. A snippet of code is included below. Is there an easy way to localize the text included in an XData block? So far, using the $$$Text macro is not working; when I export the %MessageDictionary, the text to be localized isn't included in the export.

 

00
0 3 88