发布新帖

查找

公告
· 四月 5, 2024

[Video] Using Vector Search for Generative AI

#Generative AI (GenAI) #Vector Search #视频 #InterSystems IRIS

Hey Community,

Watch the latest video on InterSystems Developers YouTube:

⏯ Using Vector Search for Generative AI

Get an introduction to Retrieval Augmented Generation, or RAG, and see how InterSystems fits into the RAG workflow. Then, take a deeper look at InterSystems IRIS's vector search capability, which enables efficient semantic searching for use in the RAG setup.

Keep an eye out for the upcoming videos! 👍

讨论 (0)1
登录或注册以继续
问题
· 四月 5, 2024

Is there a way to Isolation Mode on global interactions?

#数据库事务处理 #Globals #Caché #Ensemble

Hi all,

I have a situation where I am writing to global from different processes - let's call it an Event Queue.
There is then a different process that uses $order to read through the data - the PubSub processing BP.

Sometimes the writing of this global will form part of a transaction that also insert data into other tables, using tstart and tcommit.
If there is some issue, it will roll back, and the entry written to the global will also roll back.

The problem is that the process that reads from this global, picks it up, regardless of the IsolationMode I set for the process, as IsolationMode is part of SQL.
I have considered locking, but logically the lock needs to release before the commit is done, which means this can still happen.

Is there a way or functionality I am not aware of, that can assist in not reading uncommitted global entries?

Thanks.

6 Comments
讨论 (6)1
登录或注册以继续
问题
· 四月 4, 2024

VSCode connect to non-existing namespace - unable to select other namespace

#命名空间 #VSCode

My VSCode folder was set up to connect to a namespace, but the namespace was deleted. I tried changing the namespace from the menu but it fails (could not retrieve list of namespaces), but I do get the following error message:

This server does not have specified namespace 'FEAT-1-MY-FIRST-ISSUE'.

You must select one of the following: %SYS, CICD-DEMO, CUSTOMER, HSCUSTOM, HSLIB, HSSYS, PERSONAL, PHONEBOOK, USER.

Check your server details in Settings (gitlab-cicd-dev[FEAT-1-MY-FIRST-ISSUE]).

I solved this by recreating the namespace on the server, after that I could change the namespace again in VSCode. (and delete the temporary namespace)

Is this a known issue/what is the easiest way to deal with this? In this specific use case we are going to create temporary namespaces for working on features, and delete them when they are merged into the main development branch, so this might happen more often.

VSCode is up-to-date 

9 Comments
讨论 (9)7
登录或注册以继续
问题
· 四月 4, 2024

How can I obtain the record of the last 2 hours of a table?

#SQL #InterSystems IRIS for Health

I need to obtain the records of the last  2 hours with format (HH:MM:SS), it only leaves me specifying the exact time

6 Comments
讨论 (6)3
登录或注册以继续
问题
· 四月 4, 2024

How can I convert two timestamps into time format (HH:MM:SS)?

#Java #SQL #InterSystems IRIS

For example, I have two timestamp values ('2024-04-01 10:00:00', '2024-04-01 11:30:30'). I would like to find the difference between these two timestamps, and I need the result in hours:minutes:seconds (hh:mm:ss) format.

Expected Output: 01:30:30


Note: I need an SQL query command. I should not use ClassMethod, Function, or Stored Procedure.


Could anyone please provide me with an SQL query for my question?

4 Comments
讨论 (4)1
登录或注册以继续