1. I need to display tables that have around 7 columns. I want 3 or 4 of these columns not to show in the grid - but, these hidden columns will be used in filters. Is this possible ?
2. The columns I want to filter on have Yes or No values. Is it possible to set up a filter to include only 'Yes' values or only 'No' values ?
3. Is it possible to operate more than 1 filter simultaneously. So I could set up filters as above and filter on more than 1 hidden column ?
1. Yes, you can hide columns and still using in filters
2. In WHERE text box you can write filter as you wish, e.g.:
WHERE: isReseller = 'Yes'
3. Yes, you can use more than 1 filter simult., e.g.:
WHERE: isReseller ='Yes' AND country='US'
(you can use any predicate - simple or complex with operators like AND, OR, <> (not equal), = (equal), ...
*isReseller, country: column names that are hidden or displayed
thank you for your prompt response to my enquiry. I just want to clarify on my use of filters, with another question:
Specimen table attached as MS Word Doc
What I would like to know, based on the specimen table layout is:
1. The 2 greyed out columns are hidden. According to your answer above I can still set filters on them.
2. I would like these filters to be the result of input from the user - so effectively it is the user choosing the entriy rows that are shown. Is this possible ? And if so (since they wont know the content of these columns) can they select a Yes / No to a question I pose on the content page ? Similar to a check box on a form.
3. Is it possible that columns can be filtered using 'Alias' filters. For example the 'Title' field in the specimen table has entries for:
ABC New XYZ
LAB Prac
DEF New XYZ
LAB XYZ
Can I set up a filter whereby there are choices from a 'drop down list' where, for example, choice 'Blah' (in the ddl) = Any entry containing the string New etc
