This post is more than 5 years old
10 Posts
0
1977
Filtering not matching values from expansion
Hi all, I'm trying to generate a report displaying all storage volumes who don't have a corresponding item in the ViPR volume list.
At the moment I'm able to join values through a complex expansion and obtain a full list of volumes, with a "ViPR" column displaying empty values for volumes not matching the expansion. Is there a way to filter out non empty fields on this column?
Thanks!
Sooksun_CCI
14 Posts
0
June 27th, 2017 06:00
If I understand correctly, you have a "Value" type in the table that you want to filter. I've never done that before however, there are value filters you can play with. When you go into Report Details where you are setting your table up, expand the "Value" you want to filter on and go to the "Advanced Properties"; check in the box for "Allow filtering on this value?" and you will get a filter bar to edit.
Is this what you might be looking for?
Sooksun_CCI
14 Posts
0
June 23rd, 2017 11:00
Hello liv913,
In your filtering, have you tried to filter for (wizard):
"volume" "is not present"
or with the manual edit:
& !volume
liv913
10 Posts
0
June 26th, 2017 04:00
Well, the problem is that column I want to filter contains a property coming from a formula in a nested object.
If I'm not wrong, in the "Filtering & Expansion" tab I cannot put formula results...
isakats
141 Posts
0
June 28th, 2017 06:00
Hi liv913,
As sooksun_cci mentioned you can use JEXL to filter on values, if you are looking to filter on a property column, you can use regular expressions by expanding the Advanced Properties tab and changing the Display Customization and/or Condition
Regards,
Isaka
liv913
10 Posts
0
June 30th, 2017 02:00
Well, this seems to hide the full column, but it doesn't filter rows basing on the column condition...
liv913
10 Posts
0
June 30th, 2017 03:00
Great, this seems the solution!
Do you know if it's possible to hide the column keeping the filter active? It seems that visibility is mutually exclusive with filtering enabled.
Sooksun_CCI
14 Posts
0
June 30th, 2017 07:00
It should be possible. When you are in the advanced properties, there is the "Display Customization" where you can hide the column, but you also want to make sure the "Display Condition" is show or equal to show.
That has worked for me.
liv913
10 Posts
0
July 20th, 2017 03:00
Would it be also possible to filter one or more properties, being them an output from a formula coming from a child node?