Placeholders in SQL statements for field types (selectsql, radiosql)

Hi
I'm trying to use field types (selectsql or radiosql) in a form to get option list extracted form à database table, but it does not work.
Here is my test :
- input field : Identifiant (alias identifiant)
- field select (SQL select statement)
select f_label as label,f_value as value from #__adherent where f_label = '${input:identifiant}'

When I input a string in field 'Identifiant', nothing displays for the select field when the condition is true

Can you help me ?

Regards
Philippe

Hi Philippe,

I think, that there is actually a misunderstanding about the concept of what the input object is.

The input object is gathered from the request (GET and POST).

So identifiant must either be set as URL-Parameter in the URL which displays the form in the first place.

Or you must use the Select SQL field option "Make reloadable" and choose the identifiant field then in the option "Reload on change of". This will trigger, that a AJAX request with the current user inputs is send to the server.

Please note, that only fields of type select, radio, checkboxgroup, chekbox, selectsql radiosql and Checkboxgroup SQL can be used as reload trigger fields.

If the relaod trigger field is a select, selectsql, checkboxgroup or checkboxgroup sql field you also need to change the syntax from
'${input:identifiant}'
to
in ${input:identifiant[]}
(without quotes)

Regards,
Aicha

Hi Aicha
Thank you for your answer. But is it possible to have an small example ?
I can't find any in your documentation.
Regards.
Philippe

Hi,

if you want to use an URL-Parameter in order to set a default value in the identifiant field, please check out the documentation about URL-Parameters: www.vi-solutions.de/en/documentations/vi...lue-using-url-params

If you want to use the "Make reloadable" feature, and the field identifiant is of type select, then your sql statement would be
select f_label as label,f_value as value from #__adherent where f_label in ${input:identifiant[]}
Regards,
Aicha