Boolean Filter

I have a couple of questions before purchase.

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 ?

Thanks for any responses !

Hi,

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

Best regards,
Viljem

Hi Viljem

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

kind regards,

Toby