• State Not Answered
  • Replies 7 replies
  • Subscribers 5 subscribers
  • Views 2380 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

In need to group a column and get count of other column data on output of a query, getting below error

madhubindug

In need to group a column and get count of other column data on output of a query, getting below error:
Expression evaluation error in rule 'bwis_wf_rep_displayrequestcolumnchart' (called by rule 'bwis_wf_rep_displaymanagerialreport') at function a!queryEntity [line 40]: Cannot apply operator [IN] to field [requestId] when comparing to value [TypedValue[it=197,v={}]] for the code i have added.
Please find attached query code.
Thanks,
Madhu

OriginalPostID-174778

 

complete code.txt

  Discussion posts and replies are publicly visible

Parents
  • 0
    @madhubindug Not sure how much this will help you, but as per your code snippet there seems to be a problem with the way you are accessing the 'requestId' attribute in the query filter.

    I guess you it would be worth correcting the value of the queryFilter as shown below and then start debugging.

    In your code snippet:
    value: local!datasubsetDeficiency.data.requesId

    What you should do is:
    value: local!datasubsetDeficiency.data.requestId
Reply
  • 0
    @madhubindug Not sure how much this will help you, but as per your code snippet there seems to be a problem with the way you are accessing the 'requestId' attribute in the query filter.

    I guess you it would be worth correcting the value of the queryFilter as shown below and then start debugging.

    In your code snippet:
    value: local!datasubsetDeficiency.data.requesId

    What you should do is:
    value: local!datasubsetDeficiency.data.requestId
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.