Skip to main content
Version: 7.9

Row Selector

Component Palette Icon:


Inductive University

Row Selector

Watch the video

The row selector is a component that acts like a visual filter for datasets. It takes one dataset, chops it up into various ranges based on its configuration, and lets the user choose the splices. Then it creates a virtual dataset that only contains the rows that match the selected splices.

The most common way to splice the data is time. You could feed the row selector an input dataset that represents a large time range, and have it break it up by Month, Day, and then Shift, for example. Then you could power a report with the output dataset, and that would let the user dynamically create reports for any time range via an intuitive interface.

To configure the row selector, first set up the appropriate bindings for its input dataset. Then use its Customizer to alter the levels that it uses to break up the data. In the customizer, add various filters that act upon columns in the input dataset, sorting them by various criteria. For example, you could choose a date column, and have it break that up by quarter. Then below that, you could have it use a discrete filter on a product code. This would let the user choose quarterly results for each product. Each level of filter you create in the customizer becomes a level in the selection hierarchy. Note that the output data is completely unchanged other than the fact that rows that don't match the current user selection aren't present.


Additional information on the Row Selector can be found on the Vision Reporting Components page.


NameDescriptionProperty TypeScriptingCategory
VisibleIf disabled, the component will be hidden.Boolean.visibleCommon
Unknown Node TextText for any 'Unknown' nodes (nodes where the data didn't match the filter).String.unknownNodeTextAppearance
Unknown Node IconIcon for any 'Unknown' nodes (nodes where the data didn't match the filter).String.unknownIconPathAppearance
Show Root HandlesShould root-level nodes have collapse handles?boolean.showRootHandlesBehavior
Show Node SizeIf true, the number of rows in each node will be shown.boolean.showNodeSizeBehavior
Show All Data NodeShould the 'All Data' (root) node be shown or hidden?boolean.showAllDataNodeBehavior
Selection BackgroundThe background color of the selected node.Color.selectionBackgroundAppearance
OpaqueIf false, backgrounds are not drawn. If true, backgrounds are drawn.boolean.opaqueCommon
NameThe name of this component.String.nameCommon
Mouseover TextThe text that is displayed in the tooltip which pops up on mouseover of this component.String.tooltiptextCommon
Foreground ColorThe foreground color of the component.Color.foregroundAppearance
FontFont of text on this component.Font.fontAppearance
Expand All Data NodeIf true, the 'All Data' (root) node will be expanded and selected when the user opens this window.boolean.expandAllDataNodeBehavior
Data OutThe output of the row selection tree. Changes based on user selection in the filter tree.Dataset.dataOutData
Data InThe input of the row selection tree. The filter tree changes based on this Dataset.Dataset.dataInData
CursorThe mouse cursor to use when hovering over this component.Cursor.cursorCommon
BorderThe border surrounding this component. NOTE that the border is unaffected by rotation.Border.borderCommon
Background ColorThe background color of the component.Color.backgroundAppearance
All Data Node TextText for the 'All Data' node, if it is displayed.String.allDataNodeTextAppearance


Scripting Functions

This component does not have scripting 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.


The Row Selector has it's own Row Selector Tree Customizer and allows users to customize the row filtering. The customizer provides some default filters which you can use, or customize based on the dataset.

Row Selector Tree Customizer

The Row Selector Tree Customizer allows you to build and configure a tree of the data in the input dataset which can then be used to filter it. There are three main parts to the customizer. The left panel contains a list of available filters, the center panel contains a list of filters that will be used, and the right panel will contain configurable properties for the filter currently selected in the center panel.

In the Available Filters section on the left, a list of all of the columns of the dataset are shown. These can be expanded to show the filters available for that column type. Some columns might not have any filters, while others can have many, it just depends on the data type of column. These filters can then be dragged into the center panel, or highlighted and the right arrow () button pressed to push the filter into the center panel where it becomes an active filter.

The Filters panel in the center contains a list of filters that are being used with each filter being followed by the name of the column that it originated from, and is where you can decide on the order of the filters. The order is important because it is the order in which they will be used in the component. Using the image below as an example, The component will first show a list of years. You can select a particular year, and the output dataset will only contain rows from that year. Alternately, you can expand a year where you will then see a list of strings that are in rows with that year. Selecting one of the strings will display all rows with strings like the one that you selected, that are also in the same year.

The Configure Filter panel on the right contains configurable settings that differ based on the type of filter selected. All filters at least contain an Icon Path property, which allows you to set what icon will be used with with that filter in the filter tree. Each filter type also has a reverse sort option, allowing you to have the filters displayed in reverse order in the filter tree. The unique properties are:

  • Shift Filter Type - Contains a table allowing you to specify shifts with start and end times.
  • Custom Date Filter Type - Contains a format string allowing you to specify the format of the custom date.
  • String Filter Type - Contains a Case Insensitive property which when checked will not check case when comparing strings.
  • Discrete Filter Type - Contains a format string property allowing you to specify how the integer value will be displayed. Place '%d' in the format string as a placeholder for the string value. The default is 'Item %d'.


Refer to the example on the Vision Reporting Components page.