User existence check

Question

Is there any other way to check user existence in the appian except with persisted value in table? OriginalPostID-248067

Mike Schmitt · Answer

Jose Castellot said: is there any other way to achieve this? 
 zombie thread much? 
 But in all seriousness - With the current state of the User Record, I've found that the best (and arguably fastest) username-checking routine is now to use a custom-built expression rule that queries said Record type. It's also the only solution I've found that treats the username as case-insensitive enough to work without laborious other bending-over-backwards workarounds (like you need to use with the "isUsernameTaken()" and "isusernameavailablefornewaccount()" type rules). 
 a!localVariables(
 local!username: a!defaultValue(trim(ri!username), "-=-=-"),
 
 local!userQuery: a!refreshVariable(
 refreshAlways: true(),
 value: if(
 local!username = "-=-=-",
 a!map(totalCount: 0),
 a!queryRecordType(
 recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User',
 pagingInfo: a!pagingInfo(1, 1),
 fetchTotalCount: true(),
 fields: {'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active', 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_uuid}uuid'},
 filters: a!queryLogicalExpression(
 operator: "OR",
 filters: {
 /* doing this to rule out lowercase username first, as it's the normal way we try to initialize them */
 a!queryFilter(
 field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username',
 operator: "=",
 value: lower(local!username)
 ),
 a!queryFilter(
 field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username',
 operator: "=",
 value: local!username
 )
 },
 logicalExpressions: {
 a!queryLogicalExpression(
 operator: "AND",
 
 /* these will require the username to match exactly except for casing */
 filters: {
 a!queryFilter(
 field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username',
 operator: "starts with",
 value: local!username
 ),
 a!queryFilter(
 field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username',
 operator: "ends with",
 value: local!username
 )
 }
 )
 }
 )
 )
 )
 ),
 
 /* tool written by: Mike Schmitt */
 
 if(
 local!userQuery.totalCount = 0,
 a!map(
 exists: false(),
 username: if(local!username = "-=-=-", "(none provided)", local!username)
 ),
 a!map(
 exists: true(),
 username: tostring(local!userQuery.data['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_username}username']),
 uuid: local!userQuery.data[1]['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_uuid}uuid'],
 isActive: local!userQuery.data[1]['recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{SYSTEM_RECORD_TYPE_USER_FIELD_active}active']
 )
 )
) 
 invalid username: 
 active (test) user: 
 inactive user: 
 same user but with mismatched casing: