Question
· Sep 22, 2021
embedded sql select locks

i noticed -by reading .INT files of one class- that some of embedded sql select statements code blocks translates into code that uses lock command.

even if i use %nolock in the select, still cursors and arrow referencing notations "->" have the same results.

0 4
0 267
InterSystems Developer Community is a community of 22,685 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

I am writing a report for a client that will create a report of the current process with a format that mimicks the Management Portal process display. I am writing a cterm script file to generate the report.

In the loop that process the results I am writing the columns in a formatted manner that will result in a CSV format very similar in content and order the process page. However, it appears that the write statement is limited in size such that I can not write out all of the elements of the sys.process query. My query result processing that works correctly is of this format:

0 4
0 227

in order to do analysis on huge data volumes, it is better to take you data to a separate machine for analysis away from the operational machine, so trying to write huge globals or tables into files as is would take a huge space, what could be a solution or best practice ?..in python for instance, there is the pickling option (serializes data to byte string and saves it to a file) to save space, what could be best in object script ?

0 11
0 1.6K

I'm working on a project were we are going to be receiving a non-HL7 formatted flat file that will contain a single result message per line and each result messages may contain repeating OBX fields that will need to be parsed out so that can be sent as an HL7 ORU messages that contains multiple OBX segments.

0 10
0 631

Deploying InterSystems HealthShare code, supporting lookups and artifacts like ssl certs, keys etc is relatively straight forward using Gitlab Runners. Not only does this approach enable managing the code base and deploying with git type workflows, but it also lends to a speedy recovery and repeatable environments for some implementations.

4 1
2 600

Hey Developers,

Please welcome the new video by @sween on InterSystems Developers YouTube:

Hands Off HealthShare Deployment Workflow with GitLab Runners

https://www.youtube.com/embed/NP_smt5UY3c
[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]

Gitlab Runners and InterSystems Healthshare Code Deployment and VSCode oh my. More details in this post.

2 1
0 213

Hi All,

I would like to merge json files. From a BPL we're running an operation to get data from a REST service cursors. We would like to run the REST calls until no cursor is present in the response of the rest call.

This works fine, but I would like to combine/merge the json outcome and write it to the disk.

See my attempt below for merging 2 json files.

Class Test.TestClass
{

0 4
0 454

Hey Community,

New video for an easy start on InterSystems Partner Directory:

How to list a solution on InterSystems Partner Directory

https://www.youtube.com/embed/KDCoj4Ip5oM
[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]

0 0
0 192
Question
· Sep 15, 2021
Arranging Project

I want to start this project and wants to know the best practices, you guys using to arrange the project. I have done lot of mvc projects and API's in c#. But Intersystems is new to me. Please give me some suggestions like how can I Arrange the objects. Like for eg. Where can I store the productions objects like services,process and operations. will that be like under each resouces folder name? and what are the base classes, and how can I store them? basically please give me some idea about how Can I arrange them .

Thank you

Sai

0 8
0 304

Hi Everyone!

During the HackMIT 2021, we have been running an online game for undergraduate students called "Treasure Hunt". Thanks to all who took part in the game!

The Treasure Hunt prizes were raffled today at 10 am ETS on Zoom (see the recording here). Please meet the Raffle Winners!

🎁 JBL Quantum 300 Gaming Headset goes to A. Kuro Andengattil 🎉

🎁 Apple AirPods Pro goes to Pulkit Girdhar 🎉

🎁 Amazon Echo Dot goes to Joshua Qin 🎉

🎁 Nike Utility Speed Backpack goes to Chua Hua Lun 🎉

🎁 Amazon Kindle 8G Paperwhite goes Samrat Mukherjee 🎉

3 0
0 169

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

Getting Up to Speed on InterSystems API Manager

https://www.youtube.com/embed/flPpSEBmwa4
[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]

2 0
0 309

Hello gentlemen,

I hope you can help me because this is a very serious that I can't wait to resolve... Our back-up is currently taking 3 up to 4 Gb per day and we don't know why. We had 270 Gb yesterday and we are today at 274.3 Gb. We keep a computer history of the messages for only 50 days. Here is a picture of what's currently taking the most data place in our healtshare system:

(don't forget that our DB is also connected to the back-up, maybe it is related, I don't know)

0 1
0 196

The goal is to construct a comma separated string, using a loop but the same way $listtostring(var,",") would do (i.e. "a,b,c,d,e,f,g,h" without starting or ending comma).

What is the best way to do it, concerning the readability of the code and its performances?

To do so, there are more than 5 methods, but in this example we will test 4 :

1) using a "if" in the loop

4 9
1 486

Hey everyone.

I was curious if anyone had any success/tips with regards to using a global or a system parameter/property to control the behavior of a transform or process/operation.

Is there a parameter I can currently reference from the system that can be used for an if/else, or am I best off creating a simple Global and setting it according to the environment I am in?

0 2
0 181
Question
· Sep 15, 2021
day of the month

Hello everyone
I use cache script, I would like to know from you if there is any function or class in the cache where I can get the start and end date of a given month:
Example: What is the first and last day of the month of February 2015.

Grateful.
Davidson

0 9
1 549