3 posts by 2 authors in: Forums > CMS Builder
Last Post: September 12, 2012   (RSS)

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.

Re: [InHouse] Searching Related Records from List View Advanced Search

Hi,

The ability to search related records from list view advanced search isn't currently supported by CMS Builder. But we could create a custom plugin to create this feature. If you contact consulting@interactivetools.com explaining what you need they will be able to provide you with a quote.

Thanks
Greg Thomas
PHP Programmer - interactivetools.com