Hi,
yes, you can do this with Table JX.
If you didn't have date it would be more easier, you would just write in admin area in where section (article that contains this grid is in registered area)
You can also write something like this:
WHERE id=@user_id AND latest=True
(if you have column latest that describes the latest row for each user)
But if you don't have the latest column you can create sql view that filters only latest row for each user:
Something like this:
CREATE VIEW myLatestDataForEachUser AS
SELECT id, max(dateColumn)
FROM myTable
GROUP BY id
You display then this view with Table JX and write in WHERE section of admin area:
Best regards,
Viljem
