The Auto-Complete feature with reference variables does not work when the target table display field is a translated text, when the instance language is switched to any language other than English.


Steps to Reproduce

1. Activate an I18N language plugin like French, but stay on the instance with English activated.
2. Set a catalog item with one reference variable in it.
3. Set the reference variable to point to a table which has translated text field as their display name.
4. For example sc_cat_item:
set the reference to be simple,
set filter active=true
set atrrbiutes to "ref_auto_completer=AJAXTableCompleter,ref_ac_columns_search=true,ref_ac_columns=category"
5. Set a couple of catalog items with name starting with the keyword "test", and make sure the French translations created for them in the sys_tranlated_text table also have names starting with "test".
6. Set the catalog items above to active=false to test the reference qualifier set at step 4.
7. Open the catalog item and click on Try.
8. Test the reference qualifier via entering the keyword "test". It will return data which matches with the filter and qualifier set at step 4.
9. Switch the instance language to French.
10. Try the same catalog item with the reference variable with the keyword "test".
On pre-Jakarta instances the system will fetch the items which are not active as well, so the reference qualifier is not honoured.
Since Jakarta, the Autocomplete does not work at all in a non-English language.



This issue is under investigation and targeted to be fixed in a future release. You can Subscribe to this known error article to receive notifications when more information will become available.


Related Problem: PRB1246836

Seen In

There is no data to report.

Intended Fix Version

Jakarta Patch 9
Kingston Patch 5

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-21 21:52:33