Skip to main content
manavik105
manavik105
May 27, 2025
Question

Datastype subset is coming as object,object instead of real data values when passed in process model

  • May 27, 2025
  • 6 replies
  • 0 views

Hi All,

I have a query rule as below and when passing to the process model, output is coming weird as Data: object,object. Please help!!

Expression rule output -

[startIndex=1, batchSize=1, sort=[field=updatedDateTime, ascending=false], totalCount=-1, data=[caseId:123,IDNumber:122567,caseStatus:On-Hold/Request for Info,clientName:user155678,folderId:1267888], identifiers=322]

When same rule passed and saved to pv of type datasubset in process Model:

[startIndex=1, batchSize=1, sort=[field=updatedDateTime, ascending=False], totalCount=-1, data=[object Object], identifiers=322]

6 replies

davidj137213
davidj137213
May 27, 2025

Have you tried indexing the object to see if you can work with the data?

manavik105
manavik105Author
May 27, 2025

Thank you for the response [mention:d173d3118db546878c1f717bfba87080:e9ed411860ed4f2ba0265705b8793d05]   

yeah but I want to get the whole datasubset value and indexing would kill that right? For example, in my script task output I'm just calling rule!getuserdata(user: pv!userdetails) and saving this to a pv of type datasubset. 

davidj137213
davidj137213
May 27, 2025

Not necessary, maybe is just the way that appian shows the information inside your process. That's why I asked if you are able to access the data.

varuntejg243705
varuntejg243705
May 28, 2025

Hi [mention:07380a99cd9a4931a32956f0ec3a7923:e9ed411860ed4f2ba0265705b8793d05] ,

You can simply index by storing the above query in a local variable or directly using index() function.

a!localVariables(
  local!data:a!queryEntity_22r2(
  entity: cons!ABC_ENTITY_USERS,
  query: a!query(
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 1,
      sort: a!sortInfo(field: "updatedDateTime")
    ),
    selection: a!querySelection(
      columns: {
        a!queryColumn(field: "caseId"),
        a!queryColumn(field: "caseStatus"),
        a!queryColumn(field: "folderId")
      }
    ),
    logicalExpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "caseId",
          operator: "=",
          value: ri!clientCases.caseId,
          applyWhen: not(
            rule!APN_isBlank(ri!clientCases.caseId)
          )
        ),
        a!queryFilter(
          field: "caseStatus",
          operator: "not in",
          value: {"STARTED"},

        ),
        a!queryFilter(
          field: "docsSent",
          operator: "is null"
        )
      }
    )
  )
),
index(local!data,"data",{})
)

Terms & ConditionsAccessibility statement