Request properties value always UID

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?