Hi,
Here is an example how I did it for the case of joomla articles table (jos_content).
Unfortunately mysql does not support a subselect in 'from' clause at creating a view. This is why we need to create two views. First one selects the last date and the category for each category.
CREATE VIEW mxHelpView AS
SELECT catid, MAX(created) AS LastDate
FROM jos_content
GROUP BY catid
With the help of this view we select the whole records from the original table
CREATE VIEW LatestArticles AS SELECT jos_content . *
FROM jos_content
INNER JOIN myHelpView ON myHelpView.catid = jos_content.catid
AND myHelpView.LastDate = jos_content.created
Change the names of tables and fields according to you schema and use the above commands to create the views. As next step you use the second view to display it with Card View JX.
I hope it helps.
Regards,
Tomaž
