Hi,

I seem to be able to execute sqlproc using the convention defined here https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GSQL_… provided the package/folder is a single level. As, soon I have a nested folder structure I get an error while trying to execute this. 

For instance, 

select id, Utils.Users_getRole(id) roles from users.users

works fine while, 

select id, com.xyz.utils.Users_getRole(id) from users.users
does not work and gives,  "User defined SQL function ... does not exist"

I am on Cache 2017. Is there a workaround to making this work? 

Hi,

I am working with XML and I would like to be able to access parts of the XML document and return them as a string.I am building an XPath document then evaluating an expression on it which returns a list of DOMResult objects.After accessing one of the objects I would like to convert this to a string and am having difficulty in doing this.I originally went down the path of essentially creating my own parsing method that converts this to xml itself, but a collegue has pointed out I might be able to use the %XML.Writer class to do this.

Hi Community!

We are pleased to invite you to the upcoming webinar in Spanish: "Improving Kubernetesperformance", on December 9, at 4:00 PM (CET).

Hello! 

How to set null in variable? 

I need to create JSON like below:

{

"id":"1",

"Code": null

}

we are getting number of msgs from multiple facilities into our HIE solution, now which facilities is sending bad quality data and put some process around it to improve the msg quality

so where to start to generate this report, any guidance would be appreciated. 

InterSystems Queryable Statement Metadata

Dynamic SQL allows the user to dynamic create, populate and query tables, call procedures and functions, and so on - all without writing any ObjectScript. Of course, this capability is completely normal for xDBC clients. InterSystems Dynamic SQL has been available in Caché for several years and is available in all versions of InterSystems IRIS. What I am about to describe should work for all versions of InterSystems IRIS and for all versions of InterSystems CE that support SQL Table-Valued functions.

If people are interested then I'll learn how to post

For those that want to catch up on the FHIR-related content in our Virtual Summit 2020 I put together a list of the Focus Sessions:

Hi Developers!

Want to raise security discussion today!

Let's discuss how InterSystems security for applications works. In general, the concept is clear: we have Resources (what to protect), Roles which combine a set of privileges and accesses to Resources and Users which can have this or that Role.

But there is also a concept of Application which also could have a Role.

So you either provide a Role for a User or for an Application.

What do you use in production? What is your strategy and why? Pros, cons?

i have looked for $zf function，it says $zf(-6) will work,but it doesn't work out actually,anybody can give me a dll file which will work with $zf,if you should show me the way making the dll that is best!thanks!

Hi community!

Is it possible generate HTML documentation to my project ObjectScript classes (.cls)?

In Java we use Javadoc to do it. Javadoc get class comments and java metadata information and when I execute javadoc -d doc src\*, I get whole html documentation to my classes. Has IRIS something like javadoc? Is it documatic? If yes, how can I use it?

Hello there, 

I am Zainab a Medical Practitioner for a leading hospital in India. 

But i am about to start my new clinic and gradually build it to a hospital as well. 

I already have a very strong patient Data Base but I am afraid that day by day as it is increasing i will need a better one to handle things. 

I have a considerable amount of knowledge in IT as well. that is when I came across this thing called IRIS. 

I also saw we can use it for free. 

I need more details please on this. 

I also see many versions of IRIS. Please clarify that for me as well please. 

Hope someone can help me please. 

Than

Hi,

I'm trying to access the categories configuration for the WorkMgr via COS, so I can be able to create new categories for our processes and this way try to overlock the limit of cores*2 workers. I've seen that last version of IRIS is supposed to have a menu on the portal (System Administration > Configuration > System Configuration > WQM Categories), but since we are in 2020.1 this doesn't exist. 

Does anyone have experience with WQM.API to manage the categories, or the usage of ^%SYS("WQM") to set it directly?

My goal is to be able to go beyond the limit of cores*2 that currently is in the

We have 3 env. using different ports schemes Is there a way to create a rule if msg comes on ports starting 22 then route it to devoperation, if it starts with 33 then route to testoperation, if its 44 route to stageoperation?

Hi Developers,

Watch the new video on InterSystems Developers YouTube to learn how to develop with InterSystems ObjectScript using the Visual Studio Code plug-in.

⏯ Using Visual Studio Code and ObjectScript

Hey Developers,

The InterSystems Interoperability Contest is over. Thank you all for participating in our exciting coding marathon!

And now it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Hi,

I need to develop a HL7 Q22/K22 query/response mechanism for a NHS Trust I am working for, but I do not know how to handle the message continuation.

Can any one give me any advise on this and/or point me in the direction of any documentation on the subject?

Thanks

Neil Thaiss

When logging in to the management portal page, how to send the encrypted user name and password when sending a request

Report about what happened during a test - check Message Bank to see what happened on the instances that received test messages from Feeder
 

I developed Feeder on an IRIS instance while working in development VPC and I configured a Message Bank in a different namespace on the same IRIS instance. I added Feeder.csp and submitted Feeder app to Full Stack contest. I currently refactor the Feeder and Message Bank apps for Interoperability contest and to deploy in another VPC.

Below I show a sample report from development VPC:

NAMESPACE>DO ##class(UnitTest.TestReport).Go(564)

UnitTest 564 began

Hey Developers,

This week is a voting week for the InterSystems Interoperability Contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote? This is easy: you will have one vote, and your vote goes either in Experts Nomination or in Community Nomination.

Hey Developers, 

Please welcome the first session from InterSystems Virtual Summit 2020:

⏯ Creating InterSystems IRIS Analytics Solutions Using Docker & VSCode

I have multiple files with different columns, first 9 values are fixed, so i want to ignore the first value, and next 8 values i want to combine into one value using ^ sign

Current Format

|||||||||||^^||||||^^|||||||||||||||||
|||||||||||^^||||^^|||||||||||||||||||||||
|||||||||||^^|||^^||||||||

Desired Format

^^^^^^|||^^||||||^^|||||||||||||||||
^^^^^^|||^^||||^^|||||||||||||||||||||||
^^^^^^|||^^|||^^||||||||

Reading each line from the file use below code.

#dim line as %String = tInput.ReadLine(, .status)

"here i was to put some string function to change format of the data in line variable"

set status

Hi everybody,

Is there a way to run code on another machine? Of course, all authentication info is known. I know only about RemoteResultSet but that seems to be query specific.

Thanks in advance,
Anna
P.S. The ultimate goal, in case that matters, is to create identical globals on 2 different machines with one run.

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.

Greetings!

The application I work with has a need to update a user's google password using a service account and no user intervention other than clicking a link.  
I'm in the process of figuring out how to do that from an IRIS server.
I've set up an OAuth 2.0 client with one client configuration, attempting to follow the documentation in https://community.intersystems.com/post/intersystems-iris-open-authoriz… as much as possible.  
I also set up an SSL configuration to be used with Google.  
I have extremely limited confidence that any of this is set up

According IDC, 80% of all data produced are NoSQL. See:

There are digital documents, scanned documents, online and offline texts, blob content into SQL, images, videos and audio. Imagine a Corporate Analytics initiative without all these data to analyze and support decisions?

In all the world, many projects are using techonologies to transform these NoSQL data into textual content, to allows analyze it. See:

1. Scanned images and images with text extracted using OCR (Google Tesseract is a great option);
2. Videos analyzed with Visual Computing supported by Machine Learning (OpenCV is a good option)

Hi developers!

We introduced a set of bonuses to all the participants of the Interoperability Stack Contest. 

And here is the table of current bonuses accomplishments:

Keywords: Python, JDBC, SQL, IRIS, Jupyter Notebook, Pandas, Numpy, and Machine Learning 

1. Purpose

This is another 5-minute simple note on invoking the IRIS JDBC driver via Python 3 within i.e. a Jupyter Notebook, to read from and write data  into an IRIS database instance via SQL syntax, for demo purpose. 

Last year I touched on a brief note on Python binding into a Cache database (section 4.7) instance.

GoogleTransled by moderator:

Where is the operation of verifying the user and password implemented in the path interface? Thank you very much for your answer!

1. Define Persistent Class
Call utility class to fetch json via query.
Class Test.JSONFromSQL Extends (%Persistent, %Populate)
{
Property FirstName As %String(POPSPEC = "FirstName()");
Property LastName As %String(POPSPEC = "LastName()");
Property CountOfThings As %Integer(POPSPEC = "Integer()");
ClassMethod OutputJSON() As %Status
{
If '..%ExistsId(1) Do ..Populate(100)
Set sql="select FirstName, LastName, CountOfThings from Atmus_Web_Test.JSONFromSQL"
Quit ##class(JSON.FromSQL).OutputJsonFromSQL(sql)
}
2. Utility Class
Class JSON.FromSQL Extends JSON.Base
{
ClassMethod OutputJsonFromSQL(
sql,
%parm...) As %S

Hi Community!

How can I enable IRIS Text Analytics (formerly known as iKnow) in a given Namespace programmatically?