#Other

Hi 

I have a table where i want to create join query like

(select * from patients where facility=abc) qry1

left join (select * from patients where facility=xyz) qry2 on qry1.patientid = qry2.patientid

Every now and then you may encounter a situation where for various reasons
ODBC is the only option to access a remote system. Which is sufficient as long as you need to examine or change tables.
But you can't directly execute some commands or change some Global.

I've just installed Visual Studio Code, installed the InterSystems ObjectScript Extension Pack as documented here, connected it to a local InterSystems IRIS instance, and created a workspace associated with one of that instance's namespaces. However, after doing this, I don't see the ObjectScript button on the left toolbar when opening the workspace.

The ObjectScript extensions are installed and enabled as shown below; I've tried reinstalling them and restarting VSCode, but this doesn't make a difference:

Has anyone seen behavior like this before?

Hey everyone.

It seems that my email address being updated with Intersystems has created a new account on here, and when I attempt to login with the old email address it logs into the new account meaning it looks like I have no post history.

Has anyone else faced this and have any advice on how to resolve it or any thoughts on if this is likely to affect other services like Learning and Global Masters?

Hey Intersystems Community,

I have a Problem with the Session Handling in .csp.

I wrote all my Web Services in .csp-Pages and do the work for example in the OnPreHttp Method for to get some data.

After that the Web Service response is in JSON.

I call These Web Services via fetch in my react Single Page application, also Many request parallel. The react App is Rolled out as index.html.
Everything Works Fine with the session Handling via Cookie.

I got this error saying, Zlib1.dll is missing on my Windows 10. Here's the screenshot: How to fix it?

Hello, everyone, 

Now that Virtual Summit 2020 is over, we'd like to remind everyone that we would still love to hear your input on Certification topics via a very brief survey - less than 8 minutes. You can even indicate if you would like to be a Subject Matter Expert for us in the future and what kinds of incentives you'd like to receive to do so. 

Please let us know your thoughts: 

https://www.surveymonkey.com/r/2ZVHNPS

Thanks, 

Jamie Kantor, Certification Manager

This may not be the right place to ask, but I am having some issues with the VSCode setup. I have installed the InterSystems Extensions but I am not seeing the InterSystems icon on the Action Bar long the left side of the screen.

Can someone point me in the correct direction of what I need to do to fix this issue?

Thanks

Scott

Hello Everyone,

We are working on growing the InterSystems Certification program, and would like to gather some input from the community.

Please participate in this brief 6-minute survey to share your thoughts with us regarding the new certification exams we have planned and other program improvements that we are considering.

https://www.surveymonkey.com/r/2ZVHNPS
 

Thanks for your help!

Hi Community:

How did Credit Suisse, the VA, and UC Davis advance their digital strategies during the pandemic? Find out on Day 2 of our first-ever InterSystems Virtual Summit. Plus, you’ll hear from our heads of Client Services, Healthcare, and Data Platforms on the ways we’ve adapted, innovated, and built new solutions to help you weather any storm ahead. 

To join us: 

1. Register or log in on the conference platform. You'll land in a virtual lobby. 

2. Click the Keynotes button to enter the virtual auditorium.

3. Then click Day 2 (If you missed the Day 1 keynotes, click Day 1 for replay.

Hello there,

I am new to the developer community and i intend on writing a new article.

I have a few ideas on what to write but i need to know specifically what kind of content it has to be? 

I do not want to update content that is not valid and waste the time. 

Please let me know what kind of content am I allowed to post as it will be very helpful for this purpose.

Also if i post something and want to remove it i need to know how i could delete / remove what I have posted, or should I inform the relevant authorities if any on instances as such. 

Hoping to hear soon.

Thank You.

Regards. 

Hi Community:

We're running about 30 more Focus Sessions than last year at Virtual Summit 2020. Download our Guide to Focus Sessions attached to this announcement. And register today!

Hi, everyone!

InterSystems Certification is once again offering a promotion with InterSystems yearly conference, Virtual Summit 2020!

Read details here. Let's get certified!

How can I deploy an itemset to a newly created namespace when the item is already in LIVE status? I tried to just hit deploy in the itemset and I got an error, not sure if there is an error on my configuration or if it is something else? 

Developments Healthcare Edition: Virtual Summit Updates, New FHIR resources, more

Hi Community:

Take a look at the latest Developments.

I have a number of globals I want to loop through depending on a passed in string...

^A("SYSTEM")

^B("SYSTEM")

^C("SYSTEM")

^D("SYSTEM")

^E("SYSTEM")

I am passing in a string of "A:C:D"

Piecing that to pull out A,C,D, then want to use that to pull out A,C,D from above, but having problems setting the name of the global to be the name of the variable I have pulled out of the string

How do I set this?

I have tried ^varname("SYSTEM")

also tried setting a variable to have the value "^varname" and using that

Thanks

Hi Developers,

Please welcome the last video from Global Summit 2019 on InterSystems Developers YouTube:

⏯ Personas: Your Teams Quiet Partners

Caused by a conflict in the port assignment I get this  entry in mesages.log and SMP doesn't respond:

The first line is true, the second is just wishful thinking 

demo code on GitHub

In most cases, a global used by default storage has just 1 subscript level that represents the IDKEY.
For an index-globals we may see 2 or more subscript levels.
Arrays, or parent-child relationships or persistent classes extending a base data class
are examples where we see more levels. Though all these globals are quite uniform.

Globals in Caché / Ensemble / IRIS are normally invisible over SQL access
This example shows how to overcome this limit.

I studied about developer services offered by main manufactures, and InterSystems is the leader, see:

Hi Community:

Watch your inboxes for our latest issues of Developments and Developments Healthcare Edition.

It is a classic Global Mapping exercise presenting ^SPOOL as Class / Table

Background

Device #2 named SPOOL dates back to the predecessors of Caché and IRIS
It was the first "%Stream" like option to buffer output before printing.
It is also the first and till today the most simple way of output redirection.

Solution

This is also an example of a mapped Global.
USE 2 redirects the output into the Global ^SPOOL

You can read the global manually or with some ancient utilities
or use this mapping to access it as class or a SQL table.

The guide “Extending Languages with %ZLANG Routines”
Tells you all details you need to know to extend your programming language.
EXCEPT: How to do it in a clean way.

This example of a %ZLANGC00.mac may show a possible approach
to get an easy to overview and to manage setup.
With less than 50 lines of code you might not be affected.
But if your Studio shows close to 1000 rows or more you may get in troubles.

My recommendation is simple.
Instead of adding line-by-line commands and it's code
you isolate each command and its code into a separate Include file.

During the development of the Terminal Multi-Line Command Editor I discovered in my IRIS installation
a piece of software that I just can classify as a historic artifact. And it is still fully operational !!!

As it dates back to times before InterSystems was founded in 1978 you may understand my surprise.
I personally stepped into that environment in 1978 and used it then for daily work.

Hi everyone. 
We are a team of company  "Constructor" and we develop cutting edge cartographic systems. Recently the amount of image data skyrocketed so we want to give our users the ability to tie images to places automatically. For that, we want to use AI/ML technologies and we have a cool task for you.

https://cloud.mail.ru/public/pHbC/4r7Z58m6f/

There are three collections of datasets and in each you have:
Image from the original camera with no position information and set of images made from different points of view near this original camera with position information (list_files_info.

Hello,

I would like some advice please. I am trying to send a Httpnetrequest in the form of a JSON message. To request for the web token I have created a method which has the relevant message body and its corresponding values and sent this to the Process. The Process has a method called Transform Message which takes the message and changes it to JSON format and passes it through to the Operation. The Operation currently has the basic HTTPNetrequest listing the relevant information for the website that we are trying to reach. The task has been created to try and invoke the service into action.

The Command extension enables the execution of Multi-Line Commands from Terminal prompt.

Installation & Execution

Import %ZML.xml to Namespace %SYS

Optionally you may add this line to your %ZLANGC00.mac for a simplified use:

ZML do ^%zml quit  ; add multi line command in terminal

and
USER>zml

otherwise, just call it from the terminal command prompt

  USER>do ^%zml

Usage

at the prompt USER:zml:1>
- enter commands as usual
- trigger execution by an empty line
- stop multi-line option with a single '.' (dot) at first position

Example

USER>zml
Entering multi line mode. Run with empty line.