PROBLEM in dropdown from query

February 22, 2021, 03:58:32 PM

willvin, thanks in advance for the time you take to answer this questions. I have this situation when i mke a select for a drop down, the dropdown values are somew how like invisible, im calling them with this query, "SELECT CONCAT(i.Nombre,' ',i.Apellido) FROM client AS i" from select data source. Please help.

Re: PROBLEM in dropdown from query

Reply #1 – February 24, 2021, 02:27:39 PM

Hi, @nyacumo‍ please your PHP configuration to generate the query before you edit it.

Code: [Select]

SELECT CONCAT(i.Nombre,' ',i.Apellido) AS label, i.id AS value FROM client AS i

The issue was with the value and label, if you were to select the field and the tables using the Datasource Look Up or Data Table before you edit the query you should have seen the structure phprad uses to get the value and label. The above query should work but I don't know if the field id exists in your client database table. Please use the right field there, if I am wrong.