valueFilter option #68

Activity

1. gmacias711

   closed this as completedon Mar 13, 2019
2. JonasWangLilly commented on Mar 14, 2019

   

   JonasWangLilly

   on Mar 14, 2019

   More actions

   Did you manage to find the answer to your question? If so do you mind sharing?
3. gmacias711 commented on Mar 18, 2019

   

   gmacias711

   on Mar 18, 2019

   Author

   More actions

   What I ended up doing was create a function that sets up the value filter and sets all colors to false, omitting the dynamic color.

   filterColors(){
       var Colorarray = ["Blue", "Red", "Orange", "Yellow", "Purple", "Green", "Black"];
   	var valueFilter = {};
   	var filterObj = {};
   	for(var j = 0; j < Colorarray.length; j ++)
   	{
   		if(Colorarray[j] !== this.state.selectedColor)
   		{
   			filterObj[Colorarray[j]] = false;
   		}
   	}
   	valueFilter["Colors"] = filterObj;
   	return(valueFilter);
   }
   
   <PivotTableUI
       valueFilter={this.filterColors()}
   
4. aboulang commented on Jul 9, 2022

   

   aboulang

   on Jul 9, 2022

   More actions

   I think this may be an implementation issue. From what I can tell the intent was for

   var valueFilter = {"Colors":{"Green": true}};

   to do what gmacias711 expected. Looks like Nicolas merged inclusions and exclusions parameters from pivotable.js (see https://github.com/nicolaskruchten/pivottable/wiki/Parameters about Pivotable.js's inclusions and exclusions parameters ) into one valueFilter but it is not handling the inclusions side correctly. It can be cumbersome to have to collect all the exclusions instead of what should be included -- especially if valueFilter is a prop that currently can not be modified! This is biting me.