Hi Guys,

usually when I want to find out which class is a zen page is, I just right click on the page and go to properties and this will show me the class url, but with this client I don't get properties as below !?

Thanks

What will the ideal learning path for a DataScience & AI aspirant ? 

Hi Community:

We've just posted our Global Summit Sessions to our website here > and most of the keynotes here >   Note: some of the keynotes from our external speakers could not be posted.

Enjoy!

Jacquie

This is the third in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready.  Many updates, fixes and enhancements have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. Please share your feedback through the Developer Community so we can build a better product together.

The Early Access Program (EAP) is still active for the Columnar Storage.   Customers interested in exercising it should join the Early

I am reaching out to find out if anyone has come across a similar dilemma. 

In my current role, I have been asked around the best way to design some patient labels for a client.

 I primarily would stick to what I know and veered towards designing the label in ZPL and then creating a Abstract Class to call the ZPL code, however I have been asked why not to design via JReport. The patient labels will be processed via thermal ink printers primarily Zebras, I am wondering if anyone out there has come across this or  would recommend to stick to what you know. 

I have reached out via I-Service but

How do I open the open exchange terminal in VSCode to download applications?  Thank you.

I'm getting wrapped around the axle with CAST and CONVERT and can't seem to find a way to do this (short of adding a stored procedure wrapping $zdt($zdth(posix,-2),3), which I'm refusing to do on principle, because there has to be some way to make this work).

Any ideas?

You know several languages and wish to share your knowledge with users in different parts of the world who don't speak English?

Now it's your time to shine! 🤩

With our Developer Community, it is easy to link your original article and its translation in a different language (or even ask for a translation).

So let's talk about creating your own translation:

Hi community,

This is the third article in the series about initializing IRIS instances with Docker. This time, we will focus on Enterprise Cache Protocol (ECP).

In a very simplified way, ECP allows configuring some IRIS instances as application servers and others as data servers. Detailed technical information can be found in the official documentation.

This article aims to describe:

• How to script the initialization of a data server, and how to script the initialization of one or more application servers.
• How to establish an encrypted connection between these nodes with Docker.

To do this, we

Hi Guys 

how do I deal with single Quote inside string in an SQL query?

currently this type of query is failing with an error asking me for a closing quote :

Select * from cnd.Facilities  where name like ''%Grill's BBQ%'

Thanks

Hi community!

I'm using Insomnia software for testing my REST applications from cache and wanted to know how do I debug POST that got sent into backend by this tool via json sent from the request body!

I'm using 2018 cache and running tests by VSCode
thanks for any help

Hi Community!
We hope you have an exciting and inspirational summer (or winter, depending on where are you located)! 

Today we launch the Inquisitive Summer on the Developer Community. Which means:

This is an error I am getting when I try to run a ZEN report

I am trying to use EnsLib.SQL.Operation.GenericOperation for retrieving (multiple) rows. But I am looking for a way to handing a StreamContainer returned by the operation, in my business process such as receiving it in the Context object and packing it to a request to call another business operation.

Does anyone have sample code to do this?

Thanks.

Hi Community!

We are proud to announce that InterSystems will be hosting the Women's Health - FemTech: Much More than A Niche Market!

⏱ Time: July 28, 6:00 PM – 7:00 PM EDT
📍 Location: Online event

I am calling a stored procedure over an ODBC connection and every time I call it there are several warnings written to the log event {Found no Parameter 1 (used as 1) for query}.I seem to be getting this on every query executed and that seems to happen a number of times the query parameters are per query and its filling up my disc.

1) Is there a way to suppress these warnings as the query seems to be executed and data written to the database?

2) Is there a way to pass Null values to the procedure and not generate these warnings as I suspect there are caused by the Null values expected to

Hi Guys,

We use the below code to send JSON file to one of our clients and was working fine but I think lately they did a windows update and now whenever we send file we aren't getting any HTTP responses, success or Error, just empty response ()

the think is that it works fine and we get 200 response if we send the JSON file using our client's portal called swagger which is a website where you can assign the token and url (Swagger UI (vibra-api-prod.azurewebsites.net))

nothing has change from our end so why we aren't getting any HTTP response as all (see below)?

s Token=GetToken()
S FilePath="D:\Co

LS, Is it possible to create User Accounts, and assign specific Roles to them, from objectscript?

Hello, I'm using the InterSystems IRIS connector for Power BI to connect to our Iris for Health database, using Direct Query.

I have a column [Company] which is datatype bigint, and as far as I can tell the data is 2 for most (or all?) records.

When I bring the data into Power BI, every row shows as NULL (I think it should be 2 for most)

= Table.SelectRows(Table, each [Company] <> null and [Company] <> "")

-- removes all rows

so instead I use

= Table.SelectRows(Table, each [Company] = 2)

-- the nulls magically become 2s (other numbers I've tried lead to an empty table)

but, out of the first 10  (eg

Mixing Object syntax with SQL is one of the nice features in Object Script. But in one case, it gave strange results, so I decided to isolate the case and describe it here.

Let's say you need to write a classmethod that updates a single property on disk. Usually, i would write that using SQL like this :

and call this

Developer Preview releases are now available for the 2022.2 version of InterSystems IRIS, IRIS for Health, and HealthShare Health Connect.

This is the second in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready. This program allows us to get feedback on capabilities and enhancements as they're available. You'll see below a list of enhancements that are targeted for 2022.2. Some these are not included in this developer preview.

Hi,

I'm trying to load some data into IRIS using LOAD DATA in the IRIS terminal however I am getting blocked by this error. I have read the documentation on this page trying to set up a gateway connection but get the same Connection cannot be established error.

This is what is in the %Java Server activity log

ID 	Date Time 	Record Type 	Job 	Text 
8132022-07-1810:37:09	Info	28048Job command successful, started monitor process '6404'
8112022-07-1810:37:09	Info	28048	Starting background process to monitor the Gateway Server
8102022-07-1810:37:09	Info	28048	Gateway Server start-up

Is there a way to perform an %Prepare()/%Execute() that will wait until the record being queried is unlocked by another process? 

Ex: 

Process 1 - is opening record, updating, then saving. NOTE: this is using embedded SQL

&sql(SELECT %ID INTO :id FROMtable WHERE Prop=:prop)
s obj=##class(APPTRACKER.CacheHB.CustomEventCacheHB).%OpenId(eventId)
//updating record...s sc=obj.%Save()

Process 2 - is querying the same record while Process 1 has it open. Result is nothing is returned and %SQLCODE is 0

//simplified snippet with extra code removed
    ...
    s sql = ##class(%SQL.Statement).%New()

Hi,

I want to access a Stored Procedure in a remote SQL Server Database. I am quite new to Object script.

The stored procedure has 3 parameters: 2 datetime parameters and 1 integer.

Which is the best way to do that? I'm wondering if I can use the link stored procedure feature inside object script or some SQL statement in Object Script.

This SP returns a set of rows which I want to read, transform and save in a persistent class.

Thanks in advance,

Hi Community,

Just thought I'd let you know that you can still get a LifeStraw water bottle for completing a Gartner Peer Insights survey. With a built-in filter that removes bacteria, parasites, and microplastics, this water bottle is especially useful for hikers. Plus Gartner will give you three months access to its Peer Insights Plus, "an exclusive service that aims to help tech professionals stay current on technology trends and excel in evaluating software/services."

The Gartner reward is automatic.

I want to display to the user on their Zen page how much time is left before their session times out.

I know I can set the %session.AppTimeout to a particular value (or manage this in the Web Application) and I know I can retrieve this value from the %session object. I also know that I can set an event handler to do something when the session has timed out but I cannot find any way to determine how long before the session ends via the application timeout so that I can keep the user informed.

I'm aware the session timeout triggers based on the inactivity of the user but I can't find anything

Hey Community,

We are super excited to announce the winners of the InterSystems Full Stack Contest 2022! 

Thank you all for participating in our coding competition! And the winners are...

Hi! My name is Sergei Sarkisian and I’m creating Angular frontend for more than 7 years working in InterSystems. As the Angular is very popular framework, our developers, customers and partners often choose it as part of the stack for their applications.

I would like to start series of articles which will cover different aspects of Angular: concepts, how-to, best practices, advanced topics and more. This series will target people who already familiar with Angular and wouldn’t cover basic concepts. As I’m in the process of building articles roadmap, I would like to begin with highlighting some important features in most recent Angular release.

Hi! Today I would like to talk about one of the most important architectural patterns in Angular.

The pattern itself is not related to Angular directly, but as Angular is component-driven framework, this pattern is one of the most essential for building modern Angular applications.

Container-Presentation pattern

It is believed that good components should be small, focused, independent, testable and most important - reusable.

If your component is making server calls, contains business logic, tightly coupled to other components, knows too much about other component’s or services’ internals, then it

I did a google search for 'Grafana' and 'IRIS Health'.

This gave these candidates:

https://github.com/caretdev/grafana-intersystems-datasource
https://community.intersystems.com/post/using-grafana-directly-iris
https://grafana.com/grafana/dashboards/14869

Does anyone know which one is 'best'?
If you have used any of these, do you have any detailed instructions on how to install?
Most of these packages assume you know how to install and run them and so are very light on how to install.

I'm using Grafana on a Windows platform (without the use of docker)