Hi,
We have created a lobby element with the SQL query builder.
However, we cannot enter an order by here.
By default, it sorts by machine number (but we have not set this ourselves) and we want to sort by zip code.
How can we solve this?

Hi,
We have created a lobby element with the SQL query builder.
However, we cannot enter an order by here.
By default, it sorts by machine number (but we have not set this ourselves) and we want to sort by zip code.
How can we solve this?
Best answer by Jur
You have to adjust it in the SQL section at the bottom.
You can also use (or abuse) this for writing more complex queries that are not possible within the Data Source Designer without creating an IAL.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.