AnsweredAssumed Answered

Portal filtering with multiple golbal fields with value lists

Question asked by manuelruizga on Mar 4, 2018
Latest reply on Mar 4, 2018 by erolst

Hi!

 

I need some help for filtering a portal with several golbal fields.

 

First of all, I need a portal to show all related records, then, I need to be able to filter it by using multiple gobal fields.

 

In this particular case, I need 4 global fields called "Fase", "Concepto", "Idioma" and "Procurador". If you click any of these global fields, a diferent value list will pop up depending on the global field selected. All these value list will have a blank option to empty the global field. Only the related records matching the "not empty" global fields must show up.

 

Portal.PNG

Now, I only have showing two records. However, I is thought to have many records.

 

I have seen an aproach using SQL that does exactly this. However, if all the global fields are empty, no records show up.

 

Would you do it by a calculation on the portal filtering feature?

Outcomes