• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 4 subscribers
  • Views 2460 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Problem with inserting an image in a grid for a report

marcoc200

Problem with inserting an image with the light of the status of the process in a grid for a report.
The error is at the line 150 and 156 of the xml and the the definition of the rule!testColor2 is:
= if ( ri!value = "" , cons!ICON_GREY_GLASS , if ( ri!value = 0 , cons!ICON_RED_ALERT , if ( ri!value = 1 , cons!ICON_YELLOW_GLASS , if ( ri!value = 2 , cons!ICON_GREEN_GLASS , if( ri!value = 5 , cons!ICON_DARK_GLASS , if( ri!value = 3 ,cons!ICON_ORANGE_GLASS , cons!ICON_BLUE_GLASS ) ) ) ) ))
with all the constants of type document linked to an image document and the ri!value a variable of type number integer that change during the process

Sail Error.xml

OriginalPostID-145898

OriginalPostID-145898

  Discussion posts and replies are publicly visible

Parents
  • 0
    Hi Please remove the extra right parenthesis present after the apply function as follows:

    Before change:
    data: apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{null},index(local!datasubset.data, "lightRequest", null))),null,null,null))

    After change:
    apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{null},index(local!datasubset.data, "lightRequest", null))),null,null,null)

    Please debug the code again after removing the above syntax error.
Reply
  • 0
    Hi Please remove the extra right parenthesis present after the apply function as follows:

    Before change:
    data: apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{null},index(local!datasubset.data, "lightRequest", null))),null,null,null))

    After change:
    apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{null},index(local!datasubset.data, "lightRequest", null))),null,null,null)

    Please debug the code again after removing the above syntax error.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.