Nova postagem

Pesquisar

Anúncio
· Abr. 29

Get READY, get set, get certified!

Are you planning to attend InterSystems READY 2025 (June 22–25), this year's global summit?

Get Certified at InterSystems READY 2025, June 23-25, Orlando, FL

🏁 If so, take advantage of a free certification exam attempt! 

Prove your skills in InterSystems technology and earn our highest-level credential in one of eight areas.

Exams include:

  • InterSystems HL7® Interface Specialist
  • InterSystems IRIS SQL Specialist
  • HealthShare Unified Care Record Technical Specialist

👩‍💻If you hold the InterSystems SQL Specialist certification, you can also try the new InterSystems IRIS SQL Professional exam (in beta)! 

See the full list of available exams. Start preparing now, and reserve your spot early!

👉 Get certified at READY 2025!

5 Comments
Discussão (5)3
Entre ou crie uma conta para continuar
Pergunta
· Abr. 29

WorkMgr execution issues

Hello Community,

I have a queue that I need to traverse and perform operations on. To distribute the workload across multiple processes, I used a Work Queue Manager do process and I'm not expecting any status from it So, I skipped Sync / WaitForComplete in my implementation

When I execute the below code. Lot of queues are not processed properly. If I add a 0.1-second delay, it works as expected. Is there a minimum time required for a process to start after it's added to the Queue

ClassMethod CleanUpQWrkMgr()
{
    Set QueueId=""
    Set workMgr = ##class(%SYSTEM.WorkMgr).%New()
    If workMgr="" quit
    for {
        Set QueueId = $O(^Q(QueueId),1,data),event="" q:QueueId=""
        Do workMgr.Queue("..Cleanup",QueueId)
        //h .1	
    }
    //Set st= workMgr.WaitForComplete()
}

ClassMethod Cleanup(QueueId As %Integer)
{
    Set event=""
    For {
            Set event = $Order(^Q(QueueId,event)),rev="" Q:event=""
            For {
                Set rev = $Order(^Q(QueueId,event,rev)) Q:rev=""
                If '$Data(^DQ(rev,"e",event))
                Do $I(CNT)
            }
    }
    Set ^test("CNT",QueueId)=CNT
    Quit 1
}

Thanks!

4 Comments
Discussão (4)2
Entre ou crie uma conta para continuar
Pergunta
· Abr. 29

SQLCODE 25 - Input Encountered after end of query

Hi Guys,

I'm getting the below error when trying to train my Model

This is the table I created my model from

 

Thanks

1 Comment
Discussão (1)2
Entre ou crie uma conta para continuar
Pergunta
· Abr. 28

Code Tables vs Cache SQL Tables in HealthShare Provider Directory

I have a general question about HealthShare Provider Directory using Code Tables on disk vs Cache SQL Tables. Why is Provider Directory not using the Cache SQL Tables within the IRIS platform?

Discussão (0)1
Entre ou crie uma conta para continuar
Pergunta
· Abr. 28

Struggling with a SQL SELECT that is returning multiple searchable rows

I am struggling with returning a SQL Query Result that may have multiple rows that can be searched.

 set query = "SELECT Facility FROM FROM osuwmc_EnterpriseDirDB.RelationshipMedCtrID WHERE OSUmedcenterID = ?"
 SET rset = ##class(%SQL.Statement).%New()
 SET qStatus = rset.%Prepare(query)
 SET rset = rset.%Execute($Get(ID))
 do rset.%Display()

I need to take the values that are returned and say search them for a single value. How would I go about returning the EnsLib.SQL.Snapshot into a Array or List for it to be searchable.

Can this be done internally within the DTL, so I don't have to go build a Business Process and Outbound SQL Adapter Operation?
 
 Thanks

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