Problem of using Parameters in Query templates

[Former Member]

Hi,

how do use parameter values in SQL query in query templates? i have 2 field database no1, no2. i want to filter it by no2 by using param. i gave in filter field of query template as order1.no2 like '[Param.1]' and in parameters as % and clicked set. when i test it, it is showing error..

help me.

- senthil

[Former Member · Accepted solution]

Hi,

I tried that mode is query, filter expr is order1.no2 like '[Param.1]' and in parameters % . It is showing all the cols.

-vijaya

[Former Member · Accepted solution]

Hi,

its working now. thanks

-senthil