InterSystems Developer Community is a community of 24,442 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

I am trying to delete a field based on a value in one of the subfields. I would like to remove the below Field with the Field value "Field8". I know how to find the number of fields and iterate. If I just use "" I still get a tilde at the end.

Ex .

|Field^Field1^Field3~Field4^Field5^Field6~Field7^Field8^Field8

0 3
0 361

My objective is to find routine's Date/Time Saved someplace inside Cache. The routine's Date/Time Modified as returned by various queries like %Library.RoutineIndex and as seen on the File Open screen is actually Date/Time Compiled last, not Date/Time Saved last. Does anyone know if Date/Time Saved is created when the Save icon is pressed or the routine is imported? Such a timestamp should be immune to subsequent compilations with no changes.

0 5
0 604

In a typical database, changing the type of a column from some kind of date/time to a string would require a degree of migration effort for existing values. In Caché, my suspicion is that this is not the case, and I could simply change a property definition from %Timestamp to %String (MAXLEN = "30") and recompile, without needing to worry about damaging the existing data stored for this property. Is this correct? Or would I find the existing data in this property being lost or corrupted?

Thanks in anticipation

0 3
0 208

Dear,

From time to time I get the following error after executing a select statement:

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]
[Location: <ServerLoop>] InterSystems.Data.CacheClient.CacheException [SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]

After repeating the query, the query succeeds.

How do I start debugging this type of issue?

0 3
0 658

Hey everyone,

We've made a video tutorial for an easy start on InterSystems Partner Directory:

⏯ How to list a company on InterSystems Partner Directory

https://www.youtube.com/embed/WaDUc5dSHhQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

4 0
0 181

Hi folks!

Want to share a lifehack with you on ObjectScript highlighiting withing VSCode for script files.

Script files are just files with lines of ObjectScript that we feed anywhere, e.g. into IRIS during Docker baking procedure.

Typical usecase - here is the Scriptfile

here is the Dockerfile where we feed it.

And here is how it looks like usually in VSCode:

Screenshot 2021-08-05 at 09 51 06

Coudl be more beautiful, right?

1 0
0 540
Question
· Jul 27, 2021
Method Call

Hi all,
We have a session values in a cache method and need to get those values in a client method (JavaScript).

Eg :
ClassMethod Method1()
{
Set %session.Data("Param1")="Data 1"
}

ClientMethod onloadHandler [Language = javascript]
{
var ret = zenPage.getSessionValues();
}

ClassMethod getSessionValues() As %String [zenMethod]
{
Set Data = $G(%session.Data("Param1"))
Quit Data
}

0 1
0 518

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in July 2021:

New Videos
№ Video Views
1 Creating an HL7 v2 to FHIR Transformation Pipeline with S3 Target 353
2 What is the InterSystems IRIS FHIR Accelerator Service? 210
3 FHIR API Management 191
4 Creating an HL7 v2 to FHIR Transformation Pipeline with HealthLake Target 115
5 Machine Learning with IntegratedML & Data Robot 99
6 Embedded Python: Bring the Python Ecosystem to Your ObjectScript App 66
7 Best Practices for In-Platform AI 41
8 New & Next: Cleaner, More Comprehensive Unified Care Records 12

1 0
0 117

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems AI contest!

Date & Time: Friday, July 30, 2021 – 11:00 AM EDT

What awaits you at this Virtual Meetup?

  • Our winners' bios.
  • Short demos on their applications.
  • An open discussion about technologies being used. Q&A. Plans for the next contests.

https://www.youtube.com/embed/27vE9o9U3nM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

4 2
0 348

Hi Developers!

Currently, we are experiencing technical issues with DC sign-in - you may not be able to sign in and contribute to the Developer Community.

Our engineers are already working to solve the issue, so we are committed to restoring service quickly.

To stay in touch, let's continue our tech talks on InterSystems Developers Discord Server 👈

Thank you for your patience!

4 0
1 281

Dear Experts,

I have to pull out a report of certain code tables and this is my first script and I need to write many.

1. If I have to refer to the table, seeing the reference in the components with reference to SQL table and column,

can I use Select < What I need from the table>

Inner join with reference table?

I tried, I used the code table reference in the components, but I am getting errors,

0 3
1 341
Article
· Jul 27, 2021 2m read
IRIS Interoperability Message Bank

I heard about Message Bank when we started redesigning a Health Connect production to run in containers in the cloud. Since there will be multiple IRIS containers, we were directed to utilize Message Bank as one place to view messages and logs from all containers.

Open Exchange app
6 1
0 494
Question
· Jul 31, 2021
Ensemble learning query

Hi All,

I am new beginner to cache/mumps language. I want to learn Ensemble code but I do not have any application access to Ensemble code.

Is there documentation apart from Intersystems Ensemble documentation that can help me to learn Ensemble. Any notes or documents will be very handful

Please assist!! Thanks in advance.

0 2
0 212