All time

I'm running a query, joining nine tables together. When I run it with a SELECT COUNT(*) I get about 200,000 rows. When I run the SELECT with the columns I want, I get about 2,700 rows. Is there something inherent with the queries that limits the result set size, or anything I can do to make sure I'm getting back all the results? Rather, than trying to run it about 100 times limiting all previously gotten accounts.

0 2
0 210
InterSystems Developer Community is a community of 25,143 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

iris | [ERROR] Command "iris start IRIS quietly" exited with status 256
iris |
iris |
iris |
iris | *** Recovery started at Thu Aug 15 05:47:48 2024
iris | Current default directory: /usr/irissys/mgr
iris | Log file directory: /usr/irissys/mgr/
iris | WIJ file spec: /usr/irissys/mgr/IRIS.WIJ
iris | Recovering local (/usr/irissys/mgr/IRIS.WIJ) image journal file...
iris | Starting WIJ recovery for '/usr/irissys/mgr/IRIS.WIJ'.
iris | 0 blocks pending in this WIJ.
iris | Exiting with status 3 (Success)

0 2
0 210

ChatIRIS Health Coach, a GPT-4 based agent that leverages the Health Belief Model as a psychological framework to craft empathetic replies. This article elaborates on the backend architecture and its components, focusing on how InterSystems IRIS supports the system's functionality.

Open Exchange app
1 0
1 212

Hi Guys,

I've an fileupload and button that executes Upload() clientmethod to upload files in my database and everything works fine when I run the application in the server where it is located, but if I run it from a client machine the %OnSubmit class method doesn't get invoked when form.submit() get executed so how can I fix this?

0 1
0 211

Hello!

I'm new to the system I'm working on, and I have a part of a statement that needs to grab the previous month.

....and MONTH(TX3.date_of_service)= MONTH(dateadd(mm,-1,GETDATE()))

However, when it hits January, I'm left with month 0.

Does anyone know a workaround to grab December of the previous year, while still functioning normally for the rest of the current year.

Thank you!

0 4
0 208

Introducing a new component driver for Deltanji source control, which enables highly granular management of InterSystems Interoperability Productions with tight integration into the management portal

InterSystems Interoperability Productions are defined in a single monolithic class definition. A production can contain many hundreds or thousands of configuration items. This presents a problem if multiple developers are working on different Business Processes within the same production simultaneously. Simultaneous development is almost inevitable for large productions containing many configuration items. 

Open Exchange app
4 0
0 212

Hi all.

I have setup a HL7 Operation using the HTTP adapter, and I'm getting what seems to me as an unusual response. When sending a sample message to the operation, I am getting a nested ACK. For example:

MSH|^~\&|||xxx|xxx|202209230806||ACK^HTTP^200|00|D|2.1|1
MSA|AA|RWSD7V5iuEC5F6zscDWz|HTTP ACK 'HTTP/1.1 200 OK' : MSH|^~\&|yyy|yyyy|xxx|xxx|20220923080633||ACK^A01|1663916793965||2.3||||||
MSA|CR|RWSD7V5iuEC5F6zscDWz|Error Message Goes Here.

0 1
0 211

Hi, I am new to InterSystems database. I am developing an application to display real time skillset statistic data, including max waiting time per skillset. I have access to the database through ODBC, using InterSystems ODBC driver. But I don't know from which table or view to get real time data of maximum waiting time per skillset. I appreciate any advices.

0 3
0 209
Question
· Jun 24, 2021
Adjust tablepane rows

Hi Guys,

for some reason the height in my tablepane are very big, how can I adjust the height in the rows in a tablepane?

Thanks

0 5
0 207

gj :: locate was the entry from George James Software for the Developer Tools competition back in April 2021. When an ObjectScript error is reported, gj :: locate takes the .int line location and navigates you directly to the line in the source file where the error originated. Over the past few months we've found it a very useful tool when it comes to debugging, especially when used alongside the Serenji debugger in Visual Studio Code.

Our first update, version 1.1.0, now includes support for multi-root workspaces. This enables gj :: locate to be used with every workspace folder. If your VS Code workspace has more than one root level folder, connecting to different namespaces or perhaps different servers, then gj :: locate will determine which workspace folder is current and locate the source code in that folder. If your workspace doesn't have any files open then gj :: locate will prompt you to select a folder from a pick-list.

This will particularly benefit VS Code power users who have workspaces with simultaneous connections to multiple namespaces, on multiple different IRIS and Caché servers.

If you would like to try it out then you can download it from the VS Code marketplace. Or if you’re already a user, then gj :: locate will automatically update. Let us know how you're getting on with it!

2 0
1 212

I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement.
However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax.
Basically, I am going for something like this:

Select v.valueId, m.name 
 From (values (1), (2), (3), (4), (5)) v(valueId)
     left Join otherTable m
        on m.id = v.valueId

Is it supported in Cache SQL or not?

0 6
0 206

Get the latest from Learning Services!

  • Navigation pages in InterSystems documentation
  • New podcast episodes: InterSystems Certification and InterSystems Reports
  • New online learning: Connecting Devices video, HL7 Business Services and Business Operations course, Use FHIR APIs to View Resources exercise
  • Upcoming webinars

Read more and subscribe to get Learning Services news once a month in your inbox!

0 0
0 212

Hi, Community!

This post is a digest of the Developer Community postings in June 2018.

Most viewed

Atelier 1.2 Stable Release 230

InterSystems IRIS Data Platform 2018.1.1 Release 199

"IF THEN - $SELECT - $CASE" - What is the best way? 179

$CASE For Long Stories 148

Translate a number to text 147

Sort ordering 141

Extending method keywords 138

Stop Storing Atelier Credentials 133

COMANDO $ZF 130

Multi Language Sort 125

Most voted

Atelier 1.2 Stable Release 7

Translate a number to text 7

InterSystems IRIS Data Platform 2018.1.1 Release 6

Multi Language Sort 5

InterSystems on DeveloperWeek NYC, June 18-20 5

Atelier at EclipseCon France 2018 4

Installation Manifest - I can disabled the journal globals by the XML? 3

Creating SSL-Enabled Mirror on InterSystems IRIS Using Public Key Infrastructure (PKI) 3

One simple Docker trick to halve your image build time 2

DC June 2018 Release 2

Most commented

Communication link failure trying to access Studio 15

$CASE For Long Stories 14

How to convert page number to roman numeral in ZEN Report? 14

Extending method keywords 13

How to navigate to parent of Serial Object? 12

Kill process started by JOB 11

Custom file pass through Operation writing out unreadable pdf files 11

Has anyone tried REST API Put Or Post on AWS S3 ? 10

%ProcessError+6 ^%Net.Remote.Proxy.1 error occurs inconsistently 10

How to Update Caché User Full Name field via SQL? 9

Top 10 Authors to Follow by Views

Francisco López, Posts, 147

Eduard Lebedyuk, Posts, 73

Daniel Kutac, Posts, 45

Pete Greskoff, Posts, 34

Top 10 Experts to Follow

Nicole Aaron, Answers, +11

Robert Cemper, Answers, +10

Eduard Lebedyuk, Answers, +9

Vitaliy Serdtsev, Answers, +7

Benjamin Spead, Answers, +4

Francisco López, Answers, +4

Evgeny Shvarov, Answers, +3

Dmitry Maslennikov, Answers, +3

Gilberto Junior, Answers, +3

Timothy Leavitt, Answers, +2

0 0
0 212

Presenter: Ray Wright
Task: Validate your performance and scalability claims, detect and correct bottlenecks, or determine the hardware needed to optimally run your applications
Approach: Discuss and demonstrate the use of our WebStress feature to design and run benchmark tests of your HTTP-based applications.

Conducting benchmark tests of your applications can help you highlight your performance and scalability claims, detect and correct bottlenecks in your application, and provide useful information about the hardware required to optimally run your solutions. Come to this session to learn about our “WebStress” feature that can help you design and run benchmark tests of your HTTP-based applications.

Content related to this session, including slides, video and additional learning content can be found here.

0 0
0 212

Hi beloved members of the Community!

It is very common in the daily life of IRIS or Health Connect users that it is necessary to install new instances or update the ones they already have and in many cases it is not these same users who carry out the installation, but rather systems personnel who often do not take into account the particularities of the assignment of permissions necessary for the installation.

6 0
2 211
Article
· Dec 26, 2024 1m read
Global Masters Holiday Cards

🎄✨ Holiday Greetings from the Community! ✨🎄

On Global Masters, you’ve sent us wonderful greetings for the community, and we can’t wait to share them with everyone! We’ve transformed your greetings into beautiful holiday cards—check them out below 💌. Thank you all for your warm words!

We also held a small contest on Global Masters for the most original holiday greeting, and @Harshitha.Balakrishna's card was chosen as the best one! Here it is: 👇
📌 Below, you can see all the greetings shared by Global Masters members. They remind us of how important it is to be part of such a united and creative community.

8 0
0 211

I'm facing an issue while converting an ORU_R01 HL7 message to XML, specifically with the <pidgrpgrp> kind elements. When I use the getvalueat() method before conversion, the XML includes the <pidgrpgrp> and other <grp> elements, but when I don't use the getvalueat() method, the XML is generated without these <grp>elements.

0 1
0 210

Hi all,

I have a situation where I am writing to global from different processes - let's call it an Event Queue.
There is then a different process that uses $order to read through the data - the PubSub processing BP.

Sometimes the writing of this global will form part of a transaction that also insert data into other tables, using tstart and tcommit.
If there is some issue, it will roll back, and the entry written to the global will also roll back.

0 6
0 205