Issue when sorting query: WHERE conditions are removed

Wappler General Bugs
1

Wappler Version: 7.2.2
Operating System: Windows 11
Server Model: Docker
Database Type: Postgres
Hosting Type: Local

Expected behavior

What do you think should happen?

The query should keep the WHERE conditions even after applying sorting by a field.

Actual behavior

What actually happens?

When I go to Sorting and select the name field to order by, then click OK, the WHERE conditions are removed automatically and I cannot recover them.

How to reproduce

Detail a step by step guide to reproduce the issue:

  1. Create a database query that retrieves customer data with the following condition: if the inactive field is empty (null) or different from true.

  2. Apply the query → everything works fine.

  3. Go to Sorting and select the name field to order the results.

  4. Click OK.

  5. Notice that the WHERE conditions are deleted.

I even recreated the query from scratch, but the same problem persists.

2

this is been reported and will be solved in the next update thursday:

1 Like
3

Fixed in Wappler 7.3

1 Like