Mullins School - PUT ON YOUR THINKING CAP! Help us... | Facebook

Do you have an idea that could make a real impact on InterSystems technology and be realised by Community members? Now’s the perfect time to share your thoughts!

We’re preparing something exciting and would love to see the ideas you think could take InterSystems to the next level. To achieve this, we need you to come up with new ideas for our Ideas Portal that could be considered as "Community Opportunity" ideas*.

Thus, put on your thinking cap and submit your ideas on the Ideas Portal by mid-November, and stay tuned for more updates.

4 2
0 97

We have a scenario where we use the best practice article of a BP and DTL to split up HL7 messages mainly ORUS

https://community.intersystems.com/post/splitting-oru-messages-using-obj...

It is really useful but we have this code in many places that we are trying to consolidate it in one place.

0 1
0 108
Question
· Jul 17, 2018
Cache Dynamic SQL Pagination

Would like to know if there is an alternative or better way to paginate through a dataset using dynamic SQL than what I am using below. The problem is that as the potential pool of data gets larger, this code slows down to the point of not being useable. In analyzing each line of code below, it appears the slow down is related to the initial rset.%Next() iteration. Is there anything available which does not require a subquery/%VID such as a simple LIMIT/OFFSET?

My code is similar to :

s sql=##class(%SQL.Statement).%New()

2 30
3 3.4K

Hello Experts ,

Could you help to search message details based on MRN in intersytems iris.

We have created 100+ interfaces and currenly in live (interystems cloud) . Now I try to search message details based on MRN using below query. it is working fine in DEV. but in prod it is taking ages.

0 2
0 119

Are there any objectscript functions (not wizards) to export and then import table data (including RowID)?

It doesn't matter what format the exported file is.

The import and export process should preserve all relationships, foreign keys, etc. I need to be able to export and import multiple tables at the same time.

I need this to implement the ability to export multiple tables from one instance and load them into another.

0 3
0 159

I have been walking through this with a few team members and as such I thought there might be others out there who could use it, especially if you work with HL7 & Ensemble/HealthConnect/HealthShare and never venture out past the Interoperability section.

5 1
1 494

Hello, Community!

It's time for the next InterSystems Developer Community contest!

✍️ InterSystems IRIS Technical Tutorial Contest ✍️

Create a Technical Tutorial** that can be considered a guide for InterSystems IRIS programmers of any level: beginner/intermediate/senior, from October 14th to November 24th. The tutorial can be in the form of an Article with text and images and/or a Demonstration Video.

Enjoy and let your creativity flow! Show how easy and fun it can be to create solutions with InterSystems IRIS.

🎁 Prizes for everyone: A special prize for each author participating in the competition!

5 2
0 104

Hi Guys,

Given that Analyst property is defined as class object I'm getting the Analyst ID in the below dataBinding, but I'm looking to display the Analyst name, I tried using dataBinding="Analyst->Name" but no luck, I got the same issue when binding to dataCombo or comboBox ?

0 2
0 63

Hi Developer Community,

We all love coding, but every now and then, it’s time to step away from the code and exercise! The InterSystems Walking Challenge will help you recharge your mind and boost your fitness. Embark on a virtual journey from Lübeck to Lüneburg along the historic Salt Road, the legendary trade route that connected Europe centuries ago.

Win exciting prizes like treadmills, smartwatches, and medals.

👟🚶🧑‍🦼Lace Up, Step Out, and Code Better! 🔋💻💪

📅 Registration is open until November 8.The challenge ends on November 22, 2024, at 6 PM CET

Want to join? Details below.

7 5
0 459

Hi Community,

Play the new video on InterSystems Developers YouTube:

Using LLMs with InterSystems IRIS Interoperability Productions @ Global Summit 2024

https://www.youtube.com/embed/IQ9r0OWYSZ8
[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 121

I’m trying to connect to an InterSystems Caché database from my local development environment using an IPv4 address. Most examples I’ve found show how to connect using the ODBC driver with the localhost or the default IP address (127.0.0.1). However, I want to know how to connect using my local IPv4 address.

Here’s what I need help with:

0 4
0 153

Welcome to the third and final publication of our articles dedicated to the development of RAG applications based on LLM models. In this final article, we will see, based on our small example project, how we can find the most appropriate context for the question we want to send to our LLM model and for this we will make use of the vector search functionality included in IRIS.

Meme Creator - Funny Context Meme Generator at MemeCreator.org!

3 0
1 290
Question
· Jul 23, 2024
JWT and CORS

Hi

I'm trying to use JWT authentication on a REST application in IRIS. The login API are correctly "injected" into the application. Login works fine with Postman and other REST clients, and subsequent calls to my REST API using the bearer token work fine (correctly authenticated). So far, so good.

0 9
0 302

Hello Community!

We are pleased to invite all our clients, partners and members of the community to take cart in the InterSystems DACH Symposium 2024. The registration is already open!

For all those who were unable to travel to the Global Summit in the USA this year, there is once again the opportunity to get all the important information at our InterSystems DACH Symposium in November.

➡️ InterSystems DACH Symposium 2024

🗓 November 5 - 7, 2024

📍 Scandic Frankfurt Museumsufer | Wilhelm-Leuschner-Straße 44 | 60329 Frankfurt am Main

4 1
0 208
Article
· Oct 17, 2024 2m read
ORU to MDM with large HL7 v2 messages.

I was working on a DTL but kept getting ERROR #5002... MAXSTRING errors. The problem was that most of the DTL GUI action steps only support the string data type when working with the segments. A %String has a limit of 3,641,144 characters and my OBX5.1 was 5,242,952 characters long as the example provided. Of course PACS admin stated ultra high quality up to and including 4K resolution files were needed, so we could not get the vendor to compress or reformat these files to compressed jpg or something similar.

3 7
1 245

In the past, I've created custom SQL operations, but now I had something trivial to do, so I decided to take EnsLib.SQL.Operation.GenericOperation out for a spin. There's no example in the docs, so it was a little tricky. Here's what I ended up doing:

In my external database, I have 'mytable' with two fields 'id1' and 'id2'. Here are the pertinent Business Operation settings:

1 2
0 108

json file failing in conversion to SDA

  • DO^zToQuickXML+11^HS.SDA3.NVPair.1 +2
  • DO^zToQuickXML+34^HS.SDA3.CustomObject.1 +1
  • DO^zToQuickXML+8^HS.Local.SDA3.CodeTableDetail.HealthCareFacilityExtension.1 +1
  • DO^zToQuickXML+28^HS.SDA3.CodeTableDetail.HealthCareFacility.1 +1
  • DO^zToQuickXML+6^HS.SDA3.Location.1 +1
  • DO^zToQuickXML+12^HS.Local.SDA3.ProcedureExtension.1 +1
  • DO^zToQuickXML+29^HS.SDA3.Procedure.1 +1
  • DO^zToQuickXML+155^HS.SDA3.Container.1 +1
  • $$^zToQuickXMLStream+5^HS.SDA3.QuickXML.1 +1
0 1
0 79