by eKelman » Thu Apr 07, 2011 6:28 pm
Thank you rgansevles
That helped and works for a single filter parameter.
One last question I have is how do I go about applying multiple filter values for a column
For example. I have to filter a table based on active_ind. The values can be 'Y', 'N', null
The values I need to filter are where active_ind = 'Y' or active_ind is null.
How would I go about doing that?
I have tried the following, but none of the following provide the correct results.
var args = new Array('Y', null);
success = databaseManager.addTableFilterParam(server, tableName, 'active_ind', 'IN', args, 'active');
and
success = databaseManager.addTableFilterParam(server, tableName, 'active_ind', '!=', 'N', 'active');
I have also tried the subquery method which works, but i think performance wise, this is going to be a killer. Is there any other way to do this?
Thanks
Ernest
Kelman Technologies