server icon indicating copy to clipboard operation
server copied to clipboard

[BUG]: Ordering parameter in API (Tasks-Table)

Open gpascal123 opened this issue 1 year ago • 5 comments

f, for example, you sort by Dispatched/Searched, the table is initially sorted correctly. If you switch to another page and then back again or reload the tasks page, the following error message appears. Image

Error in the API: Image

Error occurs when sorting by

  • Name (parameter taskName)
  • Dispatched/Searched (parameter clientSignature)**

gpascal123 avatar Oct 02 '24 14:10 gpascal123

I think the problem is an incorrect dataKey in tasks-table.component.ts (line 139). The dataKey 'clientSignature' does not exist in the Tasks table, that's why the PHP backend correctly throws an exception. Currently I can't see, what the correct dataKey for this table column should be, what information is displayed in this special column?

gluafamichl avatar Oct 15 '24 14:10 gluafamichl

Just checked the old PHP UI, Dispatched/Searched column is excluded from sorting, maybe that's the correct solution for the new UI, too?

gluafamichl avatar Oct 15 '24 14:10 gluafamichl

We have to check all tables in the new Web UI, there are quite a lot of mismatches in the dataKey settings (key names do not exist in Backend DB tables) Sounds like a perfect bug to add some more unit tests ;-)

gluafamichl avatar Oct 15 '24 14:10 gluafamichl

Will be checked again when reviewing new paging backend API.

gluafamichl avatar Nov 08 '24 09:11 gluafamichl

Frontend has to be compatible with the api before checking the ticket again

ObsidianOracle avatar Feb 26 '25 08:02 ObsidianOracle

All unknown dataKeys set to isSortable: false, sorting only works for backend keys from database

gluafamichl avatar Aug 20 '25 12:08 gluafamichl