Last connection of item's creator

Hi,

As in the title of this thread, I would like to show, on a category list of items, the last connection of the creator's item.
I've tried to add a date field, but I'm unable to show the last connection of the creator (not surprising).

How can I achieve that ?

Thanks !

hello, last connexion last edition ? where ?

Each user has a "last connected" field.
I would like to show for any item, the item's creator corresponding field.

but you want to mix an user table data to item type data ...

That's why I need some help.
Is that even possible ?

Hello

you can even do it inside template files

item.php
category_items.php

loop through $items to get put ->created_by into an array

then you can make a single query to get the needed data from DB table
#__session