AnsweredAssumed Answered

Filtering portal with 3 global fields

Question asked by cillion on Mar 20, 2016
Latest reply on Apr 18, 2016 by cillion

Hi guys!

Im trying to filter a portal on the parent layout where I have 3 global fields. Now its just the one projectname who is working as needed.

The Function and industy is valuelists, if it is easier to do evalate it to that?!

 

My portal filter is now looking like this;

 

Case (

  // ------- DISPLAY ALL

  IsEmpty ( Parent::projectname ) and

  IsEmpty ( Parent::Industry ) and

  IsEmpty ( Parent::Function ) ;

  1 ;

 

 

  // ------- DISPLAY Industry

  IsEmpty ( Parent::projectname ) and

  IsEmpty ( Parent::Function );

  PatternCount ( Project::Industry ; Parent::Industry );

 

 

  // ------- DISPLAY Function

  IsEmpty ( Parent::projectname ) and

  IsEmpty ( Parent::IndustriGroupID );

  PatternCount ( Project::Function ; Parent::Function );

 

 

  // ------- DISPLAY Name

  IsEmpty ( Parent::IndustriGroupID ) and

  IsEmpty ( Parent::FunctionAreaID );

  PatternCount ( Project::Name ; Parent::projectname );

 

 

  // ------- DISPLAY Industry AND Function AND Name

  PatternCount ( Project::Industry ; Parent::Industry ) and

  PatternCount ( Project::Name ; Parent::projectname ) and

  PatternCount ( Project::Function ; Parent::Function )

 

)

Outcomes