OIM 9.2 / Request Properties / Condition (query) depending on another request property

Question

Hi there, I am trying to do this: 
 User is ordering a new Exchange Mailbox. He has to choose the Exchange Organization (UID_Ex0Organization). In an another property he can choose ADSAccounts to set the permissions (one property for FullAccess- Permission and one for SendAs-Permission). I would like to filter the ADSAccount-Objects depending on the choice in Exchange Organization. 
 The condition could be something like this: 
 UID_ADSAccount IN (SELECT UID_ADSAccount FROM EX0MailBox WHERE UID_EX0Organization = '%UID of the Exchange Organization%') 
 How can I use the value of the property Exchange Organization in the condition?

Jos Groenewegen · Accepted Answer

Hi Paul, 
 Assuming you're using the (new) request properties it's described how they work in some detail here: Identity Manager 9.1 - IT Shop Administration Guide (oneidentity.com) 
 
 Specifically I think you want to do / use the following (see the bold bit);

Condition (query)

Additional data for the data source Table . 
 Limiting condition (Where clause) for selecting the parameter value using a table column. The user can select a value from the result set. If the parameter is multi-value, you can select several values from this result set as well. 
 You can reference other parameters in the condition using the following syntax: 
 $PC(<Parametername>)$

Endpoint Privilege Management

OIM 9.2 / Request Properties / Condition (query) depending on another request property

Top Replies