Sorting Table Tutorial

Wappler General
1

Hi,
I have followed the tutorial for creating a dynamic sorting table but like others here, have been unable to get the end result to work.

In Wappler preview mode I can see the sorting arrows but in any other web browser they are missing.

I preview mode and in any web browser, not sorting takes place.

I have tired using Bootstrap 4 and 5 each with the same result of the sort/direction not working.

Is there an updated tutorial on its way or has anyone managed to get the dynamic sort table working?

Many thanks
CK

2

Do you have a link to your page where we can check this?

3

Sure, I have created a clean page with a single table created by following the Tutorial;

https://grafitec.co.uk/test/list.php

list
list1509Ă—534 92.2 KB

4

It looks like not all the files are uploaded:
image

5

It seems you have not uploaded all the files to the server as a lot of them are reported as missing:

Screenshot 2022-05-11 at 12.20.10
Screenshot 2022-05-11 at 12.20.10868Ă—219 32.5 KB

1 Like
6

:wink:

7

Have reloaded the dmx files via Wappler, not sure why it didn’t do it itself.

Page now shows no errors and the sort arrows are showing correctly, however the columns are still not sorting, any ideas why?

8

Wappler didn't do what? When you upload your site to a remote hosting you need to hit publish so all the files are uploaded.

How is you server action set up? How is your database query set up?

9

Have created another test page. It has a very simple db query which shows all records from a single table, there are no conditions or sorting in the query builder.

The page shows the results of a simple repeat from a single column using the serverconnect instance on the page. The table generator used the same serverconnect instance and shows all the columns available but as you can see there are no results. I don’t understand why.
The page has an error in the inspect panel but it’s one I again don’t understand.

10

Not sure i am following.
Is this another issue you are reporting here or is it related to the initial one?
Also i did ask you to post a few screenshots of:

which you did not provide.

Again i don't understand what are you referring to.

When reporting different issues, make sure to post them in separate topics please!

11

Is not a request for screenshots!

And yes its all related to the dynamic table sorting not working...

12

Server action setup

1
1893Ă—472 46.7 KB

DB Query

2
21041Ă—651 56.9 KB

13

And is your old link not working any longer?
I see something completely broken there, not a dynamic table displaying results …

14

I don’t know whats going wrong. I will delete everything and start again, since I pressed the publish button as you suggested I cannot get the table generator to produce a table that shows any results yet if I create a simple repeat region its working, seems like the Table Generator is broken…

15

Can i just add here I see your app connect version is 1.14.0

Did you install the file in this thread if using Wappler 4.9.0

16

Thank you for your input.
Yes I used Wappler 4.9.0 to undertake all the work. I have deleted and recreated both the server action and the list.php after rebooting my pc and asking Wappler to publish the site just in case, as before files might be missing on the server. The result is the table still refuses to show and records which the simple repeat on the page does!

17

There is a bug in Wappler 4.9.0 this maybe why it’s not displaying the tables records I’m not sure entirely what elements it effects and with filters etc but you should download and install the Zip in the thread I linked it fixes the issue in App connect version 1.14.0 and might fix this issue or at least make the records appear.

18

Get this file:

and replace the existing one on your local and remote sites. This will fix the table not displaying data issue.

1 Like
19

OK, thank you Teodor, the table now displays data as expected and there are no errors on the page now.

Unfortunately the sorting still won’t work. I have re-checked the tutorial to make sure I haven’t made a stupid mistake but I can’t see one if I have.

20

Are you sure you added the actual columns in the query builder and didn’t just select * there? Sorting requires you to pick the tables you need and does not work with *

2 Likes