i have a bunch of documents each of which has 2 drop down list TVs for "category". i need to have a search feature where i show documents from a selected "category", therefore my search query needs to reference the modx_site_tmplvar_contentvalues table. what would be the best/most efficient way of doing this?
- get all the content IDs matching the appropriate TV and then get the content recordset?
- create a custom SQL command with LEFT JOINS etc to get the recordset?
or is there an easier way to do this? or can Ditto do this?
thanks guys!
