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
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
As far as my knowledge this can't be accomplished in records. However you can achieve the same in reports. Create a report similar to records and you can have the filter options defined as you want.
Yeah I know that it is not possible .. So I posted to know others view on that...or is their any hack is there to achieve that ..