How to pass filter value dynamically in plugin to get Dashboard submission?
submissionId | name | class | feesPaid | gender |
021efrgggi | Binny | 4 | yes | female |
22ercfffse | Vijay | 4 | no | male |
23ertvttww | Raj | 4 | yes | male |
24qeqeeqer | Vinii | 4 | no | female |
Let’s consider the above submissions are save in workflow submission, we need to get values whose feesPaid is yes and gender is female.
there are many ways to do it .
Solution 1: lets create calculator calcGetFilter , hidden fields filter and
plugin plugFetchValues to fetch dashboard submissions.
lets assign values to filter in calcGetFilter as {“$and”:[{“data.feesPaid”:{“$eq”:”yes”}},{“data.gender”:{“$ne”:’male’}}
now in plugFetchValues in input take propertyId as filter (hidden name) and filter in mapping /