検索

问题
· 三月 27

count(*) from a sql dynamic query

#Caché #InterSystems IRIS for Health #Ensemble #InterSystems IRIS

 I have dynamic sql select query ,

Set resultset = ##class(%ResultSet).%New()

 set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"

 SET SC = resultset.Prepare(sql)

 SET SC = resultset.Execute(sql)

How can I print/view the count ?

8 Comments
讨论 (8)3
登录或注册以继续
问题
· 三月 27

HL7 CR/LF to create a blank space between segment -- resolved

#HL7 #Health Connect #InterSystems IRIS for Health

My attempts to add CR/LF between segments

// Add CR/LF after "Total Cost:" if multiple "Item Number:" exist
            //$$$LOGINFO(tItemNumberCount_" "_tTotalCostSegment_"----cr/lf")
            If (tItemNumberCount > 1) && (tTotalCostSegment > 0) {
                Set tOBXSegment = pOutput.GetSegmentAt("ORCgrp(1).OBRuniongrp.OBXgrp("_tTotalCostSegment_").OBX", .tStatus)
                //$$$LOGINFO(tOBXSegment_"----"_"tOBXSegment from cr/lf")
                Set tOBXText = tOBXSegment.GetValueAt(5) //_"||||||\X0D\\X0A\" // Append escaped CR/LF representation
                //Do tOBXSegment.SetValueAt(tOBXText_"|\X0D\\X0A\|", 5)
                //Do tOBXSegment.SetValueAt(tOBXText_"$c(13)_$c(10)", 5)
                //Do tOBXSegment.SetValueAt("$c(13)_$c(10)", 11.1)
                Do tOBXSegment.SetValueAt("\X0D\\X0A\", 11.1)
                //$$$LOGINFO(tOBXText_" cr/lf OBX mod")
                //Set tOBXTextCRLF = tOBXSegment.GetValueAt(11)
                //Do tOBXSegment.SetValueAt(tOBXTextCRLF, 11)
                
            }

 

 

2 Comments
讨论 (2)1
登录或注册以继续
公告
· 三月 27

[Video] Developer Ecosystem at UKI Data Summit

#Summit

Hi Community,

We're pleased to present you with the latest and, obviously, the hottest presentation of the first day of the UK&I Data Summit in Birmingham! It is dedicated to the Developer Ecosystem and done by @Dean Andrews, Head of the Developer Relations at InterSystems:

⏯  Developer Ecosystem: Latest News @ UK&I Data Summit

Watch this presentation to explore the latest resources and tools available in the InterSystems Developer Ecosystem. Discover how to leverage Developer Community AI, hands-on tutorials, new templates and packages, gamification, and more to enhance your development experience.

Enjoy the new video on InterSystems Developers YouTube and subscribe for more! 👍

讨论 (0)1
登录或注册以继续
公告
· 三月 27

[Video] Using Server-Side Source Control in Health Connect Cloud

#云 #源代码控制 #视频 #学习门户

Hi, Community!

How can you improve your team's work on interface components? See how source control can help:

Using Server-Side Source Control in Health Connect Cloud

In this video, you will see the workflow of server-side source control in HealthShare® Health Connect Cloud™ as two colleagues use source control to work on interface components for their organization’s integration.

Learn more in Building Health Connect Cloud Interfaces with Source Control (online course, 1h 15m).

讨论 (0)1
登录或注册以继续
Job
· 三月 27

Buscamos Senior Developer Intersystems - Proyecto en sector Life Sciences - larga duración

#Caché #Global Masters #InterSystems IRIS #工作机会

Buenas tardes,

Estamos abriendo posiciones para desarrolladores Intersystems para proyectos en sector Life Sciences. Escenario de transformación, donde ya tenemos otros equipos scrum y planteamiento a largo plazo y marcos de desarrollo de producto incremental.

Buscamos reforzar esta capacidad y abrir un abanico de proyectos de transformación para desarrolladores Intersystems que busquen nuevos retos futuros:

https://www.linkedin.com/jobs/view/4190849428/?capColoOverride=true

Estamos ansiosos de conoceros,
 

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