I made several filtering fields on the page which get some values from db.
For example - I have 5 fields... when i change 1 the others 4 are filtered and show less results for filtering.
How can I do this with xPDO model whith 1 query not 4 for only filter + 1 for content?
?? what kind of fields? can you tell a bit more of your scenario?
well i got category,vendor,name,attribute,subattribute (for example untensils,phillips,vacuum-cleaner,bag,wooden-bag)
so on the page i got several filters, if i put philips as a vendor, all other filtering fields show info only connected with phillips...
but the main problem is that attr and subattr in the 1 table and the others in the 2nd
I’m still not sure, are you talking about resources and TVs or about custom-tables?
Can you show some example records of your table(s) and perhaps an example-result of your query, for what you are after?