Hi friends, Is it possible to append two datasubsets and show it in the single grid which is total count differen? Business Case: Initially the application was task based , now client wants it to be record based. I have added the related actions. Now I want to show all the active tasks from old report ( which is from task based ), new tasks from the related actions . I am unable to do this because of the total count issue. In my old report I have 3 tasks and new report I have 6 tasks. And if suppose I give the batchsize=3 . I am getting the below error A grid component [label=“”] has an invalid value for “value” and “totalCount”. “startIndex” must not be greater than “totalCount”, but “startIndex” was 4 and “totalCount” was 3. Here is code load(local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize:3 ), with( /* Fetching the datasubsets here */ local!tempData:append(index(local!datasubsetOldTaskList,"data"), index(local!datasubsetNewTaskList,"data") ), local!tempDataSubset: todatasubset( local!tempData, local!pagingInfo ))
Discussion posts and replies are publicly visible
Hi friends,
Is it possible to append two datasubsets and show it in the single grid which is total count differen?
Business Case: Initially the application was task based , now client wants it to be record based. I have added the related actions. Now I want to show all the active tasks from old report ( which is from task based ), new tasks from the related actions .
I am unable to do this because of the total count issue. In my old report I have 3 tasks and new report I have 6 tasks.
And if suppose I give the batchsize=3 .
I am getting the below error
A grid component [label=“”] has an invalid value for “value” and “totalCount”. “startIndex” must not be greater than “totalCount”, but “startIndex” was 4 and “totalCount” was 3.
Here is code
load(local!pagingInfo:
a!pagingInfo(
startIndex: 1,
batchSize:3 ),
with( /* Fetching the datasubsets here */
local!tempData: append(index(local!datasubsetOldTaskList,"data"),
index(local!datasubsetNewTaskList,"data") ),
local!tempDataSubset: todatasubset( local!tempData, local!pagingInfo )
)
Hi,
try using a!datasubset,
=load( local!dataSubset1 : <my dataSubset>, local!dataSubset2 : <my dataSubset>, local!mainDatasubset : a!dataSubset( startIndex : 1, batchSize : 3, sort : a!sortInfo(field:"Id"), totalCount : local!dataSubset1.totalCount + local!dataSubset2.totalCount, data : append(local!dataSubset1.data,local!dataSubset2.data), identifiers : append(local!dataSubset1.identifiers,local!dataSubset2.identifiers) ) )
Thanks
Vinay