195603 - no subject - Hi All,\n\nI have created a report with

Hi All,

I have created a report with few filters. The batch size for the grid is 20. All the filter work fine when the startindex for batch size is 1, but it gives an error when the startindex changes to 21, 41, 61 and so on.

The error it displays is:
Expression evaluation error in rule 'icams_inventoryagingreport' at function a!gridField [line 118]: A grid component [label=“”] has an invalid value for “value” and “totalCount”. “startIndex” must not be greater than “totalCount”, but “startIndex” was 21 and “totalCount” was 1.

Any directions for this one?

OriginalPostID-195603

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    You should put the update of local!pagingInfo in the saveInto of your filter fields not your gridField i.e. the radio and dropdown components

    When you choose a value in one of your filter fields the expression will re-evaluate and your datasubset query will execute using local!pagingInfo hence why it needs resetting.
Reply
  • 0
    Certified Lead Developer
    You should put the update of local!pagingInfo in the saveInto of your filter fields not your gridField i.e. the radio and dropdown components

    When you choose a value in one of your filter fields the expression will re-evaluate and your datasubset query will execute using local!pagingInfo hence why it needs resetting.
Children
No Data