This lesson is part of the Reporting in Ignition course. You can browse the rest of the lessons below.

LESSON LIST

Autoplay Off
Take topic challenge

Description

Explore the Row Selector component that comes in the Reporting module. This component provides a graphical interface which lets you filter data based on time, category, or grouping

Video recorded using: Ignition 7.9

Transcript

(open in window)

[00:00] The row selector is a component that's included with the reporting module. You'll find the component listen under "Reporting" in the component palette. There are two important properties: "Data In" and "Data Out". The component will filter the "Data In" dataset and push the filter results to the "Data Out" property. Let's begin by bringing the dataset on our raw data table into the "Data In" property. The raw data table up here is simply querying some data from our database. We'll start by selecting the row selector and clicking the binding icon on the row selector's "Data In" property. We'll select a property binding, find our raw data table and the data property there, and click OK. Next we'll select our filtered data table and we'll bind the data property on the table to the row selector's "Data Out" property, which we'll find under "Row Selector", "Data Out", and click OK. If we put this into preview mode, you'll see that the row selector's grouping our data by month and year. We can drill down to day, and it's based off of the "t_stamp" column here. We can also drill down to each hour. Let's take a look at how the data's being filtered. If we leave preview mode and right-click on the row selector, go down to "Customizers" and "Row Selector Tree Customizer". You can see there are multiple filters here. Each one of them's looking at the "t_stamp" column. We can reorder how the filters are applied. We can also change the icon path, so instead of having a folder let's go ahead and drill down to other icons, and we'll change this to the calendar. You can change how each filter is displayed in the row selector with this "Format String" property. We can click on this little calendar icon here and select a pre-made one or just type directly into it. Let's go ahead and add the rest of the year here so it matches up with how the "t_stamp" column looks. We'll click OK. You can see that the format on the top filter has been changed. Now if we put this back into preview mode, if we click on each hour the filter data table updates with only results from that hour, day, month, and year combination. We can also pick a specific day or even just the entire month's worth of data. It's important to note that you don't have to filter by the timestamp. You can use the other columns. If we take this out of the preview mode, right-click, we'll go back to our customizer. And we can just delete all these and let's go ahead and filter instead by equipment. And cause, you can also click on the little arrow over here to bring it over. Let's go ahead and reorder these, though. There we are, click OK. You'll see that the row selector's grouping our data by piece of equipment. If we put the Designer into preview mode, we can drill down to each cause for each piece of equipment. Lastly I wanted to note that you don't need both tables on the window here. The raw data table's really just to show you what the data looks like before it's filtered. Really, you could take the query that's on the data binding for the raw table and just move it to the "Data In" property on the row selector.

You are editing this transcript.

Make any corrections to improve this transcript. We'll review any changes before posting them.