I need to filter data from a grid, but I need to pass by parameter. if it is necessary to return all the data. I always do the following to show all the data in the Grid Example:
SELECT FROM TABELA A
WHERE (A.NUM = :parâmetros) OR (:parâmetros = 0)
but how can I do it in:
filter := 'num = :paramentro' or (:paramentro = 0)