Map Notes plugin and Databases Join Plugin - Problems with display data

[nemanja]

Can I use the Database Join Plugin to transfer the DATA from one table (map_notes_ table ->(Notes Plugin)) to another table and display that data in the List.

 

[cheesegrits]

No. The join element only records the foreign key.

To display other data from one table in another, you need to use a List join.

-- hugh

 

[nemanja]

No. The join element only records the foreign key.

To display other data from one table in another, you need to use a List join.

-- hugh

I have table map_notes with ID, MAP_ID, DATE_TIMe, NOTE, USER_ID (notes plugin)
and
table client_manager

I want comments written by USERS about the clients to display in client_manager List.

I tried with list join but not show the data (see attach).

Or to use somthing like this:

$db = JFactory::getDbo();
$myQuery = 'SELECT
a.note
FROM map_notes AS a
INNER JOIN client_manager AS b on (a.map_id = b.id) ORDER BY a.date_time DESC
';
$db->setQuery($myQuery);
$testcomm = $db->loadResult();
return $testcomm;

but problem is how to use USERID and MAP_ID from map_notes table and ID from client_manager table.