0012644: Sorting of certain columns is not possible #6256

Closed
Gloirin opened this Issue Jun 9, 2018 · 4 comments

Comments

Projects
None yet
1 participant
@Gloirin

Gloirin commented Jun 9, 2018

Reported by apvit on 14 Feb 2017 14:29

Version: 2016.09.7 Community Edition

Sorting of the following columns is not possible:

  • From (Email)
  • Subject
  • To
  • From (Name)
  • Sender
  • Sent
  • Received

Steps to reproduce: Click on column-headers

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 11, 2018

Comment posted by apvit on 20 Feb 2017 15:48

Sorting on all fields is probably not necessary.
Minimum Fields are:

  • From (Name)
  • To
  • Sent
  • Received

Gloirin commented Jun 11, 2018

Comment posted by apvit on 20 Feb 2017 15:48

Sorting on all fields is probably not necessary.
Minimum Fields are:

  • From (Name)
  • To
  • Sent
  • Received
@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 11, 2018

Comment posted by pschuele on 9 Aug 2017 12:59

http://gerrit.tine20.com/customers/#/c/5412/

Gloirin commented Jun 11, 2018

Comment posted by pschuele on 9 Aug 2017 12:59

http://gerrit.tine20.com/customers/#/c/5412/

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 11, 2018

Comment posted by pschuele on 15 Aug 2017 16:13

http://gerrit.tine20.com/customers/#/c/5439/

Gloirin commented Jun 11, 2018

Comment posted by pschuele on 15 Aug 2017 16:13

http://gerrit.tine20.com/customers/#/c/5439/

@Gloirin

This comment has been minimized.

Show comment
Hide comment
@Gloirin

Gloirin Jun 11, 2018

Comment posted by pschuele on 20 Sep 2017 11:37

does not work with pgsql:

SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »mailfiler_message.sent« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werdenLINE 7: ...2f'))) GROUP BY "tree_nodes"."object_id" ORDER BY "sent" ASC... ^, query was: SELECT MIN("tree_nodes"."id") AS "id", MIN("tree_nodes"."parent_id") AS "parent_id", "tree_nodes"."object_id", MIN("tree_nodes"."name") AS "name", MIN("tree_nodes"."islink") AS "islink",

Gloirin commented Jun 11, 2018

Comment posted by pschuele on 20 Sep 2017 11:37

does not work with pgsql:

SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »mailfiler_message.sent« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werdenLINE 7: ...2f'))) GROUP BY "tree_nodes"."object_id" ORDER BY "sent" ASC... ^, query was: SELECT MIN("tree_nodes"."id") AS "id", MIN("tree_nodes"."parent_id") AS "parent_id", "tree_nodes"."object_id", MIN("tree_nodes"."name") AS "name", MIN("tree_nodes"."islink") AS "islink",

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment