AnsweredAssumed Answered

Portal Filtering - too many cases needed

Question asked by glorifindal on Apr 28, 2015
Latest reply on Jun 7, 2015 by erolst

Greetings

 

I'm filtering a portal with 5 drop down fields … and beginning to despair of ever getting to the end of the Case statements needed...

 

The following is JUST for ONE field ...

Case(

// 1 field

not IsEmpty( field1 ) and IsEmpty( field2 ) and IsEmpty( field3 ) and IsEmpty( field4 ) and IsEmpty( field5 ) ; field1.s = field1 ;

IsEmpty( field1 ) and not IsEmpty( field2 ) and IsEmpty( field3 ) and IsEmpty( field4 ) and IsEmpty( field5 ) ; field2.s = field2 ;

IsEmpty( field1 ) and IsEmpty( field2 ) and not IsEmpty( field3 ) and IsEmpty( field4 ) and IsEmpty( field5 ) ; field3.s = field3 ;

IsEmpty( field1 ) and IsEmpty( field2 ) and IsEmpty( field3 ) and not IsEmpty( field4 ) and IsEmpty( field5 ) ; field4.s = field4 ;

IsEmpty( field1 ) and IsEmpty( field2 ) and IsEmpty( field3 ) and IsEmpty( field4 ) and not IsEmpty( field5 ) ; field5.s = field5 ;

// 2 fields

etc, etc

)

All that for just using one field in the filter

Is there some way of avoiding this Case madness? The amount of possible combinations for 5 fields is silly to enter into a filter I think

Orr perhaps I'm just being plain stupid here...

 

Kindest

 

Glorifindal

Outcomes