Trying to filter out the values from the records

Hi,

I'm trying to filter out the values from the records. All the filter and display values are passed as arryas
Expression evaluation error at function a!gridField [line 61]: Array is expected as second parameter, but received: .

Can someone suggest where the issue persist.

Report.txt

OriginalPostID-137239

OriginalPostID-137239

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Senior Developer
    Hi Deepan,

    The error is due to apply function in the code to get formatted users where there is no data after filtering.

    In that case to avoid this error you can use '{}' instead of 'null' in your code and it will show a empty grid with 'No items available' message. For example in Analyst column you can use this 'data:apply(rule!getFormattedUserName,index(local!datasubset.data,"Analyst",{})) '.
Reply
  • +1
    Certified Senior Developer
    Hi Deepan,

    The error is due to apply function in the code to get formatted users where there is no data after filtering.

    In that case to avoid this error you can use '{}' instead of 'null' in your code and it will show a empty grid with 'No items available' message. For example in Analyst column you can use this 'data:apply(rule!getFormattedUserName,index(local!datasubset.data,"Analyst",{})) '.
Children
No Data