I have a assignees column in task portal report which may have multiple values.

shaoyongw over 9 years ago

I have a assignees column in task portal report which may have multiple values. When I convert it to a sail report, get an exception. I tried to convert the assignees into a text by using joinarray(doforeach(rule!getDisplayNameForUserOrGroup, tp!assignees), ",") but it was not working. Any idea?

at function a!gridField [line 28]: A grid component [label=“”] has an invalid value for “totalCount”. “totalCount” must not be null or less than the number of items in any of the “data” arrays, but “totalCount” was 1 and the largest column data array had 2 items. (APNX-1-4218-025)

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 9 years ago

@shaoyongw I would like to suggest to apply the formatting after obtaining the data from portal report. This means that I would like to suggest to refrain from doing the conversion in portal report because very few functions work in portal report and also Appian has specified the same in the documentation that some functions, for instance scripting functions in particular won't work in portal report.

Further I would like to suggest to check if there is a problem with any other columns other than this tp!assignees. If you are doubtful regarding the source of error, please go ahead with attaching the code here so that the practitioners can throw light on the error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@shaoyongw I would like to suggest to apply the formatting after obtaining the data from portal report. This means that I would like to suggest to refrain from doing the conversion in portal report because very few functions work in portal report and also Appian has specified the same in the documentation that some functions, for instance scripting functions in particular won't work in portal report.

Further I would like to suggest to check if there is a problem with any other columns other than this tp!assignees. If you are doubtful regarding the source of error, please go ahead with attaching the code here so that the practitioners can throw light on the error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data