I messing around it from quite a while , I am tring to add filter or conditions on Database connector/ profile.
Is there any way around this to acomplish this task ?
1. Create and test your query.
2. Replace any 'WHERE column = Value' with 'column = ? ' in the query script for the profile
2. Add Parameters for each ? in the profile in the order in which they appear in the script.
3. Populate the parameters for the connection with constants, profile elements, etc
See this for more detail Database Integration Guide
Retrieving data ...