Issue Using Request Property in Subquery with Parameter Filtering

Hello,

We are using "request properties" for our requests, but we are encountering an issue with retrieving a parameter through a request property.

For example, we have two parameters:

The first parameter lists all ADSDomains.
The second parameter lists ADSAccounts based on the selected ADSDomain.
When I select the table column as UID_ADSDomain, I can use the parameter in the ADSAccount WHERE clause like this:

UID_ADSDomain = $PC{Parameter_ADSDomain}$


This works correctly.

However, when I change the table column to cn instead of UID_ADSDomain, and try to use the parameter like this:

UID_ADSDomain = (SELECT UID_ADSDomain FROM ADSDomain WHERE cn = $PC{Parameter_ADSDomain}$)


it doesn’t work.


I don’t understand what I’m doing wrong. Could you help me identify and fix the issue?

Best Regards,

Volkan Ceylan