Posts by Henry Pereira on InterSystems Developer Community

Question

Hi all!

I want to create an %Embedding.Config to use with an %Embedding property. I followed the documentation for %Embedding.OpenAI, and it works fine after setting sslConfig, modelName, and apiKey.

However, I need to use AzureOpenAI. While the embedding process is similar to OpenAI's, Azure requires additional connection parameters, like an endpoint.
My question is: is it possible to configure these extra parameters with %Embedding.Config, and if so, how?

#Vector Search #InterSystems IRIS

0 2

0 45

Question

Henry Pereira · Oct 15, 2022

Metaprogramming in ObjectScript

With $Property is possible to dynamically get and set values on property of an instanced class and with $ClassMethod is possible to invoke methods from a class.
I would like to know: Is there an elegant way to do Write and Set dynamically on variables without using Xecute?

#ObjectScript #Caché #InterSystems IRIS

0 6

0 303

Question

Henry Pereira · Mar 12, 2021

Hierarchical Queries

Hi community,

I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow:

#Caché

0 4

0 286

Question

Henry Pereira · May 20, 2020

How to select a random row from a table?

Hi community,

I need to write an SQL query to fetch a random record from a table, that table has millions of data.

In postgresql, for example, there is a RANDOM() function to do something like that:

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

Is it possible to do something like that in Caché?

Thanks in advance

#Caché #InterSystems IRIS

0 8

0 862