In MS SQL Server i can do this:

SELECT 
Category, CrewNumber, MedicalCertificationDate, Seat, SeatbeltUsed, Sex, ShoulderHarnessUsed, ToxicologyTestPerformed, childsub
INTO #tempfemale
FROM Aviation.Crew
WHERE Sex = 'F'

Hey Community, 

In this video, you will learn how to use the Data Transformation Wizard in the Management Portal of InterSystems IRIS® data platform to convert messages to other formats: 

⏯ Transforming Healthcare Messages in InterSystems Integrations

Hi Guys,

I'm a newbie in Ensemble productions and I've been asked to create an Inbound adapter and specify a port of which clients can send through JSON files and I did as attached, but now I've been asked to provide the URL to give to our clients so they send their JSON files to and I don't know what URL is should look like!? 

Thanks 

I was able to get SAM running with podman, but I am still unable to access the web page, and need a bit of help in troubleshooting as I am just trying this for the first time.

I verified the images were running by running podman ps

[xxxxxx@xxxxxx sam-1.1.0.107-unix]$ sudo podman ps

Hi, I am passing an EDIFACT file from a service to an operation using the super class. I would like to prepopulate the 'Source' variable with some information, but I’m not sure how to access this variable.

In this GitHub we fine tune a bert model from HuggingFace on review data like Yelp reviews.
The objective of this GitHub is to simulate a simple use case of Machine Learning in IRIS :
We have an IRIS Operation that, on command, can fetch data from the IRIS DataBase to train an existing model in local, then if the new model is better, the user can override the old one with the new one.
That way, every x days, if the DataBase has been extended by the users for example, you can train the model on the new data or on all the data and choose to keep or let go this new model.

I am starting to look at add-ons/enhancements that can be made to our environment as we move from 2018.1.3 to IRIS 2022.1. During one of our internal meetings it was mentioned that it would be helpful to gather and keep track of metrics as we move to IRIS 2022.1. I am looking to at trying to capture Message Count, Database size, global sizes, etc... Through Global Summit, and Open exchange, I know there is SAM, Grafana, and Promethus. I am struggling with getting SAM working on a Red Hat Environment using podman and not docker, but that is another story.

Hi Guys,

I've newly joined a new company and have been asked to get the number of classes in their system and was wondering if Ens, EnsLib and EnsPortal are normally a system or default packages that comes with default classes that developers can use or override? 

Thanks

Hey Community,

Let me introduce to you our brand new "About Us" page!

📍 community.intersystems.com/about

Hi Guys,

is there an easy way to count all line of codes in all classes in a namespace ?

I've been asked to give the total lines of code in all our system and we have over 3000 classes, so opening each one of them to check total line would take a long time.

Thanks

Hi Developers!

Sometimes we need to import CSV data programmatically to InterSystems IRIS either from CSV or from URL. And we expect the class with proper datatypes to be created and the data to be imported.

I published a module csvgen on Open Exchange which does exactly that.

If you just need the CSV file be imported into IRIS you can do the following:

USER>do ##class(community.csvgen).Generate("/usr/data/titanic.csv",,"Data.Titanic")

Class name: Data.Titanic

This is the fifth in a series of releases that are part of the developer preview program for 2022.2 Future preview releases are expected to be updated biweekly and we will add features as they are ready.  Many updates, fixes and enhancements  have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas.

Hi,

When i am using $$$LOGERROR("Message is Discarded") in the class  i am getting "Referenced Macro Not defined" error 

Can you help me how to use $$$LOGERROR in a class

Thanks,

Smythee

Hi all,

I am trying to test the IAM locally, but I came to a issue. When I turned on the the Basic Authentication, I get an 503 Service Unavailable.
error.

This is the scenario/setup:

• Because I am new to IRIS I need a test sample in IRIS where I can get data from.

Have a Zen report with a huge query that we are trying to break down and be more efficient.  

Looks like Zen only wants to take a result set class as the data (or XML, but writing to a file to generate these reports is probably even more overhead).

Is there a way I can move through a result set object, delete rows I don't want based on some objectscript commands and the pass that to the report?

Or can I pass a dynamic object?

Thanks.

Being interoperable is more and more important nowadays. InterSystems IRIS 2022.1 comes with a new messaging API to communicate with event streaming platforms like Kafka, AWS SQS/SNS, JMS and RabbitMQ.
This article shows how you can connect to Kafka and AWS SQS easily.
We start with a brief discussion of the basic concepts and terms of event streaming platforms. 

Event streaming platforms purpose and common terms

Hi Guys,

My application is running in Chrome but not in IE and I'm guessing it's a security issue, where when I open IE it tells me that ESC in on, but checking the configue in Server Manager tells otherwise? 

Thanks

Hello, Members of the Community!

We're so proud to announce that our InterSystems Developer Community has reached a couple of HUGE milestones:

📝 10,000 published posts

👥 11,000 registered members

👁 5,000,000 reads (it's five million!)

Looking for a new position working on InterSystems and Interface/Ensemble development/implementation, engine migration/upgrade, custom interfaces, message format conversions, or ETL.

Ideally looking for part-time and corp-to-corp. 

Profile:

• More than 15 years in healthcare industry, concentrated in HL7 integration with extensive experience in interface development with InterSystems IRIS for Health, Cerner OpenEngine, Openlink and Mirth.

In this article you will have access to the curated base of articles from the InterSystems Developer Community of the most relevant topics to learning InterSystems IRIS. Find top published articles ranked by Machine Learning, Embedded Python, JSON, API and REST Applications, Manage and Configure InterSystems Environments, Docker and Cloud, VSCode, SQL, Analytics/BI, Globals, Security, DevOps, Interoperability, Native API. Learn and Enjoy!

Machine Learning

Hi all, 
I have a requirement to periodically poll a URL to fetch some XML data based on a list of query data, lets say every hour, and map what's returned to HL7 then send downstream, I mostly have everything contained within a business process and DTL but I'm lacking a way of invoking the process every X minutes, 
The client has a prefence for as much as possible to be done via out of the box components in the standard HL7 model of  "Service --> Process/Rule/DTL --> Operation" within the Web UI, 

One of the most important tasks of dashboards is, on the one hand, to help you perceive data in an aggregated form, and, on the other hand, not to lose the depth of immersion in the data if you need this. One of the tools that help us achieve this result is drill down. It enables us to display several hierarchical levels of data, from aggregated to detailed.
Our task is to make an analytical dashboard that will be able to drill down by time periods:  from months to weeks and days in each chart.

Is it possible to create a scheduled task programmatically without using the management portal "Task Scheduler Wizard"?

Once created the scheduled task  would then be editable in the Wizard as normal for other users.

Thanks,

Conor

Hi Community

I have created a simple package that allows the use of Cache with the Laravel Framework.

From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package.

For those of you out there who have time and would be interested in this, please visit the repo at https://github.com/jeandormehl/laracache

Thanks in advance

Is there a way to compare the value in a source field against all of the values in a repeating field?  For example, we have multiple DG1 target segments populated.  Is there an easy way to check a source DG1 segments against all of the target DG1 segments?  I didn't know if there is a wild card I can use for the comparison.

Hi!

I have a question regarding SQL insert/update from the mananger portal's SQL window.

I am trying to do an insert with a value that contains multiple spaces ($32) between two words. This is needed for a comparative reason. But the spaces are automatically trimmed away all the time. How should I write to keep these?

Example:

Insert into TableA
(MyColumn) Values('xxxx    yyyy')

then the spaces are trimmed away and it becomes: 'xxxx yyyy'

But I want to keep the spaces. How do I get around the problem?

Regards,

Does anyone have experience with CircleCI or really any automation tool using %UnitTest?

I have built my app and ran my unit test in a Docker container automated by CircleCI.  However, after many of the tests failed I see:

How do you halt out of the IRIS session and return an exit code to the shell?

I have a script in my repo that I pass into IRIS after CircleCI does the code checkout

iris session IRIS < inFile

How do I detect that sync mirror backup is caught up to primary? Or at least close to caught up.

I'm executing the code on a backup.

A Minute Of Laughter on the Developer Community with #InterSystemsMemes

Meme author: @Mathieu Delagnes 

Have your own idea for a meme? Submit in this challenge on Global Masters.