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

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
  • OK.... tostring() will display just the first entry. So in my screenshot previously, it just displayed my name, but not the second user (Even if I removed all the other columns so it is not a display issue).

    Trying the solution provided by radhaa, I get the same as above. Just one entry.

    Trying the solution provided by christens and harrys...

    a!gridTextColumn(
    label: "Assignee",
    data: if(
    local!datasubset.totalCount = 0,
    {},
    apply(
    rule!IIR_displayAssigneeData(
    data: index(
    local!datasubset.data[4].cells,
    "value",
    null
    ),
    index: _
    ),
    1 + enumerate(
    local!datasubset.totalCount
    )
    )
    )
    )


    supporting rule:
    = tostring(
    ri!data[ri!index]
    )

    If I make the data input of type text, I get the same error as before...

    Interface Definition: Expression evaluation error at function a!gridField [line 37]: 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 column data array had 23 items.

    I've attached the assignees definition if that helps.


Reply
  • OK.... tostring() will display just the first entry. So in my screenshot previously, it just displayed my name, but not the second user (Even if I removed all the other columns so it is not a display issue).

    Trying the solution provided by radhaa, I get the same as above. Just one entry.

    Trying the solution provided by christens and harrys...

    a!gridTextColumn(
    label: "Assignee",
    data: if(
    local!datasubset.totalCount = 0,
    {},
    apply(
    rule!IIR_displayAssigneeData(
    data: index(
    local!datasubset.data[4].cells,
    "value",
    null
    ),
    index: _
    ),
    1 + enumerate(
    local!datasubset.totalCount
    )
    )
    )
    )


    supporting rule:
    = tostring(
    ri!data[ri!index]
    )

    If I make the data input of type text, I get the same error as before...

    Interface Definition: Expression evaluation error at function a!gridField [line 37]: 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 column data array had 23 items.

    I've attached the assignees definition if that helps.


Children
No Data