Skip to main content
saurabhs0003
saurabhs0003
December 1, 2021
Question

How to fetch count based on filter

  • December 1, 2021
  • 4 replies
  • 0 views

Hi All ,

I am showing a pattern like bar chart in an interface i.e Total , Approved , Rejected etc . Now what I am doing is showing total count in the respective field but now as per requirement I want to show the count based on user filter .

For example Approved total request is 10 , now user filter the approved , and  the data displayed in the grid(1-5) has only 3 Approved . Then I have to change the 3 instead of 10. How to achieve this .

Thanks in Advance

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    December 1, 2021

    I think I a missing some details. Can you explain a bit more and provide screenshots of what you already have?

    saurabhs0003
    saurabhs0003Author
    December 1, 2021

    I have implemented these based on totalcount for each status. But now I have to do dynamically based on user filter 

    peter.lewis
    peter.lewis
    Employee
    December 1, 2021

    It isn't possible to apply a user filter to a query - user filters only apply to grids. However, it still is possible to create a dropdown field to simulate creating a user filter. This recipe isn't exactly what you're looking for but it can give you an idea on how you could create a dropdown field that could store a value and then apply the results to a query.

    Terms & ConditionsAccessibility statement