New post
AllAccepted answers
Pierre LaFay · Feb 23

Is it possible to use value for search condition like this :

SELECT p.%ID, p.name, p.street, p.city, p.state, p.postal_code,
    pn.phone_type, pn.country_code, pn.phone_nbr
FROM demo_intersystems.Person p,
    JSON_TABLE(p.phone_nbrs, '$'
    COLUMNS(
    phone_type VARCHAR(10) path '$.type',
    country_code VARCHAR(8) path '$."country_code"',
    phone_nbr VARCHAR(12) path '$.number'
    )
    )
WHERE country_code = 1

If yes, I think this might not be very efficient, as it has to interpret JSON expressions for each row in the table, without using indexes.

Pierre LaFay · Feb 11

hi @prashanth ponugoti 

To use hypps you have to install CSP Gateaway in an external apache (or nginx) web server.

This external web server can be configured for https (with let's encrypt certifcate if you need fee certificates)

The documentation for csp gateway.

Modifying internal server configuration is a bad idea because in new versions of Iris, it will not be included in the distribution.

Pierre LaFay · Jan 12

To access to a session in a remote iris instance by ssh, you must

Etablish a functionnal ssh link between your client and your server (For the rest I will call them CLI and SER)

To test this first phase from your client

ssh user@SER

after connection by ssh check your Iris Instance is running 

iris all

If yours instance is up like : 

    Instance Name     Version ID        Port   Directory
    ----------------  ----------------  -----  --------------------------------
up >IRISHEALTH        2023.1.0.229.0    1972   /usr/iris/2023.1

You can now launch a session and access a terminal :

Pierre LaFay · Jan 12

You are in the right place to have the information you want:

On this web application (https://community.intersystems.com/) you have access to
Resources intersystems on l-the left bar in community t tab where you can find a kit to start using Iris (in a container or not), I suggest you docker container for a faster setup


The learning tab will provide access to course videos
The Documentation tab to the product documentation with a search function (The documentation also includes very useful how-to sections)
The open-exchange tab offers example applications or utility classes that can inspire or save time during your projects.

And of course the community tab. The people here are all kind and will try to help you. You will also find articles full of useful information there.

So you can ask your questions as you learn.

Last but not least: Welcome to the Intersystems community !!

Pierre LaFay · Jan 11

If your goal is to delete this file one time you can do it with one of theses methods :

You can delete the file by using terminal : (the sudo command set you with all privileges on files)

sudo rm /tmp/test/test1.txt

Or from an Irii terminal

!sudo rm /tmp/test/test1.txt

If not can you tell me how you create it, and give the result of this command ?

ls /tmp/test.txt -lh

or (in Iris terminal 

!ls /tmp/test.txt -lh
Pierre LaFay · Jan 6

Hi @David Hockenbroch, 

I think I've found another way to protect a route.
I'm not protecting the route itself, but the method it points by using [ Requires = "myResource:Use" ] on the called method:
 

/// Sample API
Class Test.Api Extends %CSP.REST
{

 XData UrlMap [ XMLNamespace = "http://www.intersystems.com/urlmap" ]
 {
	<Routes>
		<Route Url="/test" Method="GET" Call="Test" />
	</Routes>
 }

 ClassMethod Test() As %Status [ Requires = "myResource:Use" ]
 {
  Do ##class(%REST.Impl).%WriteResponse("api method test : OK")
  Return $$$OK
 }
}