I think it should work if you add a field with Standard-Free-databsecolumn storage for each column you wish to display.

Thanks for your advice, Klas.

The situation is even more complicated because I need to dispaly Article titles of joined #__content table. That meens I need 2 article titles on one row. I am almost there, just the last step.

After some experimentation I've been able to successfully join another #__content table (using the Query AKA in Join table plugin - eventhough I have no idea what is the AKA for) in Join Table Plugin

I was also able to select the column itself  appending the SELECT using Search Query Plugin

So the final request is perfectly OK!

I just have no idea how to make the field display in the list!

When I create a field with the sotrage Standard FREE title (#__content), it displays the first article title, not the joined one.

Thanks again for a possible help.

Michal

You need to add new text field to the list with storage Standard-Free-test_def_firma

Just figured it out today as I need it for one of my projects :)

I need something similar: I'd like to join 2 tables. SQL looks fine, searching in the second table for a field's value works. How can I show this value in the list item?

Hello deralex.

Maybe Klas (or somebody else)  will correct me but what I Iearned at this forum was, that this is not possible. Searching and rendering are two different thinks. As far as I know the only way to get value from joined table is using SQL field. 

Michal

to iliil i think no. SQL fiel must generate +1 sql query for every record. Then nothing using join table.field 

Hi. 

I ask to help to understand not normal delivery of a field from table LEFT JOIN

What I did 

1. compiled LIST SEARCH on the basis of FREE 

2. displayed the fields of interest, they are all from GROUP_CHILDREN 

3. Attached through the plug-in SEARCH JOIN table CCK_CORE 

Now I want to output the field CCK_CORE in LIST VIEW I receive here such here result: 

where the CCK field took the values article, workbook, article (ID in title colum this my mistake, trash of my more experiments)(right title CCK :)

4. looked up joomla requests and found this 

5. Now the result is compared 

The last query returns the correct values of the attached fields I have no idea why this is so? 

and how to display the attached fields correctly. studied the response of KLAS from the post above: "I think it should work if you add a field with the standard-free-databsecolumn storage for each column you wish to display." but the result is such, incomprehensible 

1. Help to understand the result. 

2. And how to get it right.

Thank you.

after one more experiment I am surprised even more :) I have removed any my fields plugin join but in inquiries seblod I still see

leaves obvious communication of table1.id=cck_core.pk seblod carries out now always? but here with a conclusion of fields there was still not a clear situation. I will be grateful for the comment under my assumption

To show values retrieved using search JOIN you will also need search query field so you can add a column to the WHERE part with some unique alias, e.g. to display t1.id (t1 is an alias of your #__cck_group-children table) you would add "t1.id as tid" to the where part. Then you can show tid value in the list by adding a text field with storage Standard-Free-tid (don't select any table in the last dropdown!).

Klas thank you for answer!)

Is it possible to use the field for AND in the SEARCH JOIN plugin to save on the lines of code? 

Does the addition of the SEARCH QUERY plugin cause an excess of sql requests in the size of [main resolve] * [searchquery for field]? 

could you briefly describe the place of SEARCH QUERY in the life cycle?

Thank you for attention!