how to use BDB platform Filters in Data sets..?

[mohd.gulam]

Suppose we are creating data set in that we want to show the data based on selected row in a column:-


  1)select name,gender,sum(amount) as total from restaurant_data where gender =@gender@

    so when we run this query in data set it gives gender column data=Male and female ,based on select it shows data accordingly..

    All filter


     2) select name,app,gender,sum(amount) as total from restaurant_data where (app=@app@ or "All"=@app@)

    * it means if we select ALL in filter ,it shows data for all Apps,,