Hi Community,

This week we have two new videos from Global Summit 2019. Please welcome:

1. An ML Toolkit for InterSystems IRIS: Co-Innovation in Healthcare

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

Hi Community,
In this article, I will introduce my application iris-mlm-explainer

Hi there

I've noticed extreme slowness using the portal in my Healthconnect dev enviroment lately.

Any page in the Portal takes a lot of time Loading.

Any ideas of what it could be?

Kind Regards,

Joao

Hi,

Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work
SELECT $$JOB1^KMIGxDESIG() FROM DUAL

Work
sELECT $$JOB1^KMIGxDESIG() FROM DUAL

for this I.m using ODBC 64.

Thanks

I am using the event logger from CSP gateway with level "v9r" enabled, in order to dump the raw content of some HTTP requests.

I would like to decode the body response data, when it's in binary form. AFAIK the event logger will convert characters outside the 32-127 range (EBCDIC) to the "\xff" notation (where ff is a hexadecimal value). Here is an example :

Is "time" a reserved word in the %CONTAINS function?

When I run the following SQL query, I get 0 matching results

SELECT ID, text
FROM Test.Sentence
WHERE text %CONTAINS('time') OR text %CONTAINS('time ') OR text %CONTAINS(' time')

However, when I run a query where the search string contains words other than "time" alone, it returns the expected matching results

This is the fourth 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.

Hey Developers,

In this video, you will learn how to use VS Code with Python:

⏯ Using VS Code with Python

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

I have a C string and I need to build a $lb from it.

This code works fine for strings shorter than 254 characters:

char *str = "some string";
int len = strlen(str);
int add = 2;
char *list = malloc(len + add + 1);
char lenChar = len + add;
sprintf(list, "%c\x01%s", lenChar, str);

Thought maybe someone can share the code for longer strings?

Hi Developers!

Here're the technology bonuses for the InterSystems Developer Tools Contest that will give you extra points in the voting.

Docker container usage - 2 points

The application gets a 'Docker container' bonus if it uses InterSystems IRIS running in a docker container. Here is the simplest template to start from.

ZPM Package deployment - 2 points

You can collect the bonus if you build and publish the ZPM(ObjectScript Package Manager) package for your Full-Stack application so it could be deployed with:

zpm "install your-multi-model-solution"

command on IRIS with ZPM client installed.

ZPM client. Documentation.

Unit Testing - 2 points

Applications that have Unit Testing for the InterSystems IRIS code will collect the bonus.

Learn more about ObjectScript Unit Testing in Documentation and on Developer Community.

Online Demo of your project - 3 points
Collect 3 more bonus points if you provision your project to the cloud as an online demo. You can use this template or any other deployment option. Example. Learn more on deployment in Monday's Kick-Off webinar.

Code quality analysis with zero bugs - 2 points

Include the code quality Github action for code static control and make it show 0 bugs for ObjectScript. Learn more in Monday's Kick-Off webinar.

Article on Developer Community - 2 points

Post an article on Developer Community that describes features of your project. Collect 2 points for each article. Translations to different languages work too.

Video on YouTube - 3 points

Make the Youtube video that demonstrates your product in action and collect 3 bonus points per each. Example.

The list of bonuses is subject to change. Stay tuned!

Hi All,

I am having an SQL query (mentioned below). When I am running this query it is taking 90 min to retrieve all records (approx 1 million records).

Fetching data from 5 tables using inner join in cache. Relative cost displaying 10 million

I wan to confirm How this query can be optimized

Hi,

I am trying to delete a HL7 standard schema i created by mistake however when i select delete in Studio i get the following:

The xml is as below:

Have enabled LDAP for our numerous , Ensemble, IRIS and cache instances with many namespaces. All is working fine and the ldap logins work.

But have noticed that the first instance that the user logs into the namespace is assigned to that user, but when that user than logs into another instance the default namespace from the first login is still there and doesn't update to the new namespace.

So this doesn't effect the ldap login but is now effecting the terminal logins where the user is now getting access denied.

I want to map global ^myUnitTests(ID)={Start}_"^"_{JOB} where {Start} and {JOB} are two properties and ID is determined by $Increment(^myUnitTests).

I defined this class but it will not compile: