If i create input box,and input one value,can i use this value in my select sql?

[Anonymous]

for example:

my select sql:

select * from tablename where columnname = 'my input value';

when i click select button,the page can refresh the data.

[juraj_misina · Accepted solution]

Yes, you can do this. You need to connect the input box to a variable and then use that variable in the load script.

select * frmo tablename where columnname='$(variablename)';

assign a Reload action to the "select" button.

[Anonymous]

thanks for your help,I had resolved.

But if user input value is null,and then click "select" button,how can i used '20180101' to replace the input value?

[juraj_misina]

Hi,

you can do this by

If(Len('$(variablename)')=0 then

LET variablename = '20180101';

EndIf