#InterSystems IRIS

Reference: sample LDAP code routine LDAP.mac

Some IF statements reference macro $$$WindowsCacheClient as a boolean flag to mark if the client calling the LDAP server is running Windows. Other IF statements reference $$$ISWINDOWS. Are they not the same thing? That is, does the routine need $$$WindowsCacheClient at all?

Examples:

#define WindowsCacheClient 1

I'm wanting to write a query in SQL that will return a row with a count for each day for a given month or year for a specific operation or configname. The following is a start but I'm not finding what I want in the documentation to parse out the TimeLogged field of the table. Nay help is appreciated.

SELECT count(TimeLogged), ConfigName
FROM Ens_Util.Log
where TimeLogged like '2021-07%'
and ConfigName = 'operation_Name'
group by TimeLogged

Hello, everyone,

I have the problem that when trying to connect to the SFTP server the error appears, the user and password are wrong. However, these are correctly stored under login data and I entered! SFTP in SSL Config. The connection works wonderfully with Filezilla. Anyone else has a tip for me?

greeting

I have a SOAP web service on an IRIS system. From within the code of the WebMethod I would like to log the remote IP address of the client. Is there any way to get access to the client's IP address from the ObjectScript code in the SOAP service? This will save me some headaches correlating logs from IRIS with web server logs.

Hi Friends,

I have created an object script class method to anonymize live hl7 messages with some info masking.

To anonymize files , I need to place live messages in d://input folder and need to execute the below command in the Intersystems terminal

do ##class(prashanth.tool.HL7Annonymiser).processFilesInDir("D:\Input\")

ANONYMIZED files will be generated in D:\output\" folder.

everything is working fine.

Here when i need to annonymise some files ,

1) I need to open terminal (iris)

2) connected to user

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:

looking into tenants I see this:

But on the main page, I have 2 deployments that I can work with !!

What is going on ??

Wondering what version the Information.Schema schema was introduced, so that I can decide how to query the metadata for user defined tables.

Thank you!

Any recommendations - From COS, From .net?

Hi all,

any news about support of the IRIS platform in the DBeaver? I only found this https://github.com/dbeaver/dbeaver/issues/6289 Github issue. They are waiting for a new version of the JDBC driver.

Thanks for the answer

Hello,

I'm hoping to get some feedback on the OAuth process flow for Payer-to-Payer authorization. It doesn't seem that "Authorization Code Flow" is needed as there will not be a need for a login. I am leaning towards recommending "Client Credentials Flow", but wanted to get some community feedback before making a decision. I prefer to follow what the standard will be if possible. What would you recommend? Thank you in advance for your input.

Hi guys,

A client want to programmatically list all namespaces and whether they are interoperability or not. Do we have apis or sql to do that? Thanks.

I've tried several methods of %SYS.Namespace but did not find it yet. Also when I use sql to select from %SYS.Namespace through jdbc, it always return an empty result set.

On an IRIS system, we expect the default string collation for SQL columns to be SQLUPPER. This means WHERE conditions will be case-insensitive. However, when I make a WHERE condition on a SQL procedure that returns a string, it's case sensitive.For example:

Convert epoch time to standard date in (dd mon yyyy) or (yyyy-mm-dd)