The goal is to construct a comma separated string, using a loop but the same way $listtostring(var,",") would do (i.e. "a,b,c,d,e,f,g,h" without starting or ending comma).

What is the best way to do it, concerning the readability of the code and its performances?

To do so, there are more than 5 methods, but in this example we will test 4 :

1) using a "if" in the loop

set str=""
for ... {
    if str'="" { set str = str_"," }
    set str=str_myval
}

2) using a set

set (str,sep)=""
for

Hey everyone.

I was curious if anyone had any success/tips with regards to using a global or a system parameter/property to control the behavior of a transform or process/operation.

Is there a parameter I can currently reference from the system that can be used for an if/else, or am I best off creating a simple Global and setting it according to the environment I am in?

Hello everyone
I use cache script, I would like to know from you if there is any function or class in the cache where I can get the start and end date of a given month:
Example: What is the first and last day of the month of February 2015.

Grateful.
Davidson

Hi

I have created %ALL namespace to map with two existing namespaces to use class globally but I am not able to select %ALL namespace as it is not appearing in the available namespace list. How to create objects in %ALL namespace?

Thanks

Hello everyone,

I think I put everything in the title. It's a simple question : how to restart a connector or a list connector without double-clicking?

Is there a way using another connector to do so (using code)?

Is there a way using a command line in the terminator/ds command (in the purpose to use a batch)?

Faithfully,

Thomas

Hi community,

Do you have docker automl docker image with zpm?

In the first part we got a quick introduction on the IMAP protocol commands, now it's time to use IRIS and implement them and create our own IMAP client!

IRIS Email Framework

The IRIS platform has default interfaces and classes for working with email. Developers originally designed those artifacts for POP3 implementation. However, this doesn’t mean that we can’t use and extend these interfaces and classes to implement an IMAP client. So let’s talk about them:

• %Net.FetchMailProtocol: This is the base class for email retrieval. The IMAP client extends it.
• %Net.

Here is a new release of InterSystems Open Exchange 

What's new?

• Contest "Register" button;
• Featured applications;
• Profile completeness indication;
• Email or Contact us link;
• Claim company profile.

See the details below.

Hey Developers,

Watch the new video on InterSystems Developers YouTube:

⏯ Tell the World About Your REST APIs: The Benefits of a Centralized Developer Portal

Hi

Upon creating namespace I selected same database for both Globals and Routines. How can I separate both the databases. Please note that I already have data and code saved in database.

Thanks

Hello,

When using GetFieldStreamRaw(), by passing in a variable instead of using an output for the Remainder, will this affect how it is stored into a segment in a cloned message? I know it would usually output the remaining fields of the segment but in order to conform to a supplier's spec, they'd require "^^PDF" rather than the rest of the segment. Because the segment becomes immutable, the code below seems to be the way to do it.

Hello community!

I'm facing a base growth issue, which is being generated by a process and an Ensemble feature.

When executing the process of cleaning up the message queues, the Ensemble “preserves” the Streams that were part of these messages, deleting only the Header and Body. In this way the database (of one of the namespaces) has grown around 60GB per day, which has been maxing out the disk capacity.

InterSystems informed that this is a characteristic and that it is explained in the documents mentioned below.

https://community.intersystems.

Dear Developers,

I have a complex ZEN PDF report that has multiple tables that essentially are the same but are populated by different global definitions. The code has hardcoded groups for these tables but I would like the number of tables to be variable as many as there are global levels for a particular report.

Is there any way that I could build a report from a variable source of data rather that hardcoding 10 or more exact sections like the code below ? 

The code below is for table 2 in my report

<container ifexpression="%report.TestProfileFlag(2)=1">
<pagebreak ifexpression="%report.

Hi Experts

I am trying to pull the code tables Information and this code table has linked  code table not exactly obviously joined by SQL tables or columns. This is confusing me. Please can you clarify how to link these two tables. 

I will be generic to ensure, any privacy is protected

CT_Hospital has CT_Staff linked in.

When CT_Hospital has data, for that relevant hospital code, CT_Staff can be clicked and data entered. 

When I see in the Components - > Items I do not see any SQL table or SQL column common between CT_Hospital and CT_Staff. 

Question: How can I join CT_Hospital with CT_Staff.

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "IntegratedML - Creating ML models in minutes"!

Date & Time: September 30, 4:00 PM (CEST)

Speaker: @Eduardo Anglada, Sales Engineer, InterSystems Iberia

Interesting issue we found. When making an ODBC connection from a host via RDP, the IP address shown as making the connection is the client IP address, not the host from where the connection initiated. Has anyone seen that or know how to get around it? 

Example:

My Computer(10.X.X.112) -> RDP to Host1(10.X.X.93) -> ODBC connection to Server1(10.X.X.12). Cache Portal -> System -> License Usage -> Usage by User shows My Computer's IP address as making the connection rather than Host1. 

This normally doesn't cause any issues.

Hey Community,

We want to hear from you! Give us your feedback on the past InterSystems Analytics programming contest! Please answer some questions to help us improve our contests.

👉 Quick survey: InterSystems Analytics Programming Contest Survey

Hello,

I'm hoping to get some feedback on the OAuth process flow for Payer-to-Payer authorization.  It doesn't seem that "Authorization Code Flow" is needed as there will not be a need for a login.  I am leaning towards recommending "Client Credentials Flow", but wanted to get some community feedback before making a decision. I prefer to follow what the standard will be if possible.  What would you recommend?  Thank you in advance for your input.

I am facing below error after force stop the instance.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

method Export(savertn As %Boolean = 0) [ Language = objectscript ]

I am looking to export table to a text file in a programmatic way. I am not familiar with this class and how to invoke a "savertn" as input here.

Essentially I would like to Export Table (SELECT * FROM Table) and save it as a text file locally on Linux server. Is there any examples out there of that? Perhaps I need to save the query output to a global and then pass that input to the export?

So I am working with an inherited SQL query that queries 8 different tables. 5 of which have over a million records. 
I have 3 different servers. 

Server 1, Server 2 and Server 3. They all have the same data/tables/structure across all servers. 
Server 3 has an Iris database engine and the other 2 are Cache 2015.1.4.
I have a problem with views and performance across the servers being inconsistent. 
Thankfully Server 1 is the current live server that performs "fast enough".
Server 2 is being synced from Server 1 and acts as a report server.

And Server 3 is supposedly a new Live server.

Hey Developers,

The InterSystems Analytics programming contest is over. Thank you all for participating in our coding competition!

So it's time to announce the winners! 

A storm of applause goes to these developers and their applications:

Some of you might not be aware of this "Known Issue/Limitation" when defining a BPL-based Business Process.

And those who are not might have encountered this (somewhat "unpleasant" error):

Hi,

I have created new class in VSCode and upon saving it also saved in Cache DB but when I am deleting from VSCode it is not deleting from Cashe DB. How can I remove both class together?

Thanks

Hi,

How to send push notification from production in case of error ?

Thanks

Hi

I am running IRIS from docker container and I am not getting Web Terminal Option in management portal.

What to do for Web Terminal to be appear in management portal?

Thanks

I'm trying to save a list of AccessTokens a user for a specific user. This way I could present it together with other user-data.

I have tried calling ##class(OAuth2.Server.AccessToken).OpenByCode(authCode) from %OAuth2.Server.Authenticate's AfterAuthenticate() method. This only returns things like State and AuthorizationCode, but the AccessToken is empty at this point (afterwards it becomes filled out).

Is there a way to achieve storing the AccessToken as part of the login system?

This post provides useful links and an overview of best practice configuration for low latency storage IO by creating LVM Physical Extent (PE) stripes for database disks on InterSystems Data Platforms; InterSystems IRIS, Caché, and Ensemble.

Consistent low latency storage is key to getting the best database application performance. For applications running on Linux, Logical Volume Manager (LVM) is often used for database disks, for example, because of the ability to grow volumes and filesystems or create snapshots for online backups.

Newbie to working with silent installs.   is there a variable to pass in what/where you want to place your journal files?

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Analytics contest!

Date & Time: Friday, September 17, 2021 – 12:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.