Skip to main content
S
shibus8101
September 14, 2023
Solved

The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried

  • September 14, 2023
  • 6 replies
  • 0 views

Objective is to display the firstName of all active users.

a!queryRecordType(
recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User',
fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{firstName}firstName',
filters: a!queryFilter(
field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{active}active',
operator: "=",
value: true
),
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
).data

ref {user() Function - Appian 23.2}

throwing below error 

Expression evaluation error at function a!queryRecordType: The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried because it is a service-backed record type.

Best answer by mathieud0001

Perhaps you need to upgrade the Record Type if you haven't done it before?

Ref: docs.appian.com/.../Configure_Tempo_Users.html

6 replies

mathieud0001
mathieud0001
September 14, 2023

Works for me. Which version are you on?

a!queryRecordType(
  recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User',
  fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_firstName}firstName',
  filters: {
    a!queryFilter(
      field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active',
      operator: "=",
      value: true
    )
  },
  pagingInfo: a!pagingInfo(1, 5000)
).data


S
shibus8101Author
September 14, 2023

Thanks for the reply. I am using version 23.2.

mathieud0001
mathieud0001Answer
September 14, 2023

Perhaps you need to upgrade the Record Type if you haven't done it before?

Ref: docs.appian.com/.../Configure_Tempo_Users.html

    chrisg0006
    chrisg0006
    May 14, 2024

    I had the same issue, but I was pulling the object list from the application specific Appian Designer as opposed to searching for the User Record type from the all applications Appian Designer.  All is now working.

    Terms & ConditionsAccessibility statement