As to Supported Server Platforms, it might be even Ubuntu 18.04 LTS for x86-64 rather than 16.04.  

Question was about Ensemble initially which supports 16.04. InterSystems IRIS Supports 18.04.

And what about RHEL 8? Which IRIS version will be supported under this OS?  

Asking @Andreas Dieckow to comment.

Yes, looks like no exception is thrown.

Try this query:

sql = "SELECT 1"  

Any exceptions on stack?

import sys, traceback
traceback.format_exception(sys.last_type, sys.last_value, sys.last_traceback)

Can you run SELECT 1 query?

To answer that, before query is compiled all arguments are parametrized:

like 'text%'

becomes

like ?

so we can't really replace LIKE with %STARTSWITH on code generation step (there's a brackets argument specification I suppose).

Share a code sample please?

One other thing: both methods should be either methods or classmethods.

%GetComponentById and GetComponentById are different methods.

Do you want to call %GetComponentByID  of a parent class?

You can do it like this:

set result = ##super(args...)

Documentation.

1 sql request per property, or only one "big" sql request ?

How are you planning on merging distinct requests? One case I've seen where you need something like this is when you want to get a valid subset of filter values (which would return 1+ rows) for each next filter, but in the end all filters are still combined into one query.

You need to decide on:

• what predicates are allowed (=, %STARTSWITH, <, >, LIKE, IN, ISNULL, BETWEEN)
• what logic operations are allowed (OR, AND, NOT)
• are nesting and brackets allowed
• is it free form (auto constructed from metadata) or fixed (from a pre-set list of properties).

After that on a client you construct filter object, validate and parse it on a server and execute the query.

If you're not satisfied with performance, server-side part can be tweaked without modifying the client.

what's the disadvantage of using lot of indexes ?

INSERTS/UPDATES are slower, more space is needed.

Sure. I think it's the key formatting error.

Can you try to bake the key into the class like this and use it instead of a file?

Here's an article on RSA encryption with InterSystems IRIS.

Check this question.

There could be two issues:

• Race condition
• SQL error

For race condition you need to compare the time when the query is executed to the time when Workflow objects are created.

For sql construct query as a string and trace that.

You can replace

do myStream.Rewind()
set len = 32000
While (len > -1) {
    set sRead = myStream.Read(.len)
    do httpRequest.EntityBody.Write(sRead)
}

With

set sc = httpRequest.EntityBody.CopyFrom(myStream)

Okay and how does the XML look like?

After you compiled

Property PartoNo As %String;

what error are you getting?

Tasks contain session reference so you can simplify your query to:

SELECT
TaskStatus_Request As ID
FROM EnsLib_Workflow.TaskResponse
WHERE TaskStatus_SessionId = ?

For debugging: add hang 1 before executing SQL. What happens?

What do you want to do with ID?