I created attributes for idea object which are fed by dynamic niku queries from srm_resources table. For example the request goes to sales manager (which is an attribute of idea) and its query is like select from srm_resources whose primary role is sales manager.
In process of idea approval, I would like to send an action item to sales manager. But in assignees fields I cannot see Sales manager.
I attach the related screenshots,
I will be pleased if you lead me to a solution,
I think, you should have srm_resources.id as hidden key in the lookup.
Also, try associating resource object in lookup properties.
Hi, although SRM_RESOURCES.ID is defined as hidden key, it was still not shown in resource field list. I added Resource object on lookup properties and it worked perfect. Thank you.