Skip to main content
Version: 8.1

Vision - Column Selector

Component Palette Icon:

Description

The column selector component is conceptually similar to the Row Selector, except that instead of filtering rows, it filters columns from its output dataset. Each column from the input dataset is shown as a checkbox. As the user checks and un-checks columns, the output dataset has those columns added or removed. This is very handy for driving the Table and Classic Chart components. In addition, this component can bring in multiple datasets and output just as many filtered datasets.

Properties

PropertyDescriptionProperty TypeScriptingCategory
AlphabetizeIf true, checkboxes will be ordered alphabetically by their text.Boolean.alphabetizeBehavior
Background ColorThe background color of the component. Can be chosen from color wheel, chosen from color palette, or entered as RGB or HSL value. See Color Selector.Color.backgroundAppearance
BorderThe border surrounding this component. Options are No border, Etched (Lowered), Etched (Raised), Bevel (Lowered), Bevel (Raised), Bevel (Double), and Field Border.
Note: The border is unaffected by rotation.

Changed in 8.1.21
As of 8.1.21, the "Button Border" and "Other Border" options are removed.
Border.borderCommon
CursorThe mouse cursor to use when hovering over this component. Options are: Default, Crosshair, Text, Wait, Hand, Move, SW Resize, or SE Resize.Int.cursorCodeCommon
Data InInput dataset. This is the default when first dropping the component on the window, the name may change based on configuration and there may be more of these input dataset properties.Dataset.Data_inCustom Properties
Data OutOutput dataset. This is the default when first dropping the component on the window, the name may change based on configuration and there may be more of these output dataset properties.Dataset.Data_outCustom Properties
FontFont of text on this component.Font.fontAppearance
Foreground ColorThe foreground color of the component. See Color Selector.Color.foregroundAppearance
Group By DatasetIf true, checkboxes will be grouped by their dataset. Otherwise, checkboxes will be arranged flat.Boolean.groupingBehavior
Horizontal GapThe horizontal gap between checkboxes or grouping panels.Int.hGapAppearance
Mouseover TextThe text that is displayed in the tooltip which pops up on mouseover of this component.String.toolTipTextCommon
NameThe name of this component.String.nameCommon
Normalize WidthsIf true, all checkboxes will be assigned the same width, which causes them to line up in columns.Boolean.normalizeWidthsAppearance
Vertical GapThe vertical gap between checkboxes and grouping panels.Int.vGapAppearance
VisibleIf disabled, the component will be hidden.Boolean.visibleCommon

Scripting

Component Functions

This component does not have component functions associated with it.

Extension Functions

This component does not have extension functions associated with it.

Event Handlers

Event handlers allow you to run a script based off specific triggers. See the full list of available event handlers on the Component Events page.

Customizers

The Column Selector component has its own Column Selector Panel Customizer that allows you to configure how the Column Selector filters columns.

The Column Selector Customizer contains two basic parts. The left side of the customizer allows you to configure how many datasets can be brought in for filtering. Each dataset added will add two additional custom properties to the Column Selector; an In dataset property and an Out filtered dataset property. Datasets can also be removed here, or moved up or down in the list. If there are multiple datasets, the columns from the first dataset in the list will be displayed at the top of the Column Selector, while the columns from the last will be at the bottom.

The right side of the customizer allows you to configure the settings for each dataset. When a dataset is highlighted on the left, we can see some basic information about it on the right, such as the Grouping Title and a list of all of the columns in that dataset. The Grouping Title is only used if there is more than one dataset in the Column Selector. In the component, each dataset's columns will be contained in a border and will display the Grouping Title. This can be configured to be anything, so that it is easier for a user to distinguish what each set of columns is for. In the Column Settings table, we see each one of the columns in that dataset listed out. Here, the Display column allows us to alter what name that column will display on the component, again allowing you to create names that are more meaningful to the user. Finally, the Excluded from Selection column allows you to exclude certain columns from being filtered. Columns that have this enabled will not show up in the list of columns on the component. This will not filter them out in the output dataset, but instead forces them to be in the output dataset.