Custom Filter in record view - How to implement cascading drop down ?

Hi All,

 

I am using a record where we have  few custom filter .I have  added the feature of count using the Facet feature, which will show the drop down value like below

For Example: we have a filter like below.

Filter name :Status

==============

Values

-------------------------

Done (10)

Failed (2)

Pending (30)

 

Filter name :Company

==============

Values

-------------------------

IBM(10)

Apple(2)

Google(30)

 

Now we have few more filters like Product ,Company,Quantity etc. So when the record loads it loads the data and loads the different filter with the drop down values and its count from the DB.

Problem statement:

================

 

When any user apply any filter the record will do the filter and shows the respective related record , But the count of the filter also need to be changed as as per the first filter applied .

For example : If we apply the filter for Status as  Done  than the record shows the respective record , but the filter count will remain the same , which logically should change  as per the 

filter applied  , But the problem is I will not able to capture the value of applied filter  and send it back to my query rule which can rerun and evaluate the count .

Please let me know how we can achieve a cascading drop down feature in record  with custom filter. 

Thanks 

 

Manish

 

 

 

  Discussion posts and replies are publicly visible