Security Software

Hello OIM gurus,

I have a lookup field in my process form and I am entering the properties of this field with the design client, such as Column Names, Captions, widths, Lookup Query etc. I would like to make the Lookup query a little more flexible in that it can take in different lookup codes based on some criteria. To be specific, I would like the lookup query specific to each resource.

A sample of my query is: 'select v.lkv_encoded,v.lkv_decoded from lkv v, lku u where u.lku_key=v.lku_key and u.lku_type_string_key='<my lookup code>'

I have lookup codes that are specific to each resource and I would like to use these codes here. I see some things like $Process Data.xxx$ and I am not sure how to use this or change the lookup code dynamically. Or is there a totally different way to do this?

Thanks in advance
-SK