Wildcard for numbers in query

[markoax21]

Hello! I have a query that only works if I have the codag value - numeric - (send by drop down menu).

I would like the menu, if I don’t select anything in particular, to show me the complete query
I don’t know how to set the wildcard value (I refer to below post, which I had done for a similar problem but with a text field and ‘%’)

Problem with a query... too complex or wrong?

OK thanks. There is a final problem. In this way the search functions works only if I type the words in full. For example, for a product called “article 1”, it is not displayed to me until I write the complete name. It is not enough just to “artic” as it should be [dmx1]

Can anyone help me?
Thanks

[famousmag]

Hey @markoax21,

If I understand correctly, you need to ignore the post value of the select input if it is not set.
Is this right?
If yes, then use the toggle condition inside your Query builder conditions (see example below)

[markoax21]

Hi @famousmag!
I have to do custom query, can’t make simple. so this is the code I wrote:

SELECT demil.isprev.data AS dataisprev, demil.isprev.codice AS codisprev, demil.isprev.note1, demil.isprev.numdoc, demil.conti.[desc] AS contidesc, demil.isprev.finito, demil.isprev.sincronizzato, demil.utenti.[desc] AS descagente
FROM ((demil.isprev INNER JOIN demil.conti ON demil.conti.codice = isprev.codice) INNER JOIN demil.utenti ON demil.conti.codag = demil.utenti.codag)
WHERE demil.isprev.codag = :P1 /* {{$_GET.agentifrm}} */ AND demil.isprev.finito = 1
ORDER BY isprev.numdoc DESC

:P1   {{$_GET.agentifrm}}

I need that

demil.isprev.codag = :P1 /* {{$_GET.agentifrm}} */

give me all values (something like % for text) if I don’t select a specific value in dropdown menu.

[markoax21]

I solved changing the field type (set as nvarchar) and making a query with ‘LIKE’ instead of ‘=’