Picker Search Mode per Source Data Column

3

Hi Kamil,

I don't think this will have any meaningful impact from a performance perspective.

The searching for start/contains happens after the data source has returned all available data. This means, that all data is already in memory.

While it's not possible to pass the filters to REST data sources at all, I don't see an option for SQL queries.

While it may work out somehow to add the condition for simple SQL statements like this:
Original query:
select WFD_ID from WFElements where WFD_DTYPEID = 1
->
Using filtered column
select WFD_ID from WFElements where (WFD_DTYPEID = 1) and (picker column like 'search value%')

I don't see a reliable option for complex queries where UNIONs are used or CTEs.
OK, for unions you could wrap the whole result in another SELECT again.


select * from (
select WFD_ID from WFElements where WFD_DTYPEID = 1
union
select WFD_ID from WFElements where WFD_DTYPEID = 2
) as temp where(picker column like 'search value%')


But for CTEs?

Best regards,
Daniel