[TYPO3-project-formidable] Search in mm-related table

[Albert van der Veen]

Don't bother about this post, I wasn't thinking clearly :)
Search can be done by joining the tables and using the appropriate 
tablename-prefixes in the "search on" fields.

Albert

On 2008-04-17 12:41:13 +0200, Albert van der Veen 
<albert.van.der.veen at xs4all.nl> said:

> Hi all,
> 
> I'm wondering if there is a way to search on data from an mm related 
> table. To clarify what I mean:
> 
> Suppose we have tables (only showing tablefields that are relevant to 
> the example, left out details):
> 
> - user_publications (uid, title, description, termref)
> - user_terms (uid, term)
> - user_publications_terms_mm (uid_local, uid_foreign)
> 
> Now I would like to have a searchform that shows a freetext field (to 
> search in title and description field of the pub) and a dropdown of 
> terms.
> If the uid's of the terms are stored as a commaseparated list (in 
> termref), it is not a problem to do this. But how to setup the form in 
> the case of using the mm table?
> 
> grtz,
> Albert