Forum Discussion
Pass parameter to query
Yes, you will need to change Query1 to receive parameter nad then call Query1 as
result=Query1(Parameter1)
Hence your Query1 would become
(Parameter1)=>
Let......(code of the query)
filter_field=Parameter1 (somewhere here is the filter condition base on the value of Parameter1)
..........
in ....
Parameter1=parmtable{0}[Year] - This will always pass the first value from parmtable
{0} - 1st row
{1} - 2nd row
and son
So, you just need to change 0 to appropriate value to pass the required parameter. Hence, if you need to pass the 3rd paramter, then this would become
Parameter1=parmtable{2}[Year]
You will also need to change your Query1 to receive Parameter1 as parameter.
Exactly, this is also working, but the value read from the table parmtable is not passed to the QUERY1, the QUERY1 is still using the default value of Paramter1.
Yes, you will need to change Query1 to receive parameter nad then call Query1 as
result=Query1(Parameter1)
Hence your Query1 would become
(Parameter1)=>
Let......(code of the query)
filter_field=Parameter1 (somewhere here is the filter condition base on the value of Parameter1)
..........
in ....
