Question Yone Moreno · Nov 4, 2021

Hello community,

It would be appreciated if you could read and respond to us:

➡️ We need to activate a SOAP Operation during a time slot, in order to send messages to the target system, only for a few hours; for example from 4am to 8am.

The requirement is to do this without a scheduled task. This is because when changing nodes, in the production mirrors, there are difficulties, challenges, or issues with scheduled tasks.

Therefore, we need a mechanism that allows us to ensure that the Operation is executed even after a node change.

Please could you point us to documentation, code samples,

2
0 262
Question Nicky Zhu · Nov 3, 2021

Hi guys,

My client has a requirement to add a column of random numbers to the query result.

I wrote a function as below:

Class Utils.SqlUtility Extends %RegisteredObject
{

ClassMethod GetSomeNumber(intInput As %Integer) As %Integer [ SqlName = GetNumber, SqlProc ]
{
    Return $R(intInput)
}

}

But in the returned sql result, every row share the same value, as below,

SELECT Utils.GetNumber('456'),
ID, Citizenship, DOB, FirstName, Gender, IDNumber, LastName, PatientNumber, PhoneNumber
FROM CDR.Patient

How may I refactor the function or sql to make the random value really random on each of the rows?

Thanks.

6
0 1182
Article Daniel Tamajon · Sep 21, 2021 2m read

Hi community!

I want to introduce you a new powerful feature from our static code analyzer objectscriptQuality

Each time a new IRIS version is released, you need to prepare a roadmap for migration in which you need to spend a lot of time on testing to find where your code is not accomplishing with the newer version. Or maybe you need your code to be compatible with multiple IRIS or Caché versions.

You can now simplify the task running the analysis for the different IRIS and Caché database versions, so you will get the failing code before you start to test.

objectscriptQuality allows you to

1
1 511
Question Nezla · Nov 2, 2021

Hi Guys,

I've bind a textarea to show up in a tablepane cell and it's working fine as follow:

this the column injh question:

    <column colName="FollowUp" header="FollowUp Comments" width="9%" style="text-align:left;" OnDrawCell="txtFollowUp"/>

txtFollowUp method:


Method txtFollowUp(pTable As %ZEN.Component.tablePane, pName As %String, pSeed As %String) As %Status
{
    &html<<textarea name="followup" name="followup" rows="3" text="#(%query(pName))#" style=" width: 95%;" onchange="zenPage.saveFollowUp(this,#(%query("id"))#);">#(%query(pName))#</textarea>>
    Quit $$$OK
}

and 

the client method

4
0 236
Question jennifer mccallum · Jun 10, 2021

Hi

We have ODBC 32bit Encryption working on our database with a SSLDEFs.ini file.  However 64 bit ODBC Encryption will not work and give generic error, same error if the ini file is not there for 32BIT.

We have copied the ini file to the 64bit folder?  Any ideas please?

thanks

2
0 359
Question Evgenii Ermolaev · Nov 2, 2021

I am receiving the following error in my buisness operation:

ERROR <Ens>ErrException: <UNDEFINED>zGo2+181^mb.MbMainOperation.1 *tSC -- - registered as '-' number - @' set pResponse = ##class(mb.MbMessageResponse).%New()'

From what I understand, the problem occurs in the generated int file mb.MbMainOperation.1 in the method zGo2, with the offset of 181 lines, and the variable in question is a local variable tSC.

However, the line where the error occurs does not refer to tSC in any way

set pResponse = ##class(mb.MbMessageResponse).%New()

I even went as far as to set the variable at the very start

3
0 287
Question Nezla · Oct 27, 2021

Hi Guys,

is there a way to include a datetext in a tablepane cell maybe using OnDrawCell?

I've tried :

    &html<<input type ="date" id="serialno" style=" width: 80%;" />>

but doesn't work with IE 11 and under, so it would be good if I can include datetext component instead.

Thanks

4
0 226
Question Evgenii Ermolaev · Oct 23, 2021

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.

9
0 470
Job Paige Steimel · Nov 2, 2021

Memorial Sloan Kettering Cancer Center — the world’s oldest and largest private cancer center — has devoted more than 135 years to exceptional patient care, innovative research, and outstanding educational programs. Today, we are one of 51 National Cancer Institute–designated Comprehensive Cancer Centers, with state-of-the-art science flourishing side by side with clinical studies and treatment.

We are looking for Healthshare Integration Engineers to join our Health Information Exchange team.

0
0 376
Question Lionel Woods · Nov 2, 2021

I am using the following code to capture the current Date/Time and Date/Time from the previous 15 minutes 

set now=$horolog
$$$TRACE("now:"_now)set time15min = $piece(now,",",*) - (15 * 60)
$$$TRACE("time15min"_time15min)set after = $piece(now,",",1)_","_time15min
$$$TRACE("after"_after)set datetime15=$zdatetime(after, 3)
$$$TRACE("datetime15"_datetime15)set datetimenow=$zdatetime(now, 3)
$$$TRACE("datetimenow"_datetimenow)set datetime15=$replace(datetime15," ","T")
$$$TRACE("datetime15"_datetime15)set datetimenow=$replace(datetimenow," ","T")
$$$TRACE("datetimenow"_datetimenow)

The issue I am

1
1 209
Article Laurel James (GJS) · Nov 2, 2021 1m read

We're hosting our Deltanji and Serenji user group session tomorrow - there's still time to register, if you haven't already. 

We'll be showcasing some advanced features of Deltanjiand Serenji in VS Code with time for a discussion - so feel free to bring along any problems you need help solving or share your feedback on our tools. We'd love to hear your thoughts. If you're interested in our tools this is a great chance to hear what others have to say, as well as asking your own questions.

Date: Wednesday, November 3rd

Time: 11-12pm EDT / 3-4pm GMT.

Let us know you'll be attending on Eventbrite

We hope to see you tomorrow, but if you're unable to make it you can email me at laurelj@georgejames.com and I can share a recording of the session. 

 

0
0 188
Job Scott Roth · Nov 2, 2021

https://osu.wd1.myworkdayjobs.com/OSUCareers/job/Medical-Center-Campus/Sr-Applications-Development-Analyst_R20670-2?shared_id=2485643a-341c-43b7-b1c4-c85f8715a77b

Position Summary 

Serves as the primary contributor and consultant for patient care services in the planning, design, development, implementation, functionality and evaluation of integrated health information systems that support and enhance practice, administrative and management needs and patient outcomes.

1
0 257
Question Mikhail Khomenko · Nov 1, 2021

Hello everyone,
I'd like to export Ensemble globals, but without Ensemble messages, this way:

^^database>s list("Ens*.gbl,'Ens.Message*.gbl")=""
^^database>write $SYSTEM.OBJ.Export(.list, "/tmp/globals.xml")

Documentation says that it could be done by adding an apostrophe, but it doesn't work for me - all Ens* globals are still exported.
What I'm doing wrong? Thanks!

9
0 344
Question Kevin McGinn · Oct 25, 2021

I am relatively new to Intersystems cache database management.As I understand it, a database is set with a maximum size or unlimited and the size of each space allocation for the database is defined.My understanding is that the cache database will then manage the allotment of space to the database as the current space allocation is consumed.Though I do not know why one would want to do this, I have been told that the space allocation to a database can be set to be handled manually.This is something, if true, I was not aware of.

6
0 414
Discussion Timothy Leavitt · Oct 19, 2021

Hi Developers! As part of an internal company hackathon at InterSystems, I'd love community feedback on a few topics. Feel free to chime on any/all of these via comment or direct message to me.

  1. If you were to launch a new application/project, what problems would you need to solve right off the bat? What technologies would you use? Why?
  2. What are the most common and repeated problems that you find yourself solving?
  3. Where in InterSystems' technologies do you spend most of your time?
  4. In a solution you have recently implemented, how were your time/efforts allocated?
7
1 427
Question Javier Delgadillo · Oct 26, 2021

Hello - basic question.  Looking for sample code to parse inbound ACK messages.  Messages are coming in a SOAP envelope.  The ACKs will have MSH/MSA/ERR segments (other segments for QBP messages down the road).   Looking at common, established way(s) to parse the messages HS would be a great help to get started on this.  Thanks in advance.

2
0 319
Question Mark Franssen · Oct 29, 2021

I am relativly new to this, so excuse me if i am asking a dumb question

HL7 schema is 2.4

When a HL7 message comes in and in the PID segment on spot 4 the word "Relation" is written, i want to filter out those messages through a Router Rule.

I have come up with several rules (when conditions), here are some examples.

HL7.{PID:4} CONTAINS "Relation"

or

HL7.{PID:AlternatePatientIDPID(1).ID} CONTAINS "Relation"

I have tried a lot of different Rules, but no luck yet.

But every time i test a massege what contains the word Relation in de PID segment on spot 4 it states ".....no whens matched...."

What am

6
0 484
Question Chip Gore · Oct 29, 2021

In specifying a "WHEN" condition statement, I don't seem to be able call a function directly from this declaration, as the generator seems to get confused

In the graphical editor:

%request.GetValue("MRN"))=123453

(%request.GetValue("MRN"))=123453)

In the DTL directly: 

<when condition="(%request.GetValue(&quot;MRN&quot;))=123453)">

<when condition="(%request.GetValue&#40;&quot;MRN&quot;&#41;)=123453)">

But they all fail at the same point, where the opening "(" of the method call completely confuses the generator, and these all throw the same error:

ErrParsingExpression: Error parsing expression

2
1 425