Resource fields in action items

[Anon Anon]

Hi all,

 

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,

 

Best regards, 

Attachment(s)

Resource fields.docx   507 KB 1 version

[Sridhar Bandaru]

I think, you should have srm_resources.id as hidden key in the lookup.

Also, try associating resource object in lookup properties.

[Anon Anon]

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.