I am updating the PV1 segment with values from the database but when I get two values back I dont know how to separate them with a tilde and insert. Any advice for me on that?

so if I get two values returned

my PV1.7 segment should be :  

My current code is as below: It works fine for one value, but when there are more than 2 values returned I need to find a way to include it

Set res=##class(%ResultSet).%New("%DynamicQueryGW:SQLGW")

Set sc=res.Prepare(sqlstring,,conn)

Set sc=res.Execute()

while res.Next()
    {
     s RET = res.GetData(2)
}
    
    s sc=res.Close()
    
    Set sc=conn.Disconnect()

/

We're working hard to bring you the learning content you need -- help us by taking this 2-min survey to tell us what you're looking for!

May I ask what the solution is to the error below?

Recovery started at Fri Apr 23 09:14:58 2021
     Current default directory: c:\intersystems\cache\mgr
     Log file directory: c:\intersystems\cache\mgr\
     WIJ file spec: c:\intersystems\cache\mgr\CACHE.WIJ
Recovering local (c:\intersystems\cache\mgr\CACHE.WIJ) image journal file...
Starting WIJ recovery for 'c:\intersystems\cache\mgr\CACHE.WIJ'.
  0 blocks pending in this WIJ.
Exiting with status 3 (Success)
04/23/21-09:14:58:844 (10096) 0 Automatically configuring buffers
04/23/21-09:14:59:422 (10096) 0 Allocated 1164MB shared memory (large

Hi, Community!

Please share your experience on code deployment on production site. Do you compile ObjectScript on Production? Is it OK? 

Or you only compile on Test site and copy cache.dat to a Production?

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ ObjectScript Package Manager ZPM: Installing, Building, Testing, Publishing IRIS

Hello Community,

We want to send ALL updates from our Cache server to a remote SQL Server instance that will be used as a reporting data warehouse.

Has anyone done this already and if so what is the best way to go about setting this up?

Thanks

Regards

Mike 

Hi Developers,

Enjoy watching this new video presented by @Evgeny Shvarov:

⏯ Package First Development Approach with InterSystems IRIS and ZPM

Hello. I have a query in the database that returns several rows, I need to get an "X" number of results randomly.I tried traditional commands from other languages but was unsuccessful.Does Caché have something like that? 

Hey Developers,

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

Over the last couple of weeks the Solution Architecture team has been working to finish off our 2019 workload: this included open-sourcing the Readmission Demo that was brought to HIMSS last year, so we could make it available to anyone looking for an interactive-way of exploring the tooling provided by IRIS.

While in the process of open sourcing the demo we were immediately hit hard with a showstopper.

Hi,

I'm getting thousands of errors like the ones below:

2021-05-03 14:11:44 [SQLCODE: <-400>:<Ocorreu um erro fatal>] [Cache Error: <<READ>Dispatch+14^%SYS.BINDSRV>] [Location: <ServerLoop>] [Client info: <Username: KIORAS, Node Name: 3IK0VLS5UU, IP Address: 192.168.1.223, Executable Name: EXTRService.exe, Internal Function: B0>] [%protocol: <52>] $Id: //ce/2018.1.2/kernel/common/src/aclass.c#1 $ 23468 104

2021-05-03 14:35:39 [SQLCODE: <-400>:<Ocorreu um erro fatal>] [Cache Error: <<READ>ServerLoop+16^%SYS.DBSRV>] [Location: <ServerLoop>] [Client info: <Username: KIORAS, Node Name: D5MWWW2,

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

As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together.

InterSystems IRIS Data Platform 2021.1 is an extended maintenance (EM) release.Many important new capabilities and enhancements have been added in continuous delivery (CD) releases since 2020.1, the previous EM release.

Hello everybody,

I am creating a WS as a server, but when I ask for the WSDL it is giving me an error because it cannot find the class.
I have added the following instructions:

set ^SYS("Security","CSP","AllowClass","MiProyecto.MiClaseWS","%SOAP.WebServiceInfo")=1 
set ^SYS("Security","CSP","AllowClass","MiProyecto.MiClaseWS","%SOAP.WebServiceInvoke")=1

I have created an entry in the WS security configuration

In the Application Roles tab I have put the %All permissions

(The Namespaces "Samples" in the image is due to security reasons)

If I invoke the service in the following way, http://localhost:

objects in javascript :

var oM = new Object;

var mMode=["down","up","click"] ;
var key,val ;
    for (key in mMode)
    {

       val = mMode[key] ;
        oM[val]={} ;
        oM[val].id   ="" ;
        oM[val].type ="" ;

       ...

 }

so I can access the .type directly as :

oM.down.type

or:

oM["down"].type

what is the syntax in CACHE or IRIS, to achieve such approach via class/key/property...?

acctually: class/object/key/property anlaogue to ^GLOBAL(key,"property")=val

in CSP what is the difference between OnPreHTTPafter and OnPreHTTP.

And how code execution is different if written in above mentioned TAGS and  <script language="cache" runat="server"></script>

Why SSH ?

If you do not have direct access to the server that runs your IRIS Docker container
you still may require access to the container outside "iris session" or "WebTerminal".
With an SSH terminal (PuTTY, KiTTY,.. ) you get access inside Docker, and then, depending
on your needs you run "iris session iris" or display/manipulate files directly.

Note: 

Introduction

This is iris-key-uploader a frontend in Angular with it's rest API.

The aim of this project is to easily import key file to Iris from a web ui.

Why this project

Unfortunatly the IRIS panel to change key doesn't give the opportunity to upload the license.

As you can see, you can only browse from the server side.

What if, you don't have a direct access to it ?

You would like to have a simple web page to upload the new key and activate it.

This is the purpose of this project.

Demo

UI

http://localhost:52773/keyuploader/index.html

Build

Run the server

docker-compose up -d

Install with ZPM

zpm

Let's say I have a persistent class Sales.
I need to create a report that shows the amount of sales for each branch.
By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown.
Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?

Earlier this year, the AppS.REST package was released. AppS.REST is a framework for easily exposing existing persistent classes in IRIS as REST resources. AppS.REST-enabled classes support CRUD operations with little effort from the developer, bridging the gap between persistent data in IRIS and data consumers, such as an Angular front end application.

But IRIS classes are much more than just a definition for loading and saving individual records! This article aims to highlight a few ways to leverage the power of IRIS in your REST applications.  Using the Phone.Contact sample app, we'll look at out-of-the-box query support, use of class queries and finally ObjectScript methods.

I'm attempting a first-time installation of IRIS for Health on my home Mac for eval purposes. I want to be able to install IRIS and Ensemble. I downloaded the package but it doesn't come with instructions, and I'm running into issues. Is there a straightforward install instruction set online, or does anyone have one you can pass along?

Thanks, Jim Winski

Hi  Developers,

A new video is already on InterSystems Developers YouTube:

⏯ Getting Started with HL7 Routing Rules

Like hardware hosts, virtual hosts in public and private clouds can develop resource bottlenecks as workloads increase. If you are using and managing InterSystems IRIS instances deployed in public or private clouds, you may have encountered a situation in which addressing performance or other issues requires increasing the capacity of an instance's host (that is, vertically scaling).

One common reason to scale is insufficient memory. As described in Memory Management and Scaling for InterSystems IRIS in the Scalability Guide, providing enough memory for all of the entities running on the host

How are others deploying API Manager services, routes and plugins from one environment to another?  We plan to use cache object code to deploy.  Is it best to embed curl or is there a better way?

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript

Hi all,

I'm wondering if is possible to get the values of itself to run a query.

I want to create some query to find a value into a %Persistent class but each one use diferent values.

Class Kurro.MyClass Extends %Persistent
{

/// Key of process
Property KeyProcess As %String(MAXLEN = "");

/// Specialist
Property CodeSpecialist As %String;

/// Provider
Property CodeProvider As %String;

/// Center
Property CodeCenter As %String;

/// Date
Property Date As %TimeStamp;

/// IdList
Property IdList As %String;

/// IdProcess
Property IdProcess As %String;

/// Duration

According to IDC, more than 80% of information it is NoSQL, especially text into documents. When the digital services or applications not process all this information, the business lose. To face this challenge, it is possible use OCR technology. OCR uses machine learning and/or trained image patterns to transform image pixels into text. This is important, because many documents are scanned into images inside PDF, or many documents contains images with text inside. So OCR are an important step to get all possible data from a document.

To do OCR, the main open source solution used is Google

I am getting the below error while navigating a next page from the list in Management Portal

Must have Java Enabled to use hyperevent call

Unable to locate CacheCSPBroker applet!

I have already enabled Java in Java Control Panel 

Any help is much appreciated

Thanks & Regards,

Sadagopan TS

The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc"

is there a SAFE way I can give him access to our database using an intelligent visual user interface.

I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal.

I also need to make it READONLY, again for