All time

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

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

Hi Community,

Watch this video to learn about the PainChek artificial intelligence technology, which assesses patient pain at the hospital bedside, leverages InterSystems IRIS interoperability to connect to third-party electronic medical record systems:

Using Artificial Intelligence / Machine Learning for Pain Assessment in a Clinical Environment @ Global Summit 2023

https://www.youtube.com/embed/-XNQUj7Sx_s
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 191

I use a swagger file and ##class(%REST.API).CreateApplication to create the rest api.

There is an interesting post: https://community.intersystems.com/post/download-file-rest-api-operation, but it is code, not a swagger configuration. disp.cls returns always a header content : application/json that of course fails as I am not always returning a json

I can not figure out what to put in swagger. Some examples I tried:

0 2
0 189

Looking to get started with generative AI? Try two brand-new learning paths. In Getting Started with Generative AI (2h 45m), learn the basics of interacting with GenAI. Then, try Developing Generative AI Applications (2h) to start developing your own GenAI application. Plus, earn badges for completing each path!

4 0
0 191

there is a setting in VSCode "objectscript.export: {noStorage: ture} " allow export cls from server to client, without storage definition.

However, wheneven I complied and save cls in my vscode client, the storage definition was added back. If I don't want it, I have to deleted the part manually.

Does anyone have something to teach me? thank you

0 6
0 185

Hello,

I am trying to connect to a web socket endpoint that potentially has a number of different IP addresses for load balancing purposes.

I have been asked whether it's possible to use a DNS name to resolve the IP address rather than statically assigning one specific IP address in the TCP Operation.

If it's not possible to resolve on a DNS name directly on the TCP operation, then I wondered whether it was possible to provide multiple IP addresses.

0 2
0 189

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

0 1
0 190

Hey Developers,

Watch this video to learn how an InterSystems partner based in Ostfildern, Germany, made a simple switch to InterSystems IRIS and rolled it out to 2,500 end-users by using the in-place conversion:

Migrating to InterSystems IRIS Made Easy @ Global Summit 2023

https://www.youtube.com/embed/uK-g5nobLr8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
1 191

Hello InterSystems EHR community,

InterSystems Certification is currently developing a certification exam for InterSystems EHR Reports specialists, and if you match the exam candidate description given below, we would like you to beta test the exam! The exam will be available for beta testing starting June 30, 2025.

2 1
2 170

In 2023, according to IDC, Salesforce's market share in CRM reached 21.7%. This company owns a substantial amount of critical corporate business processes and data, so the InterSystems IRIS must have an interoperability connector to fetch data from the Salesforce data catalog. This article will show you how to get any data hosted by Salesforce and create an interoperation production to get data and send it to such targets as files and relational databases.

8 0
3 190

Hello,

First of all: thanks for your help, and thank you for your time.

Thanks for your time.

We have the following situation:

We are in a BPL, and we have defined 4 <call> asynchronous as follows:

First one name: "Enviar a Proceso NEGRIN"

The second one, named as: "Enviar a Proceso HUNSC"

0 9
0 181

Hello everyone,

I just want to know if there is a difference in performance between using Class methods versus MAC routines?

For example:

do Method^MyFunction()

versus

do ##class(MyFunction).Method()

0 2
0 188

I have an HL7 message that contains NTE segment with line break inside.

when I try to transform it (with DTL) it stops reading the message after the line break inside the NTE because it treat that as "End of Message".

Is there a way to solve this in the DTL or I need to run a pre process on the HL7 message that identify the line break inside the NTE segments and replace it with an escape char?

1 1
0 189

Hello Community!

A new challenge has arrived for you: The Third InterSystems Technical Article writing contest in Spanish is here!

🏆 3rd Technical Articles Contest in Spanish 🏆

Description of the contest: Write an article in Spanish in the Developer Community, on any topic related to InterSystems technology.

Duration: from May 6 to June 2, 2024.

Prizes for all participants: Everyone who publishes an article in Spanish (In the Spanish Community) during the contest period will receive a prize.

Main prize: LEGO Ferrari Daytona SP3 / Magic Gringotts™ Bank - Collector's Edition.

5 1
0 170

Hi everyone,

I'm looking for a strategy for dividing a large FHIR message, in a post request, into smaller parts.

I have found the paging modifier for the GET request, but not a similiar one for the POST request. Maybe the 'batch' type of a Bundle could help me to indicate this aim but there aren't any attribute to say the total or the i-th element.

Do you know of any method for implementing 'paging' in a post request?

0 2
0 188

The InterSystems Certification Team is building an InterSystems TrakCare Reports certification exam and is looking for Subject Matter Experts (SMEs) from our community to help write and review questions. You, as a valued InterSystems community member, know the challenges of working with our technology and what it takes to be successful at your job. A work assignment will typically involve writing 15 assigned questions and reviewing 15 assigned directly to you.

2 0
0 190

Job Description

Planning, building, training, and manage (Program and Project) to convert HL7 inbound messages (coming from primarily Epic) to InterSystems FHIR.

Looking for a person who can develop (well versed in InterSystems FHIR experience), demo, train/mentor the team, manage the project.

0 0
0 190