Pesquisar

Pergunta
· Mar. 27

count(*) from a sql dynamic query

 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
Discussão (8)3
Entre ou crie uma conta para continuar
Pergunta
· Mar. 27

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

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
Discussão (2)1
Entre ou crie uma conta para continuar
Anúncio
· Mar. 27

[Video] Developer Ecosystem at UKI Data 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! 👍

Discussão (0)1
Entre ou crie uma conta para continuar
Anúncio
· Mar. 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).

Discussão (0)1
Entre ou crie uma conta para continuar
Job
· Mar. 27

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

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,
 

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