How do I convert custom SQL query to Wappler query builder

sevenrice · July 17, 2024, 1:48pm

hmm

I think I did it right and still no luck

Teodor · July 17, 2024, 2:12pm

So what is the issue you are having now?
What do you see under Network > XHR in the dev tools when your server action runs?

sevenrice · July 17, 2024, 2:22pm

When loading the tournament page, the query does not return any "catches" as seen here

There should be 1 angler and 3 lengths

It does appear the server action is running and getting a parament see the tournament_catch_query?tour_id=2

If I had to guess that tour_id=2 is not getting set within the query to populate the table.

Teodor · July 17, 2024, 2:25pm

So when you select the server action in the network > xhr, do you see the data returned?

sevenrice · July 17, 2024, 2:29pm

Yes

When I double click on the server action it opens this window

Teodor · July 17, 2024, 2:34pm

So all the data is now properly returned?
What is the issue then?

sevenrice · July 17, 2024, 2:36pm

The data does not show in the table on the page

Teodor · July 17, 2024, 2:39pm

Then there must be something wrong with how you generated it.
Double check what your server action returns, what expressions are you using on the page etc.

sevenrice · July 17, 2024, 2:40pm

Maybe

This is what I using for the table

Teodor · July 17, 2024, 2:44pm

Do you have a link to your page where i can check this, it would be much easier than guessing what could be wrong on your page from screenshots.

sevenrice · July 17, 2024, 2:49pm

hmm, I am just deploying it local, let me see if I can get it on a server