Need syntax help on FIND inside a reference attribute

tford · Post by **tford** » Wed Jan 16, 2008 8:29 pm

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 · Post by **tford** » Wed Jan 16, 2008 9:37 pm

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 · Post by **aware_support2** » Wed Jan 16, 2008 11:35 pm

You could try a query with subquery:

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

tford · Post by **tford** » Thu Jan 17, 2008 12:24 am

You are AMAZING!!! Perfect!

Thanks much!
Tom