AnsweredAssumed Answered

Portal Filter calculation issue

Question asked by SaiAlb on Dec 11, 2018
Latest reply on Dec 11, 2018 by comment


I am trying to filter my portal using global field. To get things started, I'm trying to filter the unfiltered portal based on a global field "filter_values" in the ActiveState which is a calculation field

When I apply the 1st attempt at filter calculation:

If ( PatternCount ( Labels to Inventory::ActiveState ; Labels to Inventory::filter_values ) > 0; 0; 1 )

Result: only displays record with True regardless of the FilterValue

My 2nd attempt at filter calculation using filtervalues function:

FilterValues ( Labels to Inventory::ActiveState ; Labels to Inventory::filter_values)

Results below:

 

My 3rd attempt at filter calculation using filtervalues function with Not IsEmpty():

not IsEmpty (FilterValues ( Labels to Inventory::ActiveState ; Labels to Inventory::filter_values))

Results only show False records:

 

Please advise.

-Sai

P.S. I Later changed the ActiveState from calculation to text field and manually entered True/False but i got the same results.

Outcomes