SQL statement in Read Data

How to create a WHERE clause in ChronoForms 8.

Overview

The user is unsure how to structure SQL conditions in the new Read Data action compared to ChronoForms 7.
Use the 'Where Statement' field for simple conditions like 'art_id > 0 AND active = 0', or use the 'SQL code' field for a complete SELECT statement.

Answered
ChronoForms v8
Fr Fredolino 12 Oct, 2025

Hi

In CF 7, the SQL statement in Read Data was easy to set up.

And what is the SQL statement on CF 8 for:

art_id > 0

active = 0

Fr.

Max_admin Max_admin 12 Oct, 2025
Answer

Hi Fred

There are 2 behaviors:

1- Where Statement where you need to enter the where part only, example: id = 1

2- SQL code where you need to add a full SELECT statement

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Post a Reply