#Beginner

Do we have messages.log/cconsole.log projection in SQL?

I was sure we do, but unable to find it.

Good morning,

We would like to share with you a doubt, and we would appreciate if you could read and answer us.

Currently we have a file titled: "Imagen PatientID 9358340 PatientName Milagros ReasonForStudy 350290 InstitutionName 350290 StudyDate 20220927.xml" , in which we have the following InstitutionName:

<DicomAttribute keyword="InstitutionName" tag="00080080" vr="LO">
<Value number="1">350290</Value>
</DicomAttribute>

NewBie's Corner Session 3 More Read and Write commands & Multiple commands

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Click on the Caché Cube in your system tray and select Terminal to try out the commands.

Write command with carriage return and line feed

When the exclamation point "!" is inserted after a Write command, a carriage return and line feed combination is produced. Note in this example, that a comma separates the exclamation point from the variable "X".

Thanks for all replies in advance.

Is it possible to modify a users security from a batch script? If it is possible can someone point me to some examples or documentation?

I am looking for a way to deploy production changes (code and/or production configs) via script or some other systematic way other than the Ensemble/Deploy page in the Management Portal. My goal is to store these configurations in Subversion, then have a piece that can pull the XML from source control and deploy it to a given server. Is there some kind of script that I can run on a given server to perform this deployment? If so, I can tie it up with Subversion using another tool that I have access to.

Hi Team,

We were able to convert XML file to JSON using Studio and terminal, but kindly let us know how this conversion occurs using Ensemble production.

Thanks.

Greetings,

What methods are available to position a cursor on a screen to begin writing as not to disrupt other areas of the screen? I have used ?# , ie: ?5 but this is destructive from the let to character 5. I would like to enter a command that will position at row,col and then start writing? Can I create a window in a window type display to write text and then when done viewing, remove it?

Please advise,

Thanks in advance for everyone's time.

Is it possible to generate a random string in cache please advice thank you in advance

The code I'm researching loosely follows this flow:

1. My first callback
2. Black box
3. My second callback

I can modify 1 and 3 no problem but modifying 2 is difficult.

However I think that step 2 has some optimization problems, namely:

• instantiates lots of objects
• throws/catches lots of exceptions (not logged)

Is there a way to count these two metrics?

Hello all,

I have created a simple Datagrid and using jsonSQLProvider with a SQL statement as the datasource. Please see below.

I am trying to get the time difference between two time stamps one is recorded earlier to the one happening current but the problem is sql expect string while I have the other stored in a variable and if I do the following I get errors any help please

&sql(SELECT {fn TIMESTAMPDIFF(SQL_TSI_HOUR,$ZDT($H,3,1,3),tx)})

please note that tx is a variable holding the time formatted the same way as the one being compared to

Hey I am very new to Intersystems Objectscript and I am trying to find a way of extract 4 digit numbers from a stream.

I have a stream full of results

2334

3434

5543

4334

And I am trying to remove each 4 digit grouping from the stream.

I have tried the following for loop

for i=1:1:$length(result) {

set curr = $extract(result, i)

write !, curr

set count(curr) = $get(count(curr)) + 1

}

Unfortunately the loop extracts one digit.

Hi!

I've encountered a peculiar behavior of $ListNext in Intersystems Cache, where I'm not sure whether I'm doing something wrong, or is it an intended behaviour.

First I am creating a ListOfDT from a string delimited with underscores:

Set tempList = $ListFromString(String, "_")

NewBie's Corner Session: 5 Operator Precedence

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Click on the Caché Cube in your system tray and select Terminal to try out the commands.

Order Precedence means the order in which mathematical operators are executed. In a Mathematical expression, you may have Multiplication, Addition, Subtraction, and Division. Which of these are executed first, second, third, etc.?

The basic Operator Precedence of mathematics is: