In the User Profile Record Type it uses a rule: a!userRecordFacets to expose a s

@mikec No worries, May I please know what you meant by "I have a column in my table called "lastname". I guess you can only use the attributes of user in the facets as the record is sourced from the User objects in Appian instance. For instance you could use 'lastName' which is an attribute of the User object in Appian.

In order to use 'BETWEEN' operator I would like to suggest to refer section 'User Filters' at https://forum.appian.com/suite/help/7.10/Record_Design.html#User_Filters which gives an example about BETWEEN operator. We do have an illustration as well at this location.

And added to the above, your filters seems correct except one minor issue. I guess we won't be able to use '2' as id in facetOption, as the documentation at https://forum.appian.com/suite/help/7.10/User_Management.html#Add_User_Filters under section 'Add User Filters' says that 'Notice that the IDs used for the filter options in the above expression start with 3. That is because IDs 1 and 2 are already being used for the filter options for the "Status" user filter. Filter option IDs cannot be reused across multiple user filters for the same record type.'. Consider this if you are using Status filter as well.

Hope the above suggestions give you leads.

@mikec No worries, May I please know what you meant by "I have a column in my table called "lastname". I guess you can only use the attributes of user in the facets as the record is sourced from the User objects in Appian instance. For instance you could use 'lastName' which is an attribute of the User object in Appian.

In order to use 'BETWEEN' operator I would like to suggest to refer section 'User Filters' at https://forum.appian.com/suite/help/7.10/Record_Design.html#User_Filters which gives an example about BETWEEN operator. We do have an illustration as well at this location.

And added to the above, your filters seems correct except one minor issue. I guess we won't be able to use '2' as id in facetOption, as the documentation at https://forum.appian.com/suite/help/7.10/User_Management.html#Add_User_Filters under section 'Add User Filters' says that 'Notice that the IDs used for the filter options in the above expression start with 3. That is because IDs 1 and 2 are already being used for the filter options for the "Status" user filter. Filter option IDs cannot be reused across multiple user filters for the same record type.'. Consider this if you are using Status filter as well.

Hope the above suggestions give you leads.