nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter table row values using script

RepBIRT

The table should display values from the dataset based on the some condition.
Say for example, the dataset values are

Id Name Salary
1 x 100
2 y 120
3 z 90

I want to show only salary values greater than 100 in the table. If the values are less than 100 the entire row should not be displayed in table.

It should be handled using scripts and not using the query.
Any ideas / references would be of great help.

Find more posts tagged with

Comments

CBR

Click on the table. Click on Filters tab in the property editor, click on add.. button.
Enter condition in the dialog.

In your case select the dataset row that is used to filter the rows on your table, select greater then as condition enter value in the input field to the right.
This feature only filters the rows on the table. Your dataset will be uneffected.

RepBIRT

Thanks for your response.

Actually looking for something that can be done through the script. Any ideas would be of great help.

CBR

This can be done using scripting. just provide any complex expression in the first field. You only have to return some value (e.g. boolean true or false). After that change condition to is True.
The dialog looks quite restricting at first glance which isn't true at all.