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.

If you want to know if a class about a topic already exists asking a simple natural language question, it is possible now. Download and run the application https://openexchange.intersystems.com/package/langchain-iris-tool to know all about your project classes in a Chat.

Submission for InterSystems Technical Article Contest 2025

By Suze van Adrichem, Alice Heiman and Bubble Yu

View our video here: https://share.descript.com/view/JjI5tob8La

Hi,

I try to create a tab delimiter file with bold header, when I convert the file into Microsoft Excel, it has a bold header. The file can be in text or CSV exension.

Thank you.

Alan

I implemented a Python Flask application for the 2024 Python Contest with a page that provides common form fields for an outgoing email such as the To and CC fields. And it lets you input a message as well as uploading text based attachments.

Then using LlamaIndex in Python, the app analyzes the content you put in and returns to you in a result box if there is anything that should stop you from sending that email.

Take a look at the Github repo here.

Hi

I am trying to connect to node js on iris community version . Node js is properly installed .

I am executing the demo hello world from github .

these are the parameters :-

var ip = "localhost"

var port = 51773

var namespace = "USER"

var username = "SuperUser"

var password = "SYS"

when executing >node demo.js i get a connection error .

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in December 2023:

CCR Client ItemSets now have a "stale" cut-off time. When a client-bound ItemSet is created in CCR, a user has 24 hours to deploy it to any environments. After 24 hours, this ItemSet is no longer deployable or downloadable. The deploy links will be disabled and instead the user will notice a "Refresh ItemSet" option which will create a new ItemSet. Users can then use this fresh ItemSet to deploy their changes, see below:

Stale ItemSet:

Fresh ItemSet:

SQL obtains the user's operation permission on the database

How to add a default healthdhare login page on a js application hosted on healthshare

What is the shortest frequency of time I can set to have Cubes rebuilt.

Presenter: Mark Massias
Guest Speaker: Bruce Porteous of Northgate
Task: Build a composite application that bridges data silos
Approach: Give a real-world example of combining data from multiple sources to run a composite application

Most organizations need to bridge silos of data or combine separate applications. This session describes techniques for building composite applications and silos. The session also looks at a real application that does this. It uses workflow to assign cases to individuals for investigation and extracts information from multiple systems to provide the investigator with a complete context for the case at the scene of the incident.

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

Hello,

Our software commonly returns a full result set to the client and we use the DataTables plugin to display table data. This has worked well, but at datasets grow larger, we are trying to move some of these requests server-side so the server handles the bulk of the work rather than the client. This has had me scratching my head in so many ways.

I'm hoping I can get a mix of general best practice advice but also maybe some IRIS specific ideas.

Some background

🚨 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!