Hi

I'm trying to configure IIS for csp

After following the steps here

Configuring IIS to Work With the Web Gateway (Windows) | Web Gateway Guide | InterSystems IRIS Data Platform 2022.1

I get this on accesing a csp page

Web Gateway Version 2022.1.0.209.0

Systems Management
Invalid Request : Cannot identify application path

Hello,

Created my Learning Lab yesterday evening and for the first hour or so everything was fine, but after that it just stopped working and I get Server unavailable for Management Portal:

And nothing would load in VSCode

In trying to define a Class Parameter that I can use in SQLComputeCode I can't seem to get any of the syntaxes for the using of the parameter where the SQL compute code will actually evaluate the parameter values. There is nothing specific that I can find in the docs about SQLCompute Code and Parameter usage.

Is there some specific syntax for accessing a class defined parameter in the SQL Compute Code that works?

This is on: IRIS for Windows (x86-64) 2022.1.1 (Build 374U) Tue Oct 18 2022 17:37:34 EDT

Hello.

I'm trying to transfer two connectors from my test env to my production env ( both are IRIS 2021.1 )

So i have created an SSL configuration on both :

Test env :

Production env :

The connector work well on the test env. When i try the same code in my production env i got this error :

Hi Guys,

we this format of url with port required, and my guess that if we specify port 57772 as the default port in the web server which I'm assuming that would be Apache , we don't have to specify the port in our url, so how can set a default port in Apache?

http://localhost:57772/us-serenity/MSDS.SelectApplication.UI.SelectAppli...

Thanks

I have this code:

SELECT id,room,client->name,functionary->name FROM rooms ORDER BY id

What i do to access the "client" name?

Hi,

Is there a way to insert new Key/Value in an existing lookup Table via a DTL code? The only thing I found in the documentation is that we could use the following command SELECT KeyName,DataValue FROM Ens_Util.LookupTable WHERE TableName = 'myTab'. In the meantime I just created a table and used it in my DTL to insert new values and validate if the Key exist.

Regards

Hi guys,

Suppose I have a JSON string as below:

{"MessageID":"11111","save_date1":"2022-02-02 01:01:34","Sender_ID1":"esb","sent_date2":"1985-12-11 11:42:00"}

The two date variables are all formatted as ODBC date time, when I tried to import it to a %JSON.Adapter object, the date format was rejected as below

Error #9406:Unexpected format for value of field, save_date1, using class base mapping

Thus I'm trying to format all possible ODBC date time in the incoming JSON with Regular expression:

Hi Guys,

Hello!

I'm new to the system I'm working on, and I have a part of a statement that needs to grab the previous month.

....and MONTH(TX3.date_of_service)= MONTH(dateadd(mm,-1,GETDATE()))

However, when it hits January, I'm left with month 0.

Does anyone know a workaround to grab December of the previous year, while still functioning normally for the rest of the current year.

Thank you!

I am familiar with $TEXT which can get you any line in the current routine provided you know the offset. For example, $T(+1) will get you the first line of the current routine at the run time. In the same vein, how do I reference the current line number/offset at the run time? Something like $T(+$CURRENTLINENUMBER) where $CURRENTLINENUMBER is not yet known to me function. The sample below would write 3 as the line number.

RTNNAME
S A=1
W $CURRENTLINENUMBER

When I'm writing code in Intersystems Studio code completion is different than in VS Code. It would be greate if VS Code would react the same way on code completion .. This happens is studio

When I do this in VS Code it doesn't show the object but it shows ?? all possible items ??

Hi Community,

My IRIS.DAT file is corrupted on one of my Edge productions in the development environment and as a result, I cannot start production.

I would like to recover it if there is a way to do so, please assist.

Regards,

Has anybody tried to write custom code to empty out queues when Interoperability shuts down? We run IRIS in Kubernetes cluster and we have compute pods scaling up and down. We have Message Bank operation to keep all messages in one place. We want to see all messages in Message Bank.