Is "time" a reserved word in the %CONTAINS function?

When I run the following SQL query, I get 0 matching results

SELECT ID, text
FROM Test.Sentence
WHERE text %CONTAINS('time') OR text %CONTAINS('time ') OR text %CONTAINS(' time')

However, when I run a query where the search string contains words other than "time" alone, it returns the expected matching results

SELECT ID, text
FROM Test.Sentence
WHERE text %CONTAINS('providers time money') OR text %CONTAINS('providers time') OR text %CONTAINS('time money')

It also works if I try to search for "tim" or "ime"

SELECT ID, text 
FROM Test.Sentence

Hello, I am trying to write a script that will output a .log file. When I get PowerShell to parse the file with Get-Content, I find that there are extra spaces in the parsing. How can I edit my Intersystems script to output a logfile encoded differently? I think its outputting in unicode by default.

In this article, we will explore the use of parameters, formulas and labels in Logi Report Designer (formerly Logi JReport Designer). What are they for and how to create them?

Using the basic functionality of InterSystems Reports Designer, parameters, formulas and labels, you can significantly improve the detail and information content of the generated report. In addition, these tools allow you to automate some of the processes, which greatly speeds up and facilitates the creation of reports.

Let's analyze each tool separately now.

Parameters are individually configurable variables.

REST API for Security Package

Hi community,

In this article, we will learn how to set up a REST API for the IRIS Security Package. We will be able to create users, roles, add applications, etc... by simple HTTP requests as well as generate a client application in ObjectScript.

Requirements

We need :

1. An IRIS instance (installation kit or docker).
2. ObjectScript package manager (ZPM).
3. (Optional) A second IRIS instance to generate an ObjectScript client.

We will use a set of existing applications and libraries on OpenExchange.

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in June 2023:

Hello!

In a transformation (DTL) I create an XML and pass it to an EnsLib.EDI.XML.Operation.FileOperation.

The receiver does not accept an empty tag (eg <Analysis/>) that is created automatically
if the tag has no values ​​in underlying tags. I have tried with action='remove' in transformation
and other things but it only clears the content.

I need to remove the tag completely. Appreciate if anyone has a tip?

Sincerely, Michael Lundberg

Hi Developers!

Here is the bonus results for the applications in InterSystems Grand Prix Programming Contest 2023:

As said in the previous article about the iris-fhir-generative-ai experiment, the project logs all events for analysis. Here we are going to discuss two types of analysis covered by analytics embedded in the project:

• Users prompts
• Execution errors

In order to extract useful data to apply analytics, we used the iknowpy library - an opensource library for Natural Language Processing based in the iKnow for IRIS Data Platform. It makes possible identifies entities (phrases) and their semantic context in natural language text in several languages.

Here it's used to extract concepts from data of

Hi Community,

It's voting time! Cast your votes for the best applications in our InterSystems Grand Prix Contest 2023:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Previous post - Using AI to Simplify Clinical Documents Storage, Retrieval and Search

This post explores the potential of OpenAI's advanced language models to revolutionize healthcare through AI-powered transcription and summarization. We will delve into the process of leveraging OpenAI's cutting-edge APIs to convert audio recordings into written transcripts and employ natural language processing algorithms to extract crucial insights for generating concise summaries.

While existing solutions like Amazon Medical Transcribe and MedVoice offer similar capabilities, the focus of this post will be

InterSystems IRIS offers various ways how to profile your code, in most cases it produces enough information to find the places where the most time is spent or where the most global sets. But sometimes it's difficult to understand the execution flow and how it ended at that point. 

To solve this, I've decided to implement a way to build a report in a way, so, it's possible to dive by stack down

A simple data analysis example created in IntegratedML and Dashboard

Based on InterSystems' Integrated ML technology and Dashboard, automatically generate relevant predictions and BI pages based on uploaded CSV files. The front and back ends are completed in Vue and Iris, allowing users to generate their desired data prediction and analysis pages with simple operations and make decisions based on them.

# ZPM installation

zpm:USER>install IntegratedMLandDashboardSample

# Process Deployment 

Use or create a new namespace

Import code into the corresponding namespace

Execute in Terminal:

Do

Hi folks!

How can I change the production setting programmatically?

I have a production that is a solution that uses some api-keys, which are the parameters of Business Operations but of course cannot be hard-coded into the source code.

E.g. here is the example of such a production that runs a connection of Telegram and ChatGPT.

And it can be installed as:

zpm "install telegram-gpt"

But now one needs to setup the key manually before using the production, having the following setting:

I'd like to set up it programmatically so one could install it as:

zpm "install telegram-gpt -D Token=sometoken"

How can I make it work?

Hi folks, does anyone got the .sef file for the D93A EDIFACT (INVOIC specifically)?

Setting it up to an old customer but I lost my copy of it as I used it a long time ago.

Would be so helpful if anyone have it.

Thanks

Hi Community,
In this article I will demonstrate the usage of InterSystems Embedded Python, We will cover below topics:

• 1-Embedded Python Overview
• 2-Usage of Embedded Python
  • 2.1- Using a Python Library from ObjectScript
  • 2.2- Calling the InterSystems APIs from Python
  • 2.3- Using ObjectScript and Python together
• 3-Using python Built-in Functions
• 4-Python Modules/Libraries 
• 5-Embedded Python Use Cases
  • 5.1- Printing PDF by using python Reportlab Library
  • 5.2- Generating QR code by using Python Qrcode Library
  • 5.3- Get GEO location by using Python Folium Library
  • 5.4-

I want to fetch both column name and value from resultset of sql query . I am using ExecDirect() method for SQL execution. 

please help me out.

I had attempted to create a REST Operation before but did not have success. As I am going through the Tutorials and Documentation everything references REST services, but I have a case where I want to create a REST Operation that makes Epic API calls against Interconnect. I have done SOAP operations before and we currently have one in our Production Namespace, but from what I understand SOAP has the wsdl which defines al the structures and etc, where REST does not. 

So how does one go about creating a REST Operation if Learning Tutorials and Documentation always talks about REST services?

I am playing around with trying to make an Epic REST API call from an operation, and from what I understood because the request has to be sent as POST, I need to send the request as JSON. However when I try taking the request and running %ToJSON against it for the payload to be created I am getting an error...

ERROR <Ens>ErrException: <METHOD NOT SUPPORTED>zgetPatientLocationByVisit+6^User.SCOTT.REST.APIOperation.1 *%ToJSON,osuwmc.Epic.Access.Request.GetPatientLocationByVisit2JsonRequest -- logged as '-' number - @' set tPayload = tRequest.%ToJSON()'

Reading the documentation I tried switching

The continuing convergence of AI technologies and healthcare systems has brought forward many compelling advancements. Let's set the scene. If you have interacted with dynamic models like ChatGPT, you might have, like many of us, begun to envision its application using your unique datasets. Suppose in the healthcare sector you wish to link this technology with Electronic Health Records (EHR) or Electronic Medical Records (EMR), or perhaps you aim for heightened interoperability using FHIR's resources.  It all boils down to how we transfer/receive contextual-data to/from LLMs available in

Remote Job Oportunity - IRIS For Health

Job description

Hi Developers,

This June, you've posted the whooping 105 new questions on the Developer Community: 

Hi all,

I am using ExecDirect() method to get SQL resultset of type %SQL.StatementResult. 

now I am fetch a column something like this rs.%Get("Amount") but if amount column is empty then it is return me empty string. If There is any way to set something like this in IRIS rs.%Get("Amount",0.00) if that is possible.

Hello Everyone,

The Certification Team of InterSystems Learning Services is in the process of developing two exams focused on using SQL in InterSystems IRIS and we need input from our InterSystems IRIS SQL community. Your input will be used to evaluate and establish the contents of the exam.

How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance as well as other factors.

How much effort is involved? It takes about 20-30 minutes to fill out each survey.

I need to create a routing rule where I've got to check for the value of "-" in field 5 of a repeating RQD segment, if the "-" is found in any of the RQD-5 I want to send it to a transform, if the rule doesn't find a "-" in any of the RQD-5 I want to send it to another transform.

Unfortunately we are running an older version of Ensemble and the foreach function is not available. 

The other thing to add is the transforms are writing the output to a flat file so my business process is using the EnsLib.MsgRouter.RoutingEngine class.

Sample message:

ORC|NW|5139|||||||20230620161500|78068^TEST^TOM^^||4

Hi I am trying to run a debugger in VS Code.  I have the settings.json file and the launch.json file.  I am trying to debug code using the attach to a process method, however when I run the debugger I get the following error. 

Launch.json code 

{

    // Use IntelliSense to learn about possible attributes.

    // Hover to view descriptions of existing attributes.

    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387

    "version": "0.2.0",

    "configurations": [  

        {

            "type": "objectscript",

            "request": "attach",

            "name":

Has anyone tried loading Cache 2017 on Windows 11?

I'm working with my corporate IT department to get a version published that will work on Windows 11 desktops but I have to prove that it can be loaded before they will give me the rights to install it.

It looks like Cache 2018 is supported but we're still supporting a bunch of 2017 installations until we can begin the move to IRIS.

Meanwhile the new laptops are all being issued with Windows 11 and the installers are all blocked by corporate. 

To get past the block I have to submit an exception, but I can't test the install until the exception

Description

With InterSystems IRIS FHIR Server you can build a Strategy to customize the behavior of the server (see documentation for more details).

This repository contains a Python Strategy that can be used as a starting point to build your own Strategy in python.

This demo strategy provides the following features:

• Update the capability statement to remove the Account resource
• Simulate a consent management system to allow or not access to the Observation resource
  • If the User has sufficient rights, the Observation resource is returned
  • Otherwise, the Observation resource is not returned

Hi everyone,

This one had me breaking a sweat 😅

When a SOAP request has a %Stream.GlobalBinary property, it fails to serialize to base64 when stream is larger than ~43MB with 

ERROR #6301: SAX XML Parser Error: <MAXSTRING>xeWrite+7^%occXMLInternal

Unless you enable the following parameters :  

Parameter BASE64LINEBREAKS = 1;Parameter USEPPGHANDLER = 1;

The first one instructs %SOAP.WebBase to insert line breaks in the XML text, and the second one to use globals rather than local array memory during serialization (to avoid <STORE> error, depending on your available $zstorage)

Enabling both in my

How to call multiple SQL gateway connections in BO

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