By default include/exclude new columns in side filter on refresh

benjamin · January 11, 2011 6:18PM

Hi

I hope you had a good new year .

1. In omniscope when I am filtering a tab by a certain column say Alphabet which has categories A,B,C,D and false. Say I only include A,B,C,D in tab. Then if when I update the file from database and say a new category is added to the column say E. By default the file excludes the E data from the tab. Is there any option which allows the developer of the file to define if a new category is added to the filter to either include it or exclude it by default .

2.When you add a new field to a file is there a way by default to have this field hidden from all tables, sidebars etc by default. I am aware that you can click hide field on the manage data tab.. however this is a nuisance to do for every new field which is added.

Any help would be much appreciated.

steve · January 11, 2011 7:50PM

1. Checkbox filters are by inclusion (unless they are reset). If you want an option to change it to be by exclusion, this is a new feature - please post under Ideas and we'll see if it's popular.
However, instead of using checkbox filters, try selecting "false" within e.g. a Bar view, and click Move. This will generate an exclusion rule which should achieve the desired effect.

2. "Settings > Advanced tab settings > Freeze visible fields" will ensure that, when you add a field (or one appears through refresh from source), it won't appear in views in that tab. But the exception is if you explicitly add a field in a given tab; this will always appear in that tab's views/filters.

acm · January 11, 2011 8:07PM

Try setting the sidebar on the left. I believe new fields won't be added to the sidebar

Welcome!

Categories

Ideas Parade