Syndicate content 0  
 
All time
Article
· Oct 4, 2024 2m read
Reviews on Open Exchange - #47

If one of your packages on OEX receives a review you get notified by OEX only of YOUR own package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.
Some were accepted and merged, and some were just ignored.
So if you made a major change and expect a changed review just let me know.

2 1
0 160

Hi Community,

Are you ready to transform your healthcare organization with the power of Artificial Intelligence? Join us for an enlightening webinar that will equip you with the knowledge and tools to harness AI effectively in your practice.

🌐 Are you and your data AI ready? 🌐

📅 Tuesday, 15th October, 1 pm ICT | 2 pm SGT| 4 pm AEST // 8 am CEST | 2 am EDT

🗣 Presenter: @Kathleen Aller, Global Head of Healthcare Market Strategy, InterSystems

Edition #42 - Analytics Bites - Real Healthcare Providers' Channels to be Certified on Youtube

1 0
0 180

Hi Team,

This is very urgent can you please guide me to convert the date string to ISO format.

set date = "20240501144800-0500"

set result = $SYSTEM.SQL.Functions.TOTIMESTAMP(date, "YYYYMMDDHHMISS")

write result -> 2024-05-01T16:49:00:00+00:00

so here timezone is dropped off but i need that.

expected result -> 2024-05-01T16:49:00-05:00

Please help me here how i can convert in this format.

0 2
0 178

If I had:
________________________________________
Class MN.Student Extends %Persistent
{
Property Name As %String;
________________________________________
Class MN.Course Extends %Persistent
{
Property TeacherName As %String;
Relationship StudentName As MN.Student [ Cardinality = one, Inverse = Name ];
________________________________________

For "Cardinality = one" the SQL line below would be sufficient for archiving
INSERT INTO MN.Course (TeacherName, StudentName) VALUES ('Pierre','3')"

0 1
0 179
Article
· Sep 28, 2015 1m read
Ensemble Virtual Documents TechFAQ

An introduction to virtual documents

Ensemble virtual documents enable your productions to work with large and complex documents with little overhead.

What is a virtual document?

A virtual document is a special kind of Ensemble message, for use with Electronic Data Interchange (EDI) messages and with XML documents.

How are virtual documents different from standard messages?

0 0
0 180

Hi,

Just thought I'd share quite a handy hook that has helped me out when developing on Health Connect Cloud with VS Code and GitBash. When developing on Health Connect Cloud, if changes are made directly on the server such as routing rules or component deployments, they aren't automatically included in source control, therefore you must export from the server into your local files and push to your remote repo. I'm sure there are easier methods to deal with that which I'm in the process of testing, but as a quick solution I thought it would be handy have a pre-commit hook which triggers a reminder in GitBash - see below.

6 1
1 159

Hi Community,

As you may know, this year's Spanish Technical Articles contest will be in May. I am going to make a series of articles to support you in the creation of your articles, giving tips and tricks. Perhaps they will be useful for the contest you have active in this community as well.

As you may know, one of the bonuses or extra points you can receive is to add a video tutorial to your article. You may not even know how to approach this issue, no problem! I'm here to give you some tips that you can apply not only to the creation of these videos, but to any other.

6 2
1 139

Last Chapter: Creating a REST client to get Tracks from Spotify REST API - Part2 Save and Refresh Token

Git link: https://github.com/ecelg/InterSystems-IRIS-as-a-Spotify-REST-client

Ok, now I am pretty sure i have a valid token for making query.😀

Shall we try to query something from the API.

0 0
0 179

Hi, I'm new to the Analytics world in Intersystems and was attempting to print and/or export selected rows from a detail listing in a pivot on a dashboard. I am able to print and/or export all the rows; but if I select a specific set of rows, it prints out the entire detail listing; not the selected rows. Please advise on the best approach to accomplish this task. Thanks.

0 2
0 177

Hello Community,

The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems IRIS SQL Specialist exam. It is now available for purchase and scheduling in InterSystems exam catalog. Potential candidates can review the exam topics and the practice questions to help orient them to exam question approaches and content. Candidates who successfully pass the exam will receive a digital certification badge that can be shared on social media accounts like LinkedIn. <--break->

5 0
1 179

I have some Services using EnsLib.File.InboundAdapter to go directly to respective operations using EnsLib.File.OutboundAdapter which has a 'File Path' specified.

Using this File Path as a root directory, I'd like to instead pass this through a Router where I could somehow inject a subdirectory to place the file into on the outbound side based off the source service it is coming from. There will likely be several inbound services writing to each outbound operation and I'd like to be able to sort the output into subfolders.

1 1
0 178
Announcement
· Jul 18, 2024
[Video] Generative AI in Use

Hi, Community!

Do you think Generative AI can make your life easier? See some potential use cases for GenAI in the latest video from Learning Services:

▶ Generative AI in Use

https://www.youtube.com/embed/5D8A0PDsV2A?utm_source=youtube&utm_medium=social&utm_campaign=5D8A0PDsV2A
[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 179

I have a fixed width complex recordmap that is an older version of a file format. I am trying to retool it to fit the latest version. The old recordmap has almost 500 entries on it and the new version has a few more fields added along with changes to some field lengths. Adding a new field adds it at the end of the recordmap and moving it from field 490 to field 139 is a painful process. Is there an easier way of doing this?

1 1
0 178

Hi Community!

Here is a digest of the InterSystems Developers videos on the InterSystems Developers YouTube Channel in July 2019. Please check it out!

Top 10 Videos by Views
№VideoViewsWatch Time (min)
1Active Directory Integration with LDAP1 2394 925
2Building Modern Web Applications7313 737
3SMART on FHIR: The Basics5265 027
4Developing with FHIR - REST APIs2281 376
5Locking in InterSystems ObjectScript2151 075
6Create Your First InterSystems ObjectScript Code with IRIS Community, Github, Docker and VSCode169530
7Natural Language Processing with InterSystems IRIS152393
8Sizing and Capacity Planning120922
9GitHub Flow with InterSystems IRIS: Edit with VSCode, Test with Docker, Commit, Push, Pull Request118505
10A SOLID Design in InterSystems ObjectScript118885

1 0
0 179

Modern SQL engines are enormously complex pieces of software. Even when they appear stable and mature, subtle bugs can hide in their optimizers, type systems, predicate evaluation, or execution layers. These bugs rarely announce themselves loudly. Instead, they quietly produce incorrect results, behave inconsistently, or fail abruptly under specific combinations of SQL constructs.

This is precisely why tools like SQLancer exist. SQLancer automatically generates SQL queries and uses logical “oracles” to detect when a database behaves incorrectly. It has revealed hundreds of real bugs in widely used systems such as MySQL, PostgreSQL, SQLite, and DuckDB.

With this in mind, I attempted to bring SQLancer to InterSystems IRIS, starting with the NOREC oracle — a powerful method for detecting optimizer correctness issues. The journey, however, uncovered not just potential SQL correctness problems, but also a surprising number of driver-level and server-level failures that prevented SQLancer from running at full strength.

This article summarizes why SQLancer is important, how the NOREC oracle works, and what unexpected findings appeared while testing IRIS.

Open Exchange app
14 3
1 118