Hello !
I am working on a project that requires me to query a database and then exclude the certain records from my finalized list if certain exclusion criteria apply… for example if one column starts with a certain string … if it between the numbers 2000-5000 etc etc . There is over 25 different conditions … is the best way to do this by using the Filter Datatable activity ? I am not sure if it is good practice to have so many conditions with that activity. Also I can use many of the conditions for my exclusion criteria but some are not available in the filter wizard … like exclude if a certain column is between 2000-4000… any input would be extremely helpful ! I am new to this and really enjoying my work so far but want to make sure I am taking the best approach to this workflow .
Best approach would be using LINQ here. They are fast reliable and straight to the point.
Thanks,
Ashok 
- If conditions are simpel then use filter table …can use multiple filters as well or multiple filter activities depending on the criteria
- For any vomplex queries linq would eb the best approach…also if number of rows are a lot then this would be best
Cheers