How make a sql query using a text field

[I want to make a sql query  using a text box. I try to explain.  A have a text box containing the username of a joomla user and I want to perform a query on a wisiform database with the same username. I have used a query  like select CONCAT(F37, ' ', F108, ' ',F55) as label, id as value from #__visforms_3  where id = ${input:nume};  where nume is the alias of a text field containg the user name. My goal is exstract from the visform database the name, email ed a date.
But nothing happens. Can you help me?
I use visiform subscription
Molte grazie!

Hello giamod,

your query is:
The WHERE part seems to be wrong.
The field 'id' is an auto-increment of an integer.
You have to enter the correct text field instead of the field 'id'.

I suspect the SQL statement must be something like this.
While I assume that table field 'F37' corresponds to the form field with the alias 'nume':
Kind regards, Ingmar

You are great! I had yet tried your statement but I received a blank field. I have to set up something in particular? The two fields, nume and ris (as sql result) are textbox, the second with sql statement?

Hello giamod,

I'm sorry, but I forgot the obligatory single quotes for string literals.
I was so focused on choosing the wrong field.
The text field values ​​are string literals and must be enclosed in single quotes:

... = '${input:nume}' ...

This SQL statement is now at least completely correct and looks very promising.

Maybe it will work now...

When developing SQL statements, a good development environment is important.
Even for tasks that seem simple, like this.

Visforms obviously cannot be a competent development environment at this point.
But we can point out this fact in the documentation and recommend working methods.

Modern text editor or development environment:
docs.joomla-5.visforms.vi-solutions.de/e...elopment-environment

Quote:
We recommend that you write the SQL statement in a good modern text editor or, better still, in a dedicated development environment and test it thoroughly. It is also possible to develop and test the SQL statement in a MySql console, for example.

Quote:
When using the test button for the SQL statement, you must take this fact into account and work with fixed values ​​instead of placeholders.

Best regards, Ingmar

I reply in italian language: "FUNZIONA!"
Molte grazie, Ingmar!

Hello giamod,

I'm very happy to hear that.

And especially in your native language!

Now that you've overcome these first hurdles, you'll definitely find even more uses for the SQL fields.

Best wishes, Ingmar