17.12.2025
09:24
Quite often we have the use case, that we need to provide a personalized dataset. With SQL data sources we do have the possibility to use calculated fields with a subquery. Which could end up with performance issues when using large datasets. As an example this calculated column returns 1 if the first letter of the COS_ExtensionAttribute05 field in the COS table matches the value of the dataset. The result can then be used to filter by <my> data.
(SELECT IIF(LEFT(COS_ExtensionAttribute05, 1) = {WFCONCOL:444} OR {WFCONCOL:444} = 'Z', 1, 0) AS Meine FROM CacheOrganizationStructure WHERE COS_BPSID = '##currentloginname##')
To avoid performance issues, it would be great if we had the possibility to use a business rule to provide a filter value.
Maybe the operators of the standard filter could be extended with an "Is in" option and the value with the possibility to also use a business rule instead of a fixed value? It should be available for SQL and SOLR based reports.
