Skip to main content
mollyn6512
November 10, 2022
Question

Error when using function todatasubset() : Expression evaluation error at function 'todatasubset' [line 58]: Invalid field identifier: "6337; 6348; 6353; 6431; 6432; 6619"

  • November 10, 2022
  • 3 replies
  • 0 views

Hi everyone,

I'm having above error message after using a!todatasubset(), my code is as below: 

local!pagingInfo: a!pagingInfo(
    1,
    1,
    a!sortInfo(
      field: local!emailsRelatedToCase.id,
      ascending: false
    )
  ),
  local!datasubset: todatasubset(local!emailsRelatedToCase,local!pagingInfo
  ),

within that, local!emailsRelatedToCase stores data queried from a database to get email IDs and relatedCaseId, sentFrom, sentTo, dateTime for each email.

Did anyone see this error before?

Thanks a lot,

    3 replies

    stefanhelzle0001
    Brainy
    November 10, 2022

    Your sortinfo is wrong. The field must either be the name of the field or the record field reference.

    mollyn6512
    November 11, 2022

    Thanks! Is it possible for me to sort the data in a local variable?

    gopalk2865
    Participating Frequently
    November 11, 2022

    in sort configuration, use your filed name( like id, caseId) instead "local!emailsRelatedToCase.id"