Table Viewer - Support column filters #1720
Description
Is your feature request related to a problem? Please describe.
When writing transformation logic you often want to see specific rows in your source data to identify values that would need to be referenced in your transformation logic. Also when visually validating results in tables created by your SAS code, you often want to see a specific (small) subset of your data. Supporting filtering in Table Viewer would really help the user to be more productive in these scenarios.
Describe the solution you'd like
This feature requests focuses on support for building a filter on one or more columns, just like is supported in SAS Studio. This is different from #916, which is aimed at a user that is very familiar with writing where clauses.
Filtering on a column would show a UI that allow the user to pick from a list of operators and then specify a value, with support for adding AND/OR clauses to specify more values that need to be included/excluded. Just like what is supported in the table viewer in SAS Studio.
When filtering on another column that filter is added to already existing column filters.
Describe alternatives you've considered
No response
Additional context
No response
SAS version
SAS 9.x and SAS Viya