Hi everyone, I'm trying to use dropdown component in Perspective to filter out the rows of a power table with expected value.
The easiest way is to create your column data and enabled filtering on the column.
EDIT: this method works well for user based filtering. If the filter should be scripted, you'll probably have to loop over the dataset and create a new dataset based on your filter range. This works well with the Integration Toolkit module which can iterate in an expression binding, and it's free.
Automation Professionals' Integration Toolkit Module - 3rd Party Modules - Inductive Automation Forum
Thank you for the reply!
I have created the columns data under the property of the power table then activated filter but it wouldn't give me the option for "between". Is there anything else I need to turn on? I am going to use this filter for the last column that contains 90's only.
Try setting,
columns.4.render : number
It should then use all the conditions in the
columns.4.render.number.condition
dropdown instead of all those in the
columns.4.render.string.condition
dropdown.
Realized that the data type of the column was string instead of number. The problem was the query. It works after modified. Thanks for the idea anyway!
Thank you for the solution! It works just fine for my project.
Also thanks for sharing the info of the Module. I was going to bind a script to achieve this target, but I'm lack of experience of using it. Is there any resource and examples I can find online?
