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

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
  • Thanks for the correction @#sikhivhans, now am getting below error
    Expression evaluation error in rule 'bwis_wf_rep_displayrequestcolumnchart' (called by rule 'bwis_wf_rep_displaymanagerialreport') at function a!queryEntity [line 99]: Cannot apply operator [IN] to field [requestId] when comparing to value [TypedValue[it=3,v=52404; 52631; 52769; 53395; 53395; 54145; 54617; 55449; 55628; 55628; 55683; 55735; 56005; 56033; 56144; 56144; 56323; 56350; 56350; 268488564; 268488590; 268489011; 268489296; 268489296; 268490148; 268491783; 268491943; 268491990; 268491990; 536927028; 536927094; 536927197; 536927236; 536927236; 536927306; 536927396; 536927396; 536927396; 536927533; 536927633; 536927785; 536928107; 536929618; 536929673; 536929910; 536930052; 536930204; 536930444]].

    Is it like i cannot apply operator IN for this?

    Thanks,
    Madhu
Reply
  • Thanks for the correction @#sikhivhans, now am getting below error
    Expression evaluation error in rule 'bwis_wf_rep_displayrequestcolumnchart' (called by rule 'bwis_wf_rep_displaymanagerialreport') at function a!queryEntity [line 99]: Cannot apply operator [IN] to field [requestId] when comparing to value [TypedValue[it=3,v=52404; 52631; 52769; 53395; 53395; 54145; 54617; 55449; 55628; 55628; 55683; 55735; 56005; 56033; 56144; 56144; 56323; 56350; 56350; 268488564; 268488590; 268489011; 268489296; 268489296; 268490148; 268491783; 268491943; 268491990; 268491990; 536927028; 536927094; 536927197; 536927236; 536927236; 536927306; 536927396; 536927396; 536927396; 536927533; 536927633; 536927785; 536928107; 536929618; 536929673; 536929910; 536930052; 536930204; 536930444]].

    Is it like i cannot apply operator IN for this?

    Thanks,
    Madhu
Children
No Data