Solved

Filtering Picklist value at 4th level in Data Designer

  • 5 March 2020
  • 1 reply
  • 39 views

Badge +1

Hi,

 

I'm creating a new design using Data Designer - I'm trying to get opportunities for Active customers only. If I have to put this filter the hierarchy flows as,

Opportunity -> Account Id (Account) -> Customer Info -> Status

In this flow, Status is also a lookup field but since it is at 4th level I'm using Id value for 'Active' status from Picklist object. Is there a better way of filtering where we can use value to filter the record instead of filtering using the Id of that picklist field?

 


 

icon

Best answer by rakesh 8 April 2020, 19:34

View original

1 reply

Userlevel 6
Badge +1

Hi @phaneendhar_lingam 

A lookup is nothing but a predefined join. I recommend splitting that into a join (merge). In this example :-

Fetch data from customer info separately, which allows you to go as 3 levels deep again (Customer Info → Status → Name / Label).

Merge Customer Info and Account data and apply filter here

 

This will also result in better UI performance as well. 

Reply