is it possible for request properties to access the value of another parameter and use it within a value definition condition (sql where clause)?

Question

For my custom request property I have a set of several parameters. 
 The first one called "Department" is a user prompt for a department (uid_department) and the second one called "Person" is another user prompt for an identity (uid_person). 
 I would like to pre-filter the selectable users for the second parameter according to the department selected in the first parameter. 
 Is there a way I can refer to the value of the "Department" parameter as variable in the condition (sql query) field of the "person" parameter?

Barry Jackson · Accepted Answer

Hi, 
 You don't say if these are new-style or old-style request properties. 
 For old-style you refer to the value in the column in ShoppingCartItem that stores your parameter value, so in your SQL for the Person parameter you would refer to %UID_Department% (if you have a column called UID_Department on ShoppingCartItem/PersonWantsOrg). 
 For new-style you refer to the value of parameter 1 by name. So if parameter 1 is called 'deptparam' you can reference it's value in parameter 2 using $PC(deptparam)$ 
 HTH, Barry.

is it possible for request properties to access the value of another parameter and use it within a value definition condition (sql where clause)?

Top Replies