? ? Pending

User tests: Successful: Unsuccessful:

avatar brianteeman
brianteeman
20 Dec 2019

Pull Request for Issue #26475.

Summary of Changes

None of the sorting worked - either by clicking on the column title or by selecting from the dropdown

Testing Instructions

Apply pr. The table is now sorted by ID by default and you are able to change the sort order to ID.ascending and ID.descending

Default sort

This is now working correctly - the value was wrong

Sort by title

As far as I can tell you can never sort on the "title" because its a value created by the tmpl so that is removed from the column title and the dropdown

Sort by component

The same for component. Although here it has only been removed from the title as it wasnt present in the dropdown

Sort by language

Never going to b3e possible with the architecture of this component

Sort by id

This is now working correctly - the value was wrong

Accessibility

The essential sr-only text that indicates the sort order is now correct as it has a value

avatar brianteeman brianteeman - open - 20 Dec 2019
avatar brianteeman brianteeman - change - 20 Dec 2019
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 20 Dec 2019
Category Administration
avatar brianteeman brianteeman - change - 20 Dec 2019
Labels Added: ?
avatar Quy
Quy - comment - 20 Dec 2019

With one language, the language header is clickable but not in the dropdown.

27325

avatar brianteeman
brianteeman - comment - 20 Dec 2019

Don't think I can really do anything about that other than remove all language sorting. It's really a clustrfck the way languages are in this component

avatar 810 810 - test_item - 23 Dec 2019 - Tested unsuccessfully
avatar 810
810 - comment - 23 Dec 2019

I have tested this item ? unsuccessfully on 5384221

Sort id's not working.

com_config.test_mail still at top with multiple id's (Kunena 6.0 nightly builds has 3 records)


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

avatar brianteeman
brianteeman - comment - 11 Mar 2020

conflicts resolved

avatar brianteeman
brianteeman - comment - 27 Mar 2020

any reason why this isnt being merged?

avatar 810
810 - comment - 27 Mar 2020

still not working for me the sorting.

avatar brianteeman
brianteeman - comment - 27 Mar 2020

i can see the problem but I cant see the fix :(

avatar davidemessia
davidemessia - comment - 18 Apr 2020

Hi Brian
I'm sorry, but I'm a little confused here.

  • if i click on arrow near by "id" i see that the arrow change and also change the text in the box
    screen shot 2020-04-18 at 10 31 50

  • if i click on arrow near by "templates" i see that the arrow change

  • in language sort if i choose "ALL" i see the text "No Matching Results" but there is the default one installed
    screen shot 2020-04-18 at 10 22 21

  • In the ID field I see that "com_config.test_mail" appears instead of a number screen shot 2020-04-18 at 10 19 26
    in the template column see that the English flag appears, but I think the correct label is "language"
    screen shot 2020-04-18 at 10 18 20

  • i cannot view any arrow near by the component label
    screen shot 2020-04-18 at 10 34 45

could you please help me ?

thanks a lot
Davide


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

avatar davidemessia
davidemessia - comment - 18 Apr 2020

I apologyze it seems that i've done some error in using the editor hopefully now it will be more clear

Hi Brian
I'm sorry, but I'm a little confused here.

.: ** ## if i click on arrow near by "id" i see that the arrow change and also change the text in the box**
screen shot 2020-04-18 at 10 40 07

.: ** ## if i click on arrow near by "templates" i see that the arrow change**
screen shot 2020-04-18 at 10 49 38

.: ** ## in language sort if i choose "ALL" i see the text "No Matching Results" but there is the default one installed**
screen shot 2020-04-18 at 10 44 01

.: ** ## In the ID field I see that "com_config.test_mail" appears instead of a number**
screen shot 2020-04-18 at 10 45 18

.: ** ## in the template column see that the English flag appears, but I think the correct label is "language"**
screen shot 2020-04-18 at 10 45 58

.: ** ## i cannot view any arrow near by the component label**
screen shot 2020-04-18 at 10 46 57

could you please help me ?

thanks a lot
Davide


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

avatar ceford ceford - test_item - 6 May 2020 - Tested successfully
avatar ceford
ceford - comment - 6 May 2020

I have tested this item successfully on 80d780c

The sorting works according to the changes in arrows and Sort Table drop-down. I think that whether the ID should be a number is a separate issue.


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

avatar pabloarias
pabloarias - comment - 4 Jun 2020

After apply this path I see that I can order by template and id. But if I click on column header, I can see page reloading but order doesn't change.


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

avatar bonzani bonzani - test_item - 13 Jul 2020 - Tested successfully
avatar bonzani
bonzani - comment - 13 Jul 2020

I have tested this item successfully on 80d780c


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

avatar roland-d
roland-d - comment - 1 Aug 2020

@brianteeman Can you please fix the conflicts?

avatar brianteeman
brianteeman - comment - 1 Aug 2020

Closing as cant be fixed without rewriting the component

avatar brianteeman brianteeman - close - 1 Aug 2020
avatar brianteeman brianteeman - change - 1 Aug 2020
Status Pending Closed
Closed_Date 0000-00-00 00:00:00 2020-08-01 18:18:00
Closed_By brianteeman
Labels Added: Conflicting Files
avatar brianteeman brianteeman - change - 14 Mar 2021
Status Closed New
Closed_Date 2020-08-01 18:18:00
Closed_By brianteeman
avatar brianteeman brianteeman - change - 14 Mar 2021
Status New Pending
avatar brianteeman brianteeman - reopen - 14 Mar 2021
avatar brianteeman
brianteeman - comment - 14 Mar 2021

RE-opened and conflicts fixed as requested

avatar joomdonation
joomdonation - comment - 14 Mar 2021

@brianteeman Could you please try this PR brianteeman#120 on your branch? I think it should handle ordering of mail templates properly with that change

avatar joomdonation
joomdonation - comment - 14 Mar 2021

@brianteeman Please review and merge this PR brianteeman#121 . After that, I think we are done with this PR

avatar brianteeman
brianteeman - comment - 14 Mar 2021

@joomdonation Now there is only sorting on the ID. Why not on the component and title?

avatar joomdonation
joomdonation - comment - 14 Mar 2021

@brianteeman That's by design of this component. We store language item in database (I think you looked at the data in table #__mail_templates already), however, what is being displayed is language data from language files (for these columns)

So if we sort by these columns, the data will be stored by language key, while what users see is actually the translated language item and they will see that it is not in right order. I hope I understand and explain it clear enough.

avatar brianteeman
brianteeman - comment - 14 Mar 2021

That's why I closed this originally

Closing as cant be fixed without rewriting the component

I dont really consider removing the sorting as a fix.

But could you check workflows please as I am pretty sure that also stores language constants inthe database and still has sorting

avatar joomdonation
joomdonation - comment - 14 Mar 2021

To be more clear, if we make the Title column sortable, the system will sort data base on language key such as COM_ACTIONLOGS_EMAIL_SUBJECT, COM_CONFIG_SENDMAIL_SUBJECT... instead of what is being displayed to end users at the moment Actionlogs: Notification Mail, Global Configuration: Test Mail ....

This is something I'm afraid of we could not fix.

avatar joomdonation
joomdonation - comment - 14 Mar 2021

For now, maybe we can leave this PR as how it is. At least the sort by ID column works properly now. If we can come up with a solution for sorting other columns, we can open another PR in the future.

avatar brianteeman
brianteeman - comment - 14 Mar 2021

I suppose this at least works even if it is not optimal.

avatar joomdonation
joomdonation - comment - 14 Mar 2021

Agree. Maybe you can update testing instructions so that we can test this PR and get it merged?

avatar brianteeman brianteeman - change - 14 Mar 2021
The description was changed
avatar brianteeman brianteeman - edited - 14 Mar 2021
avatar brianteeman
brianteeman - comment - 14 Mar 2021

done

avatar joomdonation joomdonation - test_item - 14 Mar 2021 - Tested successfully
avatar joomdonation
joomdonation - comment - 14 Mar 2021

I have tested this item successfully on 82fcc91


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

avatar alikon alikon - test_item - 14 Mar 2021 - Tested successfully
avatar alikon
alikon - comment - 14 Mar 2021

I have tested this item successfully on 82fcc91


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

avatar alikon alikon - change - 14 Mar 2021
Status Pending Ready to Commit
avatar alikon
alikon - comment - 14 Mar 2021

RTC


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

avatar richard67 richard67 - change - 14 Mar 2021
Status Ready to Commit Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2021-03-14 12:21:50
Closed_By richard67
Labels Added: ?
Removed: Conflicting Files
avatar richard67 richard67 - close - 14 Mar 2021
avatar richard67 richard67 - merge - 14 Mar 2021
avatar richard67
richard67 - comment - 14 Mar 2021

Thanks!

avatar brianteeman
brianteeman - comment - 14 Mar 2021

thanks everyone

Add a Comment

Login with GitHub to post a comment