I running a query and get the results inside a result set. Now I have to iterate through the result set many times. From the doc I've seen only the Next() method. Is there a way to reset the cursor? Otherwise what is a good data structure to save multiple rows of a table?

My code in this case is something like this:

set sql = "SELECT * FROM MY_TABLE WHERE X= '"_Y_"'"
set status = ..Adapter.ExecuteQuery(.rs, sql)
// somehow iterate the rs more than one time

Hi Community,

Just wanted to let you know there's still time to get a $25 dollar gift card from Gartner for reviewing our products. Reviews must be objective (no InterSystems employees) and approved by Gartner. Here is the link: https://gtnr.it/3ulVX4K

Hi guys,

I've a zen page report that I would like to export to .csv file, any ideas on how to do that?

Thanks

How would you like to be able to access the Web Terminal directly from your VSCode?

Hello, everyone!

InterSystems IRIS has a menu called Interoperability.

It provides mechanisms to easily create system integrations (adapters, record maps, BPMs, data conversions, etc.) so different systems can be easily connected.

Hi guys,

We are connecting to a 3rd party SOAP web service. The wsdl looks like below

Please notice that the portType was defined as /cvpService.

Then when we are trying to use SOAP Wizard to generate a client for the service, we will encounter the following error which prevented the generation

Hello All,

I am just wondering if there is any inbuilt function or utility available in IRIS to clean up "null" elements from JSON e.g. I want to remove "null" elements from payload below before I do any processing with it.

{

recipients: [

{ "name":"Utsavi", "email":"utsavi@gmail.com"},

{ "name":"Utsavi 1", "email":"utsavi1@gmail.com"},

null, null

],

content:[null, {"title":"Test.pdf", "data":"ygwehfbnwfbhew"} ]

}

Thanks & Regards,

I ran into an interesting ObjectScript use case today with a general solution that I wanted to share.

Use case:

I have a JSON array (specifically, in my case, an array of issues from Jira) that I want to aggregate over a few fields - say, category, priority, and issue type. I then want to flatten the aggregates into a simple list with the total for each of the groups. Of course, for the aggregation, it makes sense to use a local array in the form:

agg(category, priority, type) = total

Such that for each record in the input array I can just:

Hi All,

We have a requirement for one webpage that should be access in our VPN with out authentication. If it asks user name password that also fine.

This page should be a dashboard for the ensemble health monitoring. Support Team seating Area we have big SMART Monitor which always shows this webpage. Support engineers keep on eye on this monitor, if it shows action required then . they will act upon immediately. Expecting some widgets like

Hi folks!

Sometimes we need to import data into InterSystems IRIS from CSV. It can be done e.g. via csvgen tool that generates a class and imports all the data into it.

But what if you already have your own class and want to import data from CSV into your existing table?

There are numerous ways to do that but you can use csvgen (or csvgen-ui) again! I prepared and and example and happy to share. Here we go!

Hi Developers!

This is a release of how did we improve the Developer Community in March 2021. The key features:

• Global Masters badges page
• User mentions page
• Post translation indicator
• Updates in the Jobs section
• Updates to the "New post" button on DC Tag page

See the details below.

Hi Guys,

I'm using a Modal Group but whenever I click outside it the Modal gets minimised, so How can I change the view so that whenever pops up the view get locked until I'm finished with my modal then click exit to endModal ?

thanks

We've been tasked with developing a file upload module as part of our wider system, storing scanned documents against a patients profile. Our Intersystems manager suggested storing those files in the DB as streams would be the best approach and it sounded like a solid idea, it can be encrypted, complex indexes, optimized for large files and so on. However the stake holder questioned why would we want to do that over storing them in windows folders and that putting it in the DB was nuts.

Hi

How can we pass X509 Certificate upon calling FHIR API ?

Thanks