Hi Dave_3.0 - the query is simple one - just reading list of projects were the project manager is particular resources.
select inv.id
, inv.name
, inv.code
from inv_investments inv
join srm_resources res on res.user_id=inv.manager_id
where (res.unique_name= '***' or res.unique_name='YYY')
and inv.odf_object_code='project'
and inv.is_active=1
I've mapped it to a attribute in a custom object and the search is not working on the attribute.