where statement

omerva 3d ago

I should exclude from the dropdown list the fields with multiple words separated by commas.I tried with {row:settore} NOT LIKE '%,%' but it doesn't work.I still haven't figured out what language to use in Where statement and I don't know how to do it.Isn't there a manual?

Max_admin 1d ago

You may use SQL in the Where Statement behavior of Read Data or process the returned results in a PHP action before passing them to the Dropdown dynamic options.

Please post a screenshot of your config if this is does not help

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.