Skip to main content
mollyn6512
Known Participant
Nov 10, 2022 8:54 AM UTC
Question

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

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
    Nov 10, 2022 12:28 PM UTC

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

    mollyn6512
    Known Participant
    Nov 11, 2022 2:53 AM UTC

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

    gopalk2865
    Participating Frequently
    Nov 11, 2022 6:58 AM UTC

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