All time

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 204
InterSystems Developer Community is a community of 25,339 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

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 205

In our latest episode of Data Points, I had a conversation with @Thomas Dyar about AI Link, which helps bridge the gap between data scientists and business analysts. Our conversation talks about how AI Link fits with IntegratedML and Adaptive Analytics, as well, as what new features are on the horizon for IntegratedML. Take a listen!

https://5e18edf067eb59-03854285.castos.com/player/1346398
[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]

3 0
0 205

Hey Developers,

New video is already on InterSystems Developers YouTube channel:

⏯ What is the InterSystems IRIS FHIR Server

https://www.youtube.com/embed/2FC_yIC9VCY
[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 205

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ FHIR Overview @ Virtual Summit 2020

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

5 0
0 205

I am hoping I explain this correctly.

We are using a query expire edge, to pass an API request to one of our vendor systems.

There is no feed into the gateway from an external system, and it is only used to query the external system with member data.

However, it is our understanding that the member needs to be registered on the edge.

Wondering if there is a way to export from the registry the bare demographic info in SDA to import to the new edge?

0 2
0 203

Hi Community!

This is a digest of the Developer Community postings in November 2018.

Most viewed

New release cadence for InterSystems IRIS 302

Abnormal programming with InterSystems 217

Language features that you really should know from day 1 215

What is best approach to parsing CSV string to tab-delimited string? 207

How do You Convert 8-bit Database to Unicode? 141

InterSystems IRIS 2018.2 available in preview 139

How to get running operating system 122

ObjectScript: Looping over a multidimensional global value and comparing 119

Syntax highlighting for ObjectScript 119

Detection of last update timestamp of each class row (DSTIME ?) 117

Data Verifier for InterSystems Data Platforms 104

Uploading and downloading files via http 99

Fetch Message Header Data 62

Utility to compare class and include file definitions between builds 55

0 0
0 205

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.

0 0
0 205
Question
· Mar 4
Message Count

Looking for a SQL query or any other method to find the Unique/distinct message counts for all productions or at least per production namespace within a given time frame. For e.g TimeCreated = January 2025 (Whole month)

I have used the following, but its not restricting the numbers based on the TimeCreated filter. Every time a new message is processed by system, its added to the total. I am running the query in today's date

Select Sum(MsgCount)

From

(Select DISTINCT TargetConfigName, count(DISTINCT SessionID) as MsgCount

FROM ENS.MessageHeader

1 12
0 192

We have an ObjectScript application that runs in Cache' and IRIS. Our typical installation involves a .zip file containing several files necessary for the installation and operation of the application. Steps are: expand the .zip file to a folder that will not be used by the application. Do ^%RI for the installation routines in the production namespace. Do the Installation routine. We have a customer that is trying to do a silent installation. He does not want to have to respond to any prompts on the installation.

0 3
0 201

Hello,

With my team, we're evaluating the different streams existing in order to find good pratices for our project using InterSystems IRIS. In doing so, we found that there exists different forms of the same stream with the %Stream.FileBinary and %Stream.FileBinaryGzip classes. We think that the %Stream.FileBinaryGzip takes less space to be stored, but is there other diferences between these two classes and what would you recomend to use ? Is it the same thing for %Stream.FileCharacter and %Stream.FileCharacterGzip ?

Thanks for your help,

0 2
0 202

We are investigating option of populating .pdf Custom Properties Name-Value pairs with episode/billing information from the TrakCare database, using Logi Reports. Resulting .pdf would be stored in a designated network folder. Would welcome suggestions on feasibility / technique to achieve / code to achieve (or alternative approach).

Intent is for further (watcher) process to detect new .pdf file in network folder and determine actions and/or process flow based on Name-Value pair information in pdf's Custom Properties.

0 2
0 202

Hey Community,

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

New Videos
№ Video Views
1 What is InterSystems TrakCare 24465
2 Using Code Based Source Control for Health Connect Cloud 166
3 Projecting Your Globals to SQL 155
4 Artificial Intelligence Healthcare Solutions - Time to Take Action 136
5 [Hebrew Webinar] Advanced JSON & DocDB 81
6 Using Embedded Python as a Jupyter Notebook Server 79
7 #10 InterSystems Developer Community Roundtable - November 30 2023 45
8 How UC Davis Health Uses InterSystems API Manager 43
9 Caelestinus 2023 – Final DEMO Day 30 Nov 2023 35
10 Online Meetup with the winners of the InterSystems Java Programming Contest 2023 24

2 2
0 164

If you hold the InterSystems HL7 Interface Specialist certification, you can potentially get recertified and have your certification expiration date extended by five years by beta testing our new InterSystems HL7 Interface Specialist Recertification project. The project includes hands-on exercises to validate core skills for developers who use InterSystems products to build and test HL7 v2.x productions.

1 0
2 204

Hi Developers,

This November, you posted 68 new questions on the Developer Community:

Questions

1 0
0 204

Hey Community,

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

New Videos
№ Video Views
1 Using the VS Code Debugger for InterSystems ObjectScript 3378
2 Introduction to Cubes in Business Intelligence 349
3 Smart Data Services (Vision & Demo) 232
4 Join Us on a Journey from Caché/Ensemble to InterSystems IRIS 129
5 Using VS Code with Python 97
6 InterSystems Python Contest Kick-off Webinar 91
7 GlobalToJSON ePy 43
8 Securing FHIR Applications with OAuth 2.0 (Part 1) 31
9 GlobalToJson Embedded Python Pure 28
10 Creating Virtual Models with InterSystems IRIS Adaptive Analytics 27

2 0
0 204

After setting AllowedIPAddresses with a valid IP address

i get the following errors.

ERROR <Ens>ErrException: <READ>zOnTask+44 ^EnsLib.TCP.InboundAdapter.1 -- logged as '-'
number - @''

what am i doing wrong?

and question:

where in the message viewer can i see the source IP of the message?

Thanks

0 3
0 201