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


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:

Where 'relatedRecords001' is the joined table and productName is the field to search on.

Any idea on how I might do this successfully?


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


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.

Greg Thomas

PHP Programmer - interactivetools.com