• State Not Answered
  • Replies 23 replies
  • Subscribers 4 subscribers
  • Views 6718 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Im having an issue trying to display a portal report in SAIL.

benjamins

Im having an issue trying to display a portal report in SAIL.
I have a column in my portal report for assignee which may contain multiple entries and it displays fine when viewing my report in designer.
However, when I am trying to display the portal report in my SAIL code, I cannot get the multiple assignees to be displayed.
I am trying to display the portal report in a gridField and have the particular SAIL code to display the assignees is here:

a!gridTextColumn(
label: "Assignee",
data: if(
local!datasubset.totalCount = 0,
{},
local!datasubset.data[4].cells.value
)
)

The error that I get is:

Interface Definition: Expression evaluation error at function a!gridField [line 38]: A grid component [label=“”] has an invalid value for “columns” and “value”. All “data” arrays must not contain more items than the specified “batchSize”, but “batchSize” was 20 and the largest ...

OriginalPostID-143743



  Discussion posts and replies are publicly visible

Parents
  • 0
    Assignees column contains multiple text values separated by ; .
    I think it is giving count of assignees is more than the specified batch size. If you want to know the root cause clearly, you can try to print the datasubset and count of Assignees.
    I faced similar issue previously, we can solve that by using support rule of concat the assignees .

    a!gridTextColumn(
    label: "Assignee",
    data: apply(rule!SupportRule,index(local!datasubset.data, "Assignee"))
    )

    Support rule:

    If(count(ri!assignees) > 1, joinarray(ri!assignees,","), ri!assignees)

    I hope it will solve that issue.
Reply
  • 0
    Assignees column contains multiple text values separated by ; .
    I think it is giving count of assignees is more than the specified batch size. If you want to know the root cause clearly, you can try to print the datasubset and count of Assignees.
    I faced similar issue previously, we can solve that by using support rule of concat the assignees .

    a!gridTextColumn(
    label: "Assignee",
    data: apply(rule!SupportRule,index(local!datasubset.data, "Assignee"))
    )

    Support rule:

    If(count(ri!assignees) > 1, joinarray(ri!assignees,","), ri!assignees)

    I hope it will solve that issue.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.