FilterDef with Array

BIZ TMS Aurelius
1

Hi,

I would like to build a filter with a IN SQL Statement, e.g.

  [FilterDef('Folder', '{FolderID} IN (:FolderID)')]
  [FilterDefParam('Folder', 'FolderID', TypeInfo(TArray<Integer>))]
  [Filter('Folder')]

But I didn't find any possible solution for this.
I can build a Subselect, in the filter for this, but I think the performance will be increase.

Any suggestions for this?

Thanks in advance.

2

That is not possible indeed. You have to use single-valued parameters.

3

there are no changes to this behaviour right now, right?

I would need such a possibility to...
My solution looks like this right now:
'{Kind} not in (select string_to_table(:Kind, '',''))'
but this is postgres special, so it would be nice if TValue-arrays would be supported...

4

No, it stays the same.