Dynamic Sort - GET.sort and GET.dir output

Wappler General Bugs
#1

Dynamic Sort - GET.sort and GET.dir does not output correctly

I have tried to create a bootstrap table that is sortable. but it does not work. so i went back to the basics and still I cant get the sorting to work. Can somebody tell me where i missed something?

Here is a link to the page basic setup.

  1. https://tradersauction.co.za/test.php?sort=title&dir=asc

ascending
ascending.jpg1910×662 361 KB

  1. https://tradersauction.co.za/test.php?sort=title&dir=desc

decending
decending.jpg1910×662 359 KB

You will see the data does not Ascend or Descend

But if you DEBUG it… it shows in the sql?

https://tradersauction.co.za/test_debug.php?sort=title&dir=desc

decending-debug
decending-debug.jpg1910×662 138 KB

https://tradersauction.co.za/test_debug.php?sort=title&dir=asc

ascending-debug
ascending-debug.jpg1910×662 140 KB

This is what i have

code
code.jpg1856×944 147 KB

server-connect
server-connect.jpg1532×944 97.5 KB

so im a bit confused… any help or maybe i have missed something as i have followed the steps from

#2

Add the columns you need to the select list in the query builder, don’t just add auctions.*
The sort options don’t work when you add the table like that, for security reasons.

3 Likes
#3

Thanks @Teodor it was driving my head in i could not understand why… but thanks for explaining that… did not know… :slight_smile:

Once again thanks for the quick support @Teodor. Always answering questions… even if its the same one over and over… and over… and over… because i wont have the patience to do this… so for that I salute you…

2 Likes