Need syntax help on FIND inside a reference attribute

tford

I have a BO: Country that has a multiple allowed reference attribute named ControlRecords -- ControlRecords refers to the BO: Control. One attribute of Control is: FiscalYearName.

I need to find all instances of Country where Control.FiscalYearName is equal to LoggedInSystemUser.FiscalYear.

Can someone help me with the syntax? I can't seem to get it right.

Thanks,
Tom

tford

PS - Since Country relationship to Control is "multiple allowed", I want to find all Country BOs where AT LEAST ONE the related Control.FiscalYearName is equal to LoggedInSystemUser.FiscalYear.

Tom

aware_support2

You could try a query with subquery:

FIND Country WHERE EXISTS Control WHERE (Control IN Country.ControlRecords AND Control.FiscalYearName = LoggedInSystemUser.FiscalYear)

tford

You are AMAZING!!! Perfect!

Thanks much!
Tom