Using VECTOR_COSINE() in SQL query to perform a text similarity search on existing embeddings in a %VECTOR column.

Code is below.

Commented out sql query returns this error: SQLCODE: -29  Field 'NEW_EMBEDDING_STR' not found in the applicable tables^ SELECT TOP ? maxID , activity , outcome FROMMain .AITest ORDER BY VECTOR_COSINE ( new_embedding_str ,

Sql query as written returns ERROR #5002: ObjectScript error: <PYTHON EXCEPTION> *<class 'OSError'>: isc_stdout_write: PyArg_ParseTuple failed!

I was reading this article and I started to get lost in the sauce since I'm new to CCDA. I was wondering if you all had some recommendations for digging into some of the basics needed in order to assimilate this? For instance where it says "Some of the built-in logic for handling CCDAs is controlled by the IHE header....There is little visibility into this process in the product documentation." Are there examples or places where you have been able to find some insight into this sort of thing or maybe this is something that comes with experience?

Hello everyone,

I am working with InterSystems IRIS and seeking guidance on how to perform specific tasks related to the FHIR SQL Builder using commands or code, rather than the graphical user interface (GUI). The specific tasks I am trying to accomplish are:

You may have heard about our mg-dbx-napi interface for IRIS which provides insanely fast access from Node.js.  If you've been following recent developments in the server-side JavaScript world, you'll be excited to know that mg-dbx-napi also works with Bun.js, the latter proving to be significantly faster than Node.js for many/most purposes.

Of course, if you're a Node.js user, you'll probably wonder how mg-dbx-napi compares with the Native API for Node.js that is included with IRIS.

With all that in mind, we've created a Github repository: mg-showcase

I have files of mixed types; e.g. a.pdf, b.pdf, c.txt.

I zipped them with gzip to make a.pdf.gz, b.pdf.gz, c.txt.gz.

I concatenated them into one file, all.gz.

I renamed all.gz to all.zip.

I emailed it but cannot extract in windows browser.

Hi Community!

Welcome to the 12th edition of the InterSystems Ideas news! Here's what you can expect from it:

​​​​✓ Call for ideas about InterSystems IRIS Cloud SQL

✓ Get inspired by ideas from the InterSystems Ideas portal

✓ Recently implemented ideas

I have a week learning object script after 5 yrs as full stack developer, object script seems to be one of lauguage that has own syntax and new methods that I had to give my self more time to explore a lot. any suggestion about what is the best thing you you did figure out about IRIS to share ?

Hi Community,

Here are the bonuses for the articles in the Technical Article Contest: InterSystems IRIS Tutorials:

Hi everyone.

This is a full example how to use a %ScrollableResultSet for results pagination using %DynamicQuery:SQL and build a JSON response including page details.

Feel free to use, share, comment or improve it.

Kind Regards

Hi Community,

Dive into the new video on InterSystems Developers YouTube:

⏯ Near Real-Time Analytics with InterSystems IRIS & Debezium Change Data Capture @ Global Summit 2023

Using InterSystems Embedded Analytics – Virtual  April 15-19, 2024

Hi Community!
As an AI language model, ChatGPT is capable of performing a variety of tasks like language translation, writing songs, answering research questions, and even generating computer code. With its impressive abilities, ChatGPT has quickly become a popular tool for various applications, from chatbots to content creation.
But despite its advanced capabilities, ChatGPT is not able to access your personal data. So we need to build a custom ChatGPT AI by using LangChain Framework:
Below are the steps to build a custom ChatGPT:

• Step 1: Load the document 

• Step 2: Splitting the document into chunks

• Step 3: Use Embedding against Chunks Data and convert to vectors

• Step 4: Save data to the Vector database

• Step 5: Take data (question) from the user and get the embedding

• Step 6: Connect to VectorDB and do a semantic search

• Step 7: Retrieve relevant responses based on user queries and send them to LLM(ChatGPT)

• Step 8: Get an answer from LLM and send it back to the user

  For more details, please Read this article

InterSystems introduced this feature many years ago and a time when using Public Key Infrastructure was not yet widely used. Creating materials for use with Public Key Infrastructure is now widely available, and InterSystems is observing a decline in using the InterSystems PKI. In addition, investments would be required to securely use it. The IRIS PKI documentation stated for years:

The InterSystems PKI is for testing purposes only. Do not use it in a production setting.

As of today March 26, 2024, the InterSystems PKI is now deprecated.

The product documentation has been updated and now states:

Is there a way to compare the content of two variables/ lists and if they share a common element/ value return 1?

Example the two below both have "Yellow":

Set y = "Red, Green, Orange, Yellow"

Set x = "Purple, Black, Yellow, Pink"

The lists I am working with have over 30 elements/values that vary so it is difficult to hard code it to say look for "Yellow". 

Hello,

First of all thanks for your time, and thanks for your help.

We have the following doubt: how HTTP status is being replied from a SOAP Service to the Outbund System?

Where in HealtShare 2020's classes is being replied an HTTP/200 OK or an HTTP/500 or any SOAP HTTP status code?

We ask this because some outbound systems do need to have an HTTP 200 to being able to process our SOAP responses.

We have been examining the following classes:

EnsLib.SOAP.Service

%SOAP.WebService

%SOAP.WebBase

We have also read:

I am exploring a way to make IRIS an immutable system where the production/operation IRIS is never changed. Changes are only made in Development, and then the "version" is copied to production/operation and stated.

For this to work, I will need data (objects) on a file share and the IRIS system on different systems. When the "new" version spins up, it will use the latest data.

I do not know if I can or how to separate "object data" from classes and code. 

Hi Guys,

I’ve the below service that receives a request from a client requiring a pdf file to be sent back for printing.

Basically in this method I’m receiving a message “Yes” and if so I need to determine the length and put it in the Content-Length: or File-Length: fields and then append the byte block to the end of the 200 OK reply so they can print it

Any idea on how to do that?

Hi Community,

We have some exciting news! It's time for the next InterSystems technical article writing competition!

✍️ Technical Article Contest: InterSystems IRIS Tutorials ✍️

Write an article that can be considered a tutorial for InterSystems IRIS  programmers of any level: beginner / middle / senior from February 19th to March 17th. We've extended the submission deadline till the 24th of March!

🎁 Prizes for everyone: A special prize for each author participating in the competition!

In this article, we will cover below topics:

• What is Kubernetes?
• Main Kubernetes (K8s) Components

What is Kubernetes?

Kubernetes is an open-source container orchestration framework developed by Google. In essence, it controls container speed and helps you manage applications consisting of multiple containers. Additionally, it allows you to operate them in different environments, e.g., physical machines, virtual machines, Cloud environments, or even hybrid deployment environments.

What problems does it solve?

Are you using HealthShare® Health Connect? You should know that starting with version 2024.1, a private web server (PWS) will no longer be included in installations.

It is recommended that you migrate to an external production-grade web server to ensure security. Benefits include:

• Only one web server is needed for all your instances.
• You can take charge of security by keeping your web server up to date—no need to wait for the next InterSystems release.

See how to migrate to an external web server(video series, 10m).

Learn more in this FAQ post in the Developer Community.

In the settings of the IRIS web application configuration page there is an option "Redirect empty path" which allows a user to access REST endpoint URL without trailing slash, eg. /csp/api/rest instead of /csp/api/rest/. How could I change this option declaratively in my ZPM manifest?

Hello everyone,

I have a Cache class with just 2 fields

Class JASON.BikeDB Extends (%Persistent, %Populate)
Property Make As %String [ Required ];/// Model of the Motorcycle
Property Model As %String [ Required ];

I also have another class with several ClassMethods, just showing you 1 here

Class JASON.DataBase Extends %Persistent
{ClassMethod SaveNew(Make As %String, Model As %String)
{
Set obj=##class(JASON.BikeDB).%New()
Set obj.Make=Make
Set obj.Model=Model
Set sve=obj.%Save()
}

I have a simple C# windows app with 2 text boxes "MAKE" and "MODEL"

Hello everyone, I would like to not rely on %SYS.Journal.Record class is used to implement the function of reading and parsing logs. I want to use Python to read and parse journal log files, and implement %SYS.Journal.Record class functionality.

InterSystems IRIS Document Database (DocDB) offers a flexible and dynamic approach to managing database data. DocDB embraces the power of JSON (JavaScript Object Notation), providing a schema-less environment for storing and retrieving data.

It is a powerful tool, enables developers to bypass a ton of boiler plate code in interaction with existing applications, serialization, pagination and integration. the seamless flow of DocDB with Interoperability Rest services and operations, gives a big leap in API production and management.

for full DocDB documentation Here. in the context of this article i will showcase a use case in which DocDB will make a perfect fit.

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

⏯ How to Migrate off the Private Web Server - Windows

Hi,

Is there a way to send certain message based of source into top of the queue of business operation.. so that that message will processed right away.

In cache studio there are features, dialog boxes, that help map data from a global to class properties.
I have used %CacheSQLStorage quit a bit, or have in the past, to map globals to classes.

I haven't been able to find a similar feature in VisualStudio.
Do I need to upgrade to IRIS to be able to use VisualStudio to map global properties to classes?

Thanks for your time,
Richard

Hello everyone,
I searched but didn't find anything. Could you tell me if the IRIS database has any class that natively works with blockchains?
Best Regards,
Flávio

Hey Community!

We know that you love to brag about your achievements! To make it even easier for you, we've implemented the data exchange with Credly: all InterSystems and Developer Community badges and certifications you have on Credly will be visible in your DC profile after your Open Exchange apps and before your Global Masters badges.

How to query BLOB type data in MYSQL database through JDBC or ODBC