9.0 LTS CU3
I have a request parameter as a table lookup:
Data Source | Table |
Table column (query) | ADSContainer - CanonicalName |
Display pattern | %CanonicalName% |
Condition (query) | isnull(CanonicalName, '') LIKE (SELECT Value FROM DialogConfigParm WHERE FullPath = 'Custom\Integrations\CyberArk\ServersCanonicalProd') OR isnull(CanonicalName, '') LIKE (SELECT Value FROM DialogConfigParm WHERE FullPath = 'Custom\Integrations\CyberArk\ServersCanonicalNonProd') |
However, when I try to the "Value" from this in scripted validation, it is always UID_ADSContainer resulting in all sort of errors (including as a result of the OOTB query constructs).
2025-04-07 10:56:41.9815 DEBUG ( SqlLog ) : (< 1 ms) - select 1 where exists (select 1 from ADSContainer where ((CanonicalName = N'2c8beab9-1514-4ec7-b095-371c1308fde8') and (isnull(CanonicalName, '') LIKE (SELECT Value FROM DialogConfigParm WHERE FullPath = 'Custom\Integrations\CyberArk\ServersCanonicalProd') OR isnull(CanonicalName, '') LIKE (SELECT Value FROM DialogConfigParm WHERE FullPath = 'Custom\Integrations\CyberArk\ServersCanonicalNonProd'))))
Is this meant to be how it works?