List Collector doesnt works for non english language when variable has ref_ac_columns and ref_ac_columns_search attributes - Support and Troubleshooting

List Collector doesnt works for non english language when variable has ref_ac_columns and ref_ac_columns_search attributes .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } }

Issue:

In the service portal, when we access a catalog item with a variable that references the user table and the logged-in user doesn't pass the query_range ACL, then the dropdown list of users is empty when the user language is non-English, however, the dropdown has values when the language is English. This is because there is a difference in the query string that is generated for English and non-English sessions.

Steps to reproduce:

1. Create a catalog item and create a variable that references sys_user table. 2. Specify the variable attribute as ref_auto_completer=AJAXTableCompleter,ref_ac_columns=user_name;email;name;first_name;last_name;middle_name 3. Ensure you have a non-English language plugin installed e.g. German. 4. "glide.service_portal.reference.sort_by_language" system property is set to true 5. Ensure your language is English. 6. Go to https:// .service-now.com/sp?id=sw_sc_cat_item&sys_id= 7. Click on the drop down for the User field. 8. Open the Networks tab in your browser console. 9. The angular.do request payload has query string as "user_nameSTARTSWITH^user_nameISNOTEMPTY^NQemailSTARTSWITH^emailISNOTEMPTY^NQnameSTARTSWITH^nameISNOTEMPTY^NQfirst_nameSTARTSWITH^first_nameISNOTEMPTY^NQlast_nameSTARTSWITH^last_nameISNOTEMPTY^NQmiddle_nameSTARTSWITH^middle_nameISNOTEMPTY^ORDERBYname^EQ" 10. Change your language to German. 11. Repeat 6-8 12. The angular.do request payload has query string as "user_nameSTARTSWITH^NQemailSTARTSWITH^NQnameSTARTSWITH^NQfirst_nameSTARTSWITH^NQlast_nameSTARTSWITH^NQmiddle_nameSTARTSWITH^ORDERBYname^EQ"

This results in inconsistent output if the user doesn't pass the query_range ACL. The dropdown is empty for non-English, whereas the values are populated for English.

Resolution:

This is known error PRB1978655 which is under investigation.