Hi,
A client is needing to search a long List View of a table which contains a Related Records field. A few tries with the Advanced Search editor have either caused MySQL errors or return 100% of all records in the table.
I'd like to do something like this in the Advanced Search area:
Purchases:|relatedRecords001:productName|query
Where 'relatedRecords001' is the joined table and productName is the field to search on.
Any idea on how I might do this successfully?
Thanks,
J.