All time

Hi,

I seem to be able to execute sqlproc using the convention defined here https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GSQL_q... provided the package/folder is a single level. As, soon I have a nested folder structure I get an error while trying to execute this.

For instance,

select id, Utils.Users_getRole(id) roles from users.users

works fine while,

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

Hi Developers!

Please welcome the new video on InterSystems Developers YouTube:

Data Platform Scalability

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

1 0
0 210

Hi Community,

Please welcome the new Global Summit 2019 video on InterSystems Developers YouTube Channel:

Rapid Intelligent Application Development

https://www.youtube.com/embed/IAPa7hoMJ5o
[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 210
Announcement
· Dec 3, 2018
DC October-November 2018 release

Hi Community!

As you know or maybe guess we keep working on making Developer Community a better place for you, developers on InterSystems Data Platforms.

And here is the release on what we did in October-November.

Key visible enhancements:

better monthly digests,

InterSystems Best Practices,

Speed up mailings.

And a lot of small, but nice things - check the details inside.

1 0
0 210

What are best practices for JSON transformation in IRIS interoperability? This is for a non-healthcare use case, so any tools we happen to have around FHIR might not be available. The motivating use case is trimming down a verbose and needlessly complex REST API response to feed to an LLM - trying to reduce token usage and maybe get better results from less noisy data.

2 10
0 199

Hey everyone,

I'm diving deeper into Caché ObjectScript and would love to open a discussion around the most useful tips, tricks, and best practices you’ve learned or discovered while working with it.

Whether you're an experienced developer or just getting started, ObjectScript has its own set of quirks and powerful features—some well-documented, others hidden gems. I’m looking to compile a helpful set of ideas from the community.

Some areas I’m especially interested in:

6 3
4 206

Hi, I am unsure how to remove this restriction; when I am performing dynamic SQL using ##class(%SQL.Statement).%ExecDirectNoPriv(, .query, args...)

It works fine, but the moment I add specific properties from the persistent class I am performing the select on into the WHERE clause, I get: ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation. Despite using %ExecDirectNoPriv, I've tried with prepared statement as well, exact same situation.

0 5
0 204

🚨 Update, January 21, 2025 – Maintenance Completed 🚨

The planned maintenance on the Developer Community has been successfully completed! While the site is up and running, we are still performing additional testing, so occasional issues may occur.

We apologize for any inconvenience and greatly appreciate your patience. If you notice anything unusual, please don’t hesitate to let us know.

Thank you for your understanding and support!

9 Under Maintenance Page Tips | Messages for a Down Website

5 2
0 169

It's time to announce the Winners for April! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in April:

🥇@David Hockenbroch, senior analyst, WoodWare Systems, United States
🥈@Sylvain Guilbaud, Sales Engineer, InterSystems, France
🥉@Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

Learn more about the competition and our awesome winners below.

2 2
0 169

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

InterSystems IRIS Scalability: New & Next Plus Ultra @ Global Summit 2023

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

4 0
0 209

Hi Developers,

Watch this video to learn how InterSystems is supporting new regulatory requirements:

Regulatory Roundup: What’s New in the Interoperability Arena @ Global Summit 2023

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

1 0
0 209

Hi Community,

New video is already on InterSystems Developers YouTube:

Fast & Efficient Provisioning & Testing with InterSystems Cloud Manager

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

2 0
0 209

Hey everyone.

I was curious if anyone had any success/tips with regards to using a global or a system parameter/property to control the behavior of a transform or process/operation.

Is there a parameter I can currently reference from the system that can be used for an if/else, or am I best off creating a simple Global and setting it according to the environment I am in?

0 2
0 207

I'm exploring this right now: given a bunch of types defined as Pydantic models, how can I come up with an equivalent %RegisteredObject/%SerialObject and convert to/from (e.g., to support persistence and match validation as much as possible)?

People who know Python better than I do (e.g., your average undergraduate from this decade): is this a stupid idea or a cool idea? Has anyone else done this before?

0 5
0 203
Question
· Nov 24, 2024
Intersystems REGEX engine

I am working on a product that uses REGEX and matches it.
The regex is tested both on the client-side (using the JavaScript REGEX engine) and both on the server-side.

But I couldn't find one word about the way intersystems parses the regex, It is quite elementary to state which which engine it works with.

from what I could gather from early implementations and such, the engine is based off PCRE, But I need to confirm this somehow, Can anyone give me a definitive answer, Is there any tool to test the regex other than writing it myself??

0 2
0 206

Hi,

I'm making a request to an API that works perfectly with Postman, you can see it here:

The URL is https://testcds.esriguide.org/v2/session/3189981 where the last part is the ID's session I want to get back.

When I try to make the same request in IRIS I always get a "Bad request" error.

I'm creating the request which all the information needed (or at least that I know):

1 2
0 206

Hi Community,

Watch this video to learn how to use the GitUI plugin in the HealthShare Health Connect Cloud user interface to make changes to your interfaces in the Management Portal and commit them directly to your source control workflow.

Using UI Based Source Control for Health Connect Cloud

https://www.youtube.com/embed/A-jqnyKtCAM
[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]

2 0
1 208

Hi Community,

We're super excited to share with you a special session from Global Summit 2023! And it is so special to us because it is about us and with us! Please welcome:

🤩 How to Get the Most Out of the InterSystems Developer Ecosystem @ Global Summit 2023

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

6 0
0 208