The In() function in Ens.Util.FunctionSet is documented as searching for a value in a comma-delimited string.

There is undocumented additional functionality for custom separators.

If the items parameter has ",," (two commas) right before the last or second to last character in the string, then the following strings are used as separators.

If there is one character, then that is used as a separator:

w ##class(Ens.Util.FunctionSet).In("a","|a|f|d|c|a,b|a,b,c|,,|")
1

If there are two characters, then those are used as a prefix and suffix for values:

w ##class(Ens.Util.FunctionSet).In("a","<a><b><c><a,b,c>,,<>")
1

Please note that although there is an intention to document this in a future release at some stage, as it is not documented at the moment, it should be used with extreme caution - it may be removed from future versions without warning.

https://docs.intersystems.com/iris20223/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_smp#GSQL_smp_executequeryopts

The IRIS 2022.3 documentation has this:

• Execute Query in the foreground: a check box specifying whether or not to run the query in the foreground. Simple queries run in the foreground are often significantly faster than those run in the background. However, long queries run in the foreground may cause the Management Portal to be unresponsive during query execution. The default is to run all queries in the background.

There is a tool ("ompare") on the InterSystems Open Exchange for comparing environments. You might find that it does a lot of what you need.

https://openexchange.intersystems.com/package/ompare

(The author is @Alex Woodhead )

The online documentation is here:

• https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GREST

There is some training in the InterSystems Learning portal (you'll need to enrol/login):

• https://learning.intersystems.com/course/view.php?id=283

e.g.

• Academy: Implementing RESTful Applications - https://learning.intersystems.com/course/view.php?id=83
• Setting Up RESTful Services - https://learning.intersystems.com/course/view.php?id=776

You need to kill the pars parameter array and recreate it each time you use it. This is mentioned in the documentation:

https://docs.intersystems.com/csp/docbook/DocBook.UI.Page.cls?KEY=ESQL_parameter_overview

Important:

If you execute multiple queries that use the parameter array, kill and recreate the parameter array before each query.