AnsweredAssumed Answered

Team Member List - Dynamic Lookup - Subobject from Project

Question asked by brenochuba- on Dec 14, 2010
Latest reply on Dec 15, 2010 by Dave
Hi,

I need to create a LOOKUP attribute inside a sub-object from Project (Master Object) that show the team member list of the project on I create the sub-object instance.

I was trying to use the out-of-box Lookup: Browse Team Members for a Project, but with NO SUCESS:

SELECT @SELECT:resources.id:prid@,
@SELECT:resources.first_name:first_name@,
@SELECT:resources.last_name:last_name@,
@SELECT:resources.full_name:full_name@,
@SELECT:resources.unique_name:unique_name@,
@SELECT:resources.unique_name:UNIQUE_CODE@
FROM inv_projects projects, srm_resources resources, prteam team
WHERE team.prprojectid = @where:param:xml:integer:/data/id/@value@
AND @FILTER@
AND team.prprojectid = projects.prid
AND team.prresourceid = resources.id


1. I have to create a dynamic lookup
2. I have to create a lookup attribute in sub-object

Regards,

Outcomes