@Ming Zhou asked a great question in https://community.intersystems.com/post/how-get-all-properties-defined-… and the answer sums up exactly why ObjectScript is my favorite.

When I'm first describing ObjectScript or IRIS to someone I always explain that you can write a class, compile it, get a table, and work with your data from an object or relational perspective - whichever is most natural.

I have a table with a Varchar(max) column that I have created via the HealthShare SQL portal, and I see that in it's underlying class that column corresponds to a %Stream.GlobalCharacter

When I try to do a text search on that column (referenced as cd.Code in the example below) I get an error

select * 
from DevTools_CodeAnalysis_tables.Code cd
inner join DevTools_CodeAnalysis_tables.MethodData mtd
on charindex( mtd.qualifiedRef,  cd.Code) > 0

It produces the error

 Scalar function CHARINDEX (arg2) not supported for stream fields

How do I search it?
 

Hi There,

I'm fairly new to ObjectScript/Ensemble and I'm sure I may be fundamentally misunderstanding how the %JSONImport/%JSONExport and XDATA mapping work and I was hoping you good folks could help me out.  I'm essentially trying to create an object that I can use to translate from one JSON schema to another. 

First my class:

Class SERVICESVCPKG.Model.AthenaAppointment Extends (%Persistent, %DynamicAbstractObject, %JSON.

Is it possible to mirror the same database on Iris and an older Ensemble instance?

Specifically to try a zero downtime upgrade

I am trying to pass %request.Data from my rest dispatch class to a production so that I can use it in by business operation.  I have created a message that has a property:

Property urlParameters As%String [multidimensional];

to get the data to the production. I am new to intersystems and multidimensional arrays/globals

dispatch class:

Kill parameters
Merge parameters = %request.DataSet genericRequest = ##class(Core.API.V1.Msg.GenericRequest).%New()
Set genericRequest.

I'm hoping someone here has some tips. I'm trying to filter by d/t in a routing rule. Basically if before a specific d/t, send to one feed. If after, send to another. The d/t time is in a yyyymmddhhmmss format. I've tried a couple things but can't get it to work as expected. Any tips to accomplish this would be appreciated.

Hi All! We have recently updated the Exploring Healthcare Analytics with InterSystems exercise to a new version. Originally from a 2021 Virtual Summit experience lab, this exercise now focuses more specifically on using InterSystems IRIS Adaptive Analytics with InterSystems IRIS for Health. It features a new and improved data model and exercise to explore. Feel free to give it a try!

Hey Community, 

We're thrilled to invite you to the next InterSystems in-person event! Join us for a true community event, once again bringing together InterSystems customers and partners – to learn, inspire, and share innovation challenges with each other:

➡️ InterSystems UK & Ireland Summit 2022

🗓 Date: October 18-19, 2022

📍 Location: Birmingham, United Kingdom – The Vox Conference Centre

Hi Guys,

I'm getting the below TLS error in SSL_connect(), SSL_ERROR_SYSCALL, I've treid mulitple SSL/TLS configuration and still get the same error, so should I be asking the client that I'm trying to connect if there a specific certificate or configuration!?

Thanks

In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:

• Git 101
• Git flow (development process)
• GitLab installation
• GitLab Workflow
• Continuous Delivery
• GitLab installation and configuration
• GitLab CI/CD

In the first article, we covered Git basics, why a high-level understanding of Git concepts is important for modern software development, and how Git can be used to develop software.

In the second article, we covered GitLab Workflow - a complete software life cycle process and Continuous Delivery.

I this article we'll discuss:

• GitLab installation and configuration
• Connecting your environments to GitLab

I want to call a method which is in %SYS namespace : 

set NS = $NAMESPACEZN"%SYS"do ##class(Config.MapGlobals).Delete(...)
ZN NS

In reality code is even more complex (eg: need a try catch block to make sure namespace is switched back even if there is some error).
Is it possible to do this without changing current namespace ?
For example (does not work) :

do ##class(%SYS.Config.MapGlobals).Delete(...)

Hi Community,

We are glad to invite you to the upcoming Climate change InterSystems Full Stack Contest Kick-off Webinarfocused on climate change issues! The topic of this webinar is dedicated to the Full Stack contest.

We'll discuss the key challenges and problems that Climate Change and Global Warming set up and how they can be probably solved. As always, our experts will answer the questions on how to develop, build, and deploy full-stack solutions using InterSystems IRIS.

Date & Time: Monday, June 27 – 09:00 AM EDT

Speakers:  
🗣 ​​​Ainar Abdrakhmanov, Climate change expert, co-author of 4 waves course, Co-Founder, SEO at Longevica
🗣 @Timothy Leavitt, InterSystems Development Manager
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hello,

I am wondering if anyone can help me with an issue we are facing. We are trying to add a parent-child relationship between 2 tables in the database that already contain data. We are able to add the new relationship property to the required data classes, and set the desired cardinality. We have also included code that will add the relationship using the Insert() method to new data that comes in.

The problem we have is how do we add the relationship to data that already exists in the database?

Couldn't see this on the community, not sure why...

UK & Ireland Summit 2022
Leading Through Innovation

18-19 October 2022 – The VOX, NEC, Birmingham

Join us for a true community event, once again bringing together InterSystems customers and partners – to learn, inspire, and share innovation challenges with each other. To register, please complete the form

Hi, I tried the following exercise from the IRIS documentation. I updated the username, password and IP address, but receiving this error;

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. --->

I can use the same credentials and IP address to connect ok via VSCode to my local IRIS...

Any pointers much appreciated.

https://docs.intersystems.com/irisforhealth20211/csp/docbook/DocBook.UI….

Has anyone here been successfully populating a %Persistent object from calling %LoadFromMemory() with a temp. global?

I have tried using Sample.Person in the SAMPLES namespace. It worked EXCEPT that I have no way to set the id into that Sample.Person objec.

SAMPLES>Merge array(1) = ^Sample.PersonD(1)
 
SAMPLES>Set obj = ##class(Sample.Person).%LoadFromMemory(1,.array)
 
SAMPLES>zw obj
obj=1@Sample.Person  ; <OREF>
+----------------- general information ---------------
|      oref value: 1
|      class name: Sample.

I think it's a known fact that Populate Utility has very limited functionality. It supports only one language and one country. The list of possible values does not have so many options. 

There is a kind of tool that now can help with it, named Faker. It has implementations in different languages, including Python. Since IRIS has now had the Embedded Python feature, Python faker can be implemented in IRIS.

Hey Developers,

Join us for a discussion guide of current operational tasks to reduce storage and an overview of new features coming in InterSystems HealthShare 2021.2, including stream, database, and journal compression abilities:

⏯ InterSystems HealthShare Storage Footprint Reduction

Hi All,

I am preparing for InterSystems IRIS Core Solutions Developer Specialist Certification. I have completed the desired syllabus. Does anyone have any questions dumps. I have already completed the practice paper on Intersystems website.

This formation, accessible on my GitHub, will cover, in half a hour, how to read and write in csv and txt files, insert and get inside the IRIS database and a distant database using Postgres or how to use a FLASK API, all of that using the Interoperability framework using ONLY Python following the PEP8 convention.

This formation can mostly be done using copy paste and will guide you through everystep before challenging you with a global exercise.
We are available to answer any question or doubt in the comment of that post, on teams or even by mail at lucas.enard@intersystems.com .

Suppose you have developed your own web app with InterSystems technologies stack and now want to perform a captcha validation on the client side in order to determine whether or not the user is human and make it safer. There are some modern frameworks to address the captcha issue, however most part of them needs internet access to generate codes and sometimes are complex to implement. Take this as basic example considering that image recognition has gotten too good. That's why you nowadays you tend to see more pattern recognition captchas than mere reading ones. (I.e.

Is there a way for us to restrict user's ODBC permissions based on what program they're running on a client?

For example, we have some older Windows apps (.exe) that are a regular part of our software package which require the user to be able to select, insert, update, and delete. Some of our users are also using other third-party apps to connect (mostly reporting tools) but we only want them to be able to select unless we've approved the exe. Is there a way to do that?

These are not applications that were developed using CacheDirect.

The time that many of the Developer Community members, InterSystems Partners, and just people interested in InterSystems products, had been looking forward to has arrived! Finally, after an excruciatingly long pause, this year's Global Summit is again held in person! This time it's in Seattle! A beautiful city with steep hills, breathtaking views of Elliot Bay, and, from the words of locals, constantly bad weather 

Hey Community, 

In this webinar, we’ll discuss how you can now easily integrate Apache Kafka within InterSystems IRIS data platform, including via interoperability productions and programmatically via API calls, as both a producer as well as a consumer of Apache Kafka messages: 

⏯ InterSystems IRIS Tech Talk: Kafka

Hi Community,

I'm building a browser only code editor for IRIS. Here is a video demonstration. It's still very much "work in progress", more updates to come. I will also add it to ZPM soon.

https://www.youtube.com/watch?v=Am6QAvrPPPg

Is there a way to access a SOUNDEX function from ObjectScript?  There is such a function in the multivalue basic dialect and also one used by Patient Index.

Hi developers!

Here are the bonus points for the experts voting for your applications in the Fullstack contest 2022:

Here we go!

• Climate Change  - 5
• isc.rest package - 2
• isc.ipm.js package - 2
• Embedded Python - 3
• Adaptive Analytics (AtScale) Cubes usage - 3
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Unit Testing - 2
• First Article on Developer Community - 2
• Second Article On DC - 1
• Code Quality pass - 1
• Video on YouTube - 3

I'd like to to assign a value to a variable, depending on the results of a condition. The equivalent of what can be done in c++ with the following:

(a>b) ? a=1:a=0;

Or in python:

a = 1 if a>b else 0

This makes the code much more readable and compact.

In objectscript it would be:

if (a>b){
    a=1
} else{
    a=0
}

Hello,

I want to access the HL7 Router settings from within the HL7 rule. Goal is to create a New class by extending "EnsLib.HL7.MsgRouter.RoutingEngine".

Then create a PARAMETER ProcessMessage which can be set to an integer value for the HL7 Router.

Create a Rule class and based on the value of this setting ProcessMessage
process/not process the messages.

Class XYZRules Extends Ens.Rule.Definition [ CompileAfter = CUSTOM.Util.Rules.FunctionSet ]
{Parameter RuleAssistClass = "EnsLib.HL7.MsgRouter.RuleAssist";XData RuleDefinition [ XMLNamespace = "http://www.intersystems.

Hi all!

I'm currently trying to find out how to have one Web Gateway route to multiple servers Management Portal. The only thing that I have come up with so far is to potentially make different routes per server?

I have a development, test, and production server and I want to use the same Gateway server using IIS to do SSL/TLS encryption for the CSP pages.

Any ideas or recommendations to pull this off?