Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
4 subscribers
Views
4463 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
How to handle Null total count od data subset
praveenkumark
over 8 years ago
Hi All# we have Converting Portal All request report to tempo report and added filters on that for First 1- 100 records if filter it giving proper results with all status(Completed ,cancel,In-Progress,Etc.) 101 to 200 page if I filter with Cancel ,New,Completed these data not available in 101 to 200 so it giving below error message.
Can any one have suggestion to handle this scenario,
Thanks in advanced
Expression evaluation error in rule 'eumoballrequestreport' at function a!gridField [line 69]: A grid component [label=“”] has an invalid value for “value” and “totalCount”. “startIndex” must not be greater than “totalCount”, but “startIndex” was 101 and “totalCount” was 0.
OriginalPostID-239251
Code.txt
Discussion posts and replies are publicly visible
0
sikhivahans
over 8 years ago
@praveenkumark Upon an interaction with request status(that is, inside its saveInto), reset the startIndex of the pagingInfo and I think that should keep you going. This is what I can say now after having a quick look at your code.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandu
A Score Level 2
over 8 years ago
Hi @PraveenKumar, Please reset the start Index of the PagingInfo with thin the Drop down field using a!save(), when User interacts with the Dropdown, the start Index will be Reset and the Grid shows the data.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
kondetiv
over 8 years ago
May be your problem something related to this. Please refer below link it may help you.
Expression evaluation error at function a!gridField [line 4]: A grid component [label=“My Tasks”] has an invalid value for “columns” and “value”. All “data” arrays must not contain more items than the specified “batchSize”, but “batchSize” was 5 and the largest column data array had 11 items.
Multi-valued cells require some special handling.
forum.appian.com/.../Task_Report_Tutorial.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
The above-mentioned 'Multi-valued cells require some special handling' link is no way related to the issue mentioned in the original post as far as my knowledge is considered. The issue in the post is clearly describing that the totalCount is 0 which means that there aren't any items at all and further, it's clearly stating that startIndex can't be greater than totalCount which happens if we move further in the pagingInfo and there aren't any items in the data due to a fresh query.
Whereas the issue mentioned above comment is the one that occurs when the totalCount is greater than batchSize (and it's obviously different from startIndex greater than totalCount issue) which occurs because of flattening concept afaik.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
praveenkumark
over 8 years ago
Thanks Guys for quick suggestion working fine now
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel