I'm working on a project with a page where users can build their reports dynamically.
We have a listbox.... user selects from values from it. These are the columns for the Excel report
Next, user can build the where-clause. These are textboxes. For example.... textbox1 = some value (they type this). Now, this is unlimited.
User can click on a button, and create another clause. We AND them together. There's no limit.
I think there should be a limit to this. Maybe 5 to 10. My manager says there shouldn't be a limit. He gave an example...in TFS...user can create as many query where-clause as they want. Here's an example Example
So, should there be a limit in where-clause when we create a SQL for reporting and the report is dynamic?