#InterSystems IRIS

In Management Portal one can create and configure connection in:

System Administration
 > Configuration
  > Connectivity
   > SQL Gateway Connections
    > Create New Connection

But how to create new connection programmatically?

Hi,

How do I create CSP page in IIS to be loaded from the class?

Im able to open my index.html but I have class webapp.init.cls which extends %CSP.Page which should generate html. If I write localhost/myapp/webapp.init.cls I just got an error Invalid action.

In IIS Handler Mappings I did setup for *.cls and *.csp files.

I followed this

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

i got a particular application where i want that a user could only write to a DB without the reading permission. is this possible?

I have a rest API Class used for getting data from Cache 2018 version.
I have single route '/callfuntions'
I send the following parameters to the API :- className, methodName, params
I use $CLASSMETHOD to execute and send the result back to the client.

If I make more that 10 to 12 requests in quick succession, then it stops sending data.

I have a local testing environment using VSCode.

I'm trying to create a routine %Test.mac, but keep getting permission error.

I have enabled write permissions to percent globals in the Admin Portal.

I'm connecting to Iris with superuser.

How do I give myself permissions?

Thanks

Hello All,

No matter what I try in Business Process Logic (BPL), I am unable to calculate the patient's age in days or years.

Has anyone ever built logic in a Business Process (BPL) to calculate a person's age in days?

Thank you!

I'm trying to use the assign option within a ruleset. I can trace the value with no issues but when I try to assign the same value to a variable of Namespace I get an error.
Ideally I would like to use a variable instead of repeating the Piece repeatedly throughout the rules.

Ruleset

Hello Community,

Hi group,

I am trying to take the InterSystems HL7 Interface Specialist certificate test.

So is this an open book test? is there any Lab involved with vm? I did the search but I am not able to find such information.

I am trying to find out more information before I actually take the test.

Thank you

Hi,

I've been working on a very basic Interoperability production in my computer. I followed one of the examples in the courses and created a TEST.FileRouterRoutingRule, but when trying to edit this rule, it takes me to the Rule Editor Login Page, where I can't get in (Not even with the _SYSTEM credentials) - Is this functionality unavailable in the community edition?

I ran into a situation where VS Code consumed all available web sessions and was unable to get to the Management Console to clear them. I was able to establish a terminal session, though.

Is there a method or routine available through the IRIS terminal that allows one to clear web sessions? I've searched the administration and class documentation and haven't found a solution.

I have an IRIS persistent class with a %Stream property whose value is a JSON object. I'd like to use a SQL trigger to pull some value out of the JSON and persist it in another property, for easy querying and indexing. See below for a minimal example:

I am struggling with returning a SQL Query Result that may have multiple rows that can be searched.

Hi developers!

While developing web apps the security practice I consider safe and convenient is to create a special Role (e.g. equal application name) which contains security resources which application will need (SQL tables, priviledges, database access, etc) and assign it to the Web Application.
So the user gets this role once it loggs in to the application (via password, no password or delegated).

Convenient, right?

So, the question is, when I deploy the app as an IPM module what should I put as a database access?