1283 Posts
Bucklash
6 years ago
Topic

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

Get a VIP membership
4229 Posts
Kadministrator
6 years ago
1
Level 1

You can add "group by" with search query

1283 Posts
Bucklash
6 years ago
0
Level 2

Oh yeah

Good idea

151 Posts
jimenaes
1 year ago
1
Level 1

Hi, Bucklash

This is exactly what I need, but I don't understand how to fill the search join field. Would it be possible for you to show me a picture of how you filled it out?

Thanks

1283 Posts
Bucklash
1 year ago
0
Level 2

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 :)

Get a Book for SEBLOD