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!

0 10
0 232

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".

0 12
0 304

Hey Developers,

Watch the latest video on InterSystems Developers YouTube:

How to Migrate off the Private Web Server - Windows

https://www.youtube.com/embed/NGGt3DE2OD8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 1
0 145

Hi Developers,

Tap to watch the brand new video on InterSystems Developers YouTube:

Health Data De-Identifier @ Global Summit 2023

https://www.youtube.com/embed/KQpDKArvo5A
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 249

I am fairly new to using Docker, and instead of trying to get IIS, a Web Gateway, and Docker desktop working within my Windows environment, I thought I would try running it in a WSL2 Ubuntu environment since this is similar to how use it on my server. I have installed Apache and the Web Gateway on my WSL2 Ubuntu.

0 1
0 209

I have created a custom Business Process setting called X509CredentialAlias in which I load the name of the credential alias to use for some background processes. I have looked through EnsPortal.Component but do not see an option for selecting X509 certs stored within IRIS. How might I adjust this setting to query all X509 certs saved within IRIS and offer a drop-down selection to the user within the business process? Similar to the EnsPortal.Component.sslConfigSelector.

0 7
0 197

I have a fixed width complex recordmap that is an older version of a file format. I am trying to retool it to fit the latest version. The old recordmap has almost 500 entries on it and the new version has a few more fields added along with changes to some field lengths. Adding a new field adds it at the end of the recordmap and moving it from field 490 to field 139 is a painful process. Is there an easier way of doing this?

1 1
0 140

Given the number of new features in this release, InterSystems has decided to add this fifth preview as part of the 2024.1 developer preview program. This extended developer preview release only includes InterSystems IRIS® for HealthTM, and HealthShare® Health Connect.

❗This announcement does not apply for InterSystems IRIS®

1 1
0 128
Article
· Mar 14, 2024 1m read
What can you do with record maps?

InterSystems FAQ rubric

Record maps are used to efficiently map files containing delimited records or fixed-width records to message classes used by the interoperability function, and to map files from interoperability function message classes to text files.

Record map mapping definitions can be created using the Management Portal, and we also provide a CSV record wizard that allows you to define while reading a CSV file.

3 0
1 371

We are investigating option of populating .pdf Custom Properties Name-Value pairs with episode/billing information from the TrakCare database, using Logi Reports. Resulting .pdf would be stored in a designated network folder. Would welcome suggestions on feasibility / technique to achieve / code to achieve (or alternative approach).

Intent is for further (watcher) process to detect new .pdf file in network folder and determine actions and/or process flow based on Name-Value pair information in pdf's Custom Properties.

0 2
0 161

Hey Community,

Watch the new video on InterSystems Developers YouTube:

Clinical Research Data Pipeline Using FHIR & OMOP @ Global Summit 2023

https://www.youtube.com/embed/S1vuMAiI8_k
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 299
Article
· Dec 1, 2022 1m read
My First FHIR app

I participated in InterSystems Women’s Health FHIR contest, because I loved the challenge to learn a new-to-me technology. I wanted to develop an app that receives data from a mobile device like my Fitbit or a Smart Watch. I did not get access to such data except when I downloaded a spreadsheet (CSV file) showing my daily steps and sleep data. I saw in iris-fhir-template it imported some patient data to a FHIR server.

4 1
0 358

Hi,

I am having an issue when I am publishing data to FHIR which is hosting in AWS. I am sending the data to the Cloud FHIR url but getting the below error.

Any idea how to resolve this issue? Any example to cretae FHIR repository using Object script?

:<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>404 Not Found</title> </head><body> <h1>Not Found</h1> <p>The requested URL was not found on this server.</p> </body></html>

0 2
0 197