J3 Issue ?
avatar hytsch
hytsch
3 Sep 2018

On the Category list in the Administrator we can sort by ID, Title, Status, Access Leve, Language..., but not by Number of Articles (published, depublished, archived, deleted). It was fine to hav the sort functionality to.

screen shot 2018-09-03 at 06 21 46### Expected result

Actual result

System information (as much as possible)

Additional comments

avatar hytsch hytsch - open - 3 Sep 2018
avatar joomla-cms-bot joomla-cms-bot - labeled - 3 Sep 2018
avatar franz-wohlkoenig franz-wohlkoenig - change - 3 Sep 2018
Category Administration com_categories Administration com_categories Feature Request
avatar brianteeman brianteeman - change - 3 Sep 2018
Labels Added: J3 Issue
avatar brianteeman brianteeman - labeled - 3 Sep 2018
avatar franz-wohlkoenig franz-wohlkoenig - change - 10 Sep 2018
Status New Information Required
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 10 Sep 2018

can one please answer this Feature Request as its open for a Week having Status "New"?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/21970.

avatar infograf768
infograf768 - comment - 10 Sep 2018

Looking at the existing code to get these values, not sure we can sort these.

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 10 Sep 2018

@infograf768 thanks for answer @hytsch

avatar hytsch
hytsch - comment - 10 Sep 2018

OK, thank You.

avatar franz-wohlkoenig
franz-wohlkoenig - comment - 10 Sep 2018

@infograf768 Issue close or do you look on the Code?

avatar HLeithner
HLeithner - comment - 10 Sep 2018

The current implementation doesn't allow us to sort for these counts, it would need a rewrite of the SQL queries to support this, this could have a bigger performance impacted.

Additionally it get more complex with J4 and the new workflow. I would suggest to close this, if someone contribute code we can reopen it.

avatar hytsch
hytsch - comment - 10 Sep 2018

Thats's ok, thank You.

avatar hytsch hytsch - change - 10 Sep 2018
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2018-09-10 14:33:39
Closed_By hytsch
avatar hytsch hytsch - close - 10 Sep 2018
avatar ggppdk
ggppdk - comment - 10 Sep 2018
  • Currently these columns are calculated only for the categories of the current page

if you would want to sort by them then you would have to move their calculation inside the main query
and calculate these for all website categories.

On website with a few thousands of categories this would be a considerable performance
a slowdown not only when sort by them but also when you do no sort by them

(or to avoid performance loss, you would have to keep old way when not sorting and do an alternative a little different and slower SQL main query when sorting by one of these columns)

Add a Comment

Login with GitHub to post a comment