All
Accepted answers
Pierre LaFay · Jan 12, 2024 go to post

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, 2024 go to post

Hi @Logan Kitchen 
 

Are your databases part of a Namespace?

If this is not the case, this is necessary to access it through the Explore>SQL tab.

You can create Namespaces in System>System Administration>Configuration>System Configuration>Namespaces.
They can use existing bases

Pierre LaFay · Feb 5, 2024 go to post

Thanks to @Ashok Kumar T & @Timo Lindenschmid 
This is working fine, and I do that but this not an answer to my questions :

  • Calling a class from another Namespace?
  • Is there a way to map a table from one NS to another?

I think this must be possible by mapping %SYS bases, but I find this not very secure, I will search more in the doc...

Pierre LaFay · Feb 9, 2024 go to post

Thanks for tour answer @Prasanth Annamreddy but the problem wasn't in the Package Name 

(in ##class() the param is full className : package.class), so in my Case Bna.Utils is the package and Sql is the classs

Pierre LaFay · Feb 11, 2024 go to post

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 · Feb 23, 2024 go to post

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.