Add order fields and an SQL statement to Read Data

Add order fields and an SQL statement to Read Data in ChronoForms.

Overview

The issue is that the order fields and SQL statement are not being applied correctly, often due to incorrect syntax or placement.
Ensure the order fields are properly formatted and placed within the correct section of the CF form, and verify the SQL statement is structured to apply the sorting and conditions as intended.

Answered
ChronoForms v8
Fr Fredolino 11 Oct, 2025

Hello,

I'm trying to add order fields and an SQL statement to my Read Data. I can't get it to work, even with the help of the instructions.

Order Data:

defaultView= Desc

name=Asc

Where Condition:

active=1

Best regards,

F.

si simelas 11 Oct, 2025
Answer
1 Likes

Order Data:

defaultView  Desc

name  Asc

Post a Reply