Hi Klas
INFO
I have a table (#__cck_map)
In this table I store a content types ID, and the ID of another content that it references.
i.e. My Shoes [id of 456] references Sandals [id of 12], Boots [id of 34] etc.
#__cck_map table would look like this:
id - fk
456 - 12
456 - 34
So..... in my search form for 'My Shoes' I use the Search - Join Field.
However, because there are multiple instances of '456' in #__cck_map, the results show a total based on each occurrence.
I am looking to add DISTINCT to the query.
QUESTIONS
1: Apart from a free standalone query, is there another way to add DISTINCT?
2: Should Conditionals work on Search Join field? <- of course not!!! it is not rendered
Thanks for any tips
Jon
You can add "group by" with search query
Oh yeah
Good idea
No sorry
can’t help as no longer have access to deprecated website’s accompanying files
The only way I solved it was by creating query one line at a time, viewing the outputted query (Joomla! debug mode perhaps?) and amending accordingly.
Kinda glad I no longer have to struggle with guessing how to use each and every Seblod field/plugin :)