? No Code Attached Yet
avatar nasirkhan
nasirkhan
9 Nov 2022

In the category list type menu item, I can only show the list of Article names tagged with a specific article. I want to show the Category Names along with the article name.

I found that there is category Id as core_catid and I can write a query to get the name of the related category. But I would like to know the recommended way to get the category name. For me, the number of queries on the tags page is already high, so what would be the optimized way to get that data?

Additional context

Related to #39177

avatar nasirkhan nasirkhan - open - 9 Nov 2022
avatar joomla-cms-bot joomla-cms-bot - change - 9 Nov 2022
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 9 Nov 2022
avatar nasirkhan nasirkhan - change - 9 Nov 2022
Title
Show Category Name in the Tag list viwe
Show Category Name in the Tag list view
avatar nasirkhan nasirkhan - edited - 9 Nov 2022
avatar chmst
chmst - comment - 15 Nov 2022

In general we use inner joins. If you have an article, you also have the catid and can get the categoryname with a join.
I am not in the code at the moment - take this carefully, it might be wrong

avatar Hackwar Hackwar - change - 22 Feb 2023
Labels Added: ?
avatar Hackwar Hackwar - labeled - 22 Feb 2023

Add a Comment

Login with GitHub to post a comment