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
Discussion posts and replies are publicly visible
I think I a missing some details. Can you explain a bit more and provide screenshots of what you already have?
I have implemented these based on totalcount for each status. But now I have to do dynamically based on user filter
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.
I'm a little unclear what your code is doing in the background, so a code snippet (please make sure to use the "insert code" feature) would be helpful. However, i'll go ahead and risk suggesting that you might be able to filter your "status count" queries with the same filters that you're using to filter your main grid - depending of course on how you're fetching those values in the first place.
© 2022 Appian. All rights reserved.