The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried

Question

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.

Mathieu Drouin · Accepted Answer

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

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

Mathieu Drouin · Answer

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

Mathieu Drouin · Answer

I would assume it requires admin privileges. 
 If this answer helped you, please consider marking it as verified so that other users who have the same question can quickly find the answer to their question.

Chris.Gillespie · Answer

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.

The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried

Top Replies