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

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?

Parents
  • 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.

Reply
  • 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.

Children