You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing training@inductiveautomation.com.
Version:
Supplemental Videos
-
7:55Control Components
-
4:16Dropdown
-
3:01Tree View
-
5:20Table
-
3:53Power Table
-
3:55User, Schedule and Roster Management
-
3:13Row Selector
-
2:44Column Selector
-
2:56File Explorer and PDF Viewer
LESSON
Column Selector
Description
Explore the Column Selector component that comes in the reporting module. This component provides a graphical interface which lets you filter some or all dataset columns from a list.
Video recorded using: Ignition 8.1
Transcript
(open in window)[00:00] The column selector component is similar to the row selector, except that instead of filtering rows, it filters columns from its output dataset. The component is listed as the third option under the reporting section of the component palette. I'll drag one onto my window here so I can filter my existing data sets. Those are currently populating the tables raw data one and raw data two on my window. I'll start by binding my column selector's data in property to raw data one's data property. You can see the column headers are now displayed in the column selector component. Next, I'll bind my filtered data tables dataset to the data out property of my column selector. All of the columns that are checked off here pull into my filtered data table. I can go into preview mode to uncheck a column. I'll uncheck the duration column and this will hide the column from my table. Additionally, I could customize the column selector's filtering by going back into design mode and right clicking into the components column selector customizer, under customizers.
[01:12] If I select my dataset, I have an option to exclude certain columns from selection. I'll check off the timestamp column here and hit okay. This made it so I can no longer filter the timestamp column's, visibility from the column selector. Our column does still remain on the filterd table. Finally, the column selector does allow for filtering on multiple data sets. To do this, I'll go back into the customizer. If I hit the plus button, I can actually add a new data set. I'll name this one, data two and hit okay. I can rearrange which data set is displayed first in the component with these green arrows. So I'll move data two to the top and I'll hit okay on the customizer to apply the changes. You can see the data two dataset was added to the component. However, no data in property is bound to it, so no columns exist.
[02:04] If I scroll down in the property editor here, you'll see some new custom properties, were added. Data two in and data two out. I'll bind my data two in property to the data property of raw data two, and I can add a new table here to capture the data out property of our data two data. If I go into preview mode, I can filter both data sets from the one component. This makes the column selector a useful filtering tool when working with one or multiple data sets.