検索

Pergunta
· Set. 11, 2024

SQL query to get multiple records

#Ensemble

I have an SQL table as below (columns - ID and Value)

I will get an ID number (first column) as an input from FTP inbound , and after that I have to query table taking ID as an input to get all the values for the ID 

as -

if ID = 11 ; QRY output = aaa,bbb

if ID = 22 ; QRY output =  xxx,yyy,zzz

 

can someone help me with query 

 

ID    Value
----------
11    aaa
22    xxx
22    yyy
11    bbb
22    zzz
-----------
 

2 Comments
Discussão (2)1
Entre ou crie uma conta para continuar
Pergunta
· Set. 11, 2024

Determine Job/Process State

#Pergunta principal #InterSystems IRIS

Hi, I'm working on a large extraction from a database and need to parallelize the processes during the extraction.

Here's what happens:

  1. The user starts the extraction from.
  2. Several jobs are started using the Job <Method> instruction.

At the end, the user expects to find a document containing the results of all the extractions. What I'd like to do is start a new job that checks whether the previously started jobs have finished or are still working and consequently produce the document.

After starting each job, using $ZCHILD instruction I can get the ID of the last started job. I might create a list containing all these IDs, pass it to a method that checks if these jobs are still active and eventually produce the final result. The problem is that I can't figure out how to determine the status of a job given its Job ID.

I may use the retrieved ID to define a Job object using the command:

SET JobObj = ##class(%SYS.ProcessQuery).%OpenId($ZCHILD)

But after that, I can't figure out how to derive the job's status. There is a State property, but I can't understand which value indicates that the job has finished.

Thank you in advance if you can help me!

8 Comments
Discussão (8)4
Entre ou crie uma conta para continuar
Artigo
· Set. 11, 2024 4min de leitura
Open Exchange

Construyendo un frontend usando solo Python

#Concurso #Python #InterSystems IRIS

El desarrollo frontend puede ser una tarea desalentadora, incluso una pesadilla, para los desarrolladores centrados en el backend. Al principio de mi carrera, la línea entre frontend y backend era difusa, y se esperaba que todos manejaran ambos. El CSS, en particular, siempre fue una lucha constante; sentía que era una misión imposible.

Discussão (0)1
Entre ou crie uma conta para continuar
Anúncio
· Set. 11, 2024

VS Code release August 2024 (version 1.93)

#Ambiente de Desenvolvimento #George James Software #Idiomas #ObjectScript #Lançamento #Studio #VSCode #Outro

 

Visual Studio Code releases new updates every month with new features and bug fixes, and the August 2024 release is now available. 

Version 1.93 includes: 

 

The release also includes contributions from our very own @John Murray through pull requests that address open issues. 

Find out more about these features in the release notes here > https://code.visualstudio.com/updates/v1_93

For those with VS Code, your environment should auto-update. You can manually check for updates by running Help > Check for Updates on Linux and Windows or running Code > Check for Updates on macOS.

If you're thinking about migrating from Studio to VS Code but need some help, take a look at the training courses George James Software offers > https://georgejames.com/migration-from-studio/

Discussão (0)2
Entre ou crie uma conta para continuar
Pergunta
· Set. 11, 2024

Hi, Are there some REST API to get the open exchange apps list and app details?

#Open Exchange

Hi, Are there some REST API to get the open exchange apps list and app details?

2 Comments
Discussão (2)2
Entre ou crie uma conta para continuar