Reference qualifier in catalog item reference field

[CCZMAX1]

Hi, I have a reference variable with a reference qualifier that correctly displays the fields I want in the dropdown. However, I’ve noticed that the search does not perform a wildcard (contains) search within the reference field.

For example, if the title field contains "Knowledge article creation best practice," the search does not return this row when I type "article." Instead, I must start the search with "Knowledge."

Is this because the autocomplete only searches from the beginning of the field rather than anywhere within the string? If so, is there a workaround to enable contains search in the reference field?

Here is my reference qualifier

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_number;title,ref_ac_columns_search=true,ref_ac_order_by=title

Many thanks

Max

[Ankur Bawiskar · Accepted solution]

@CCZMAX1 

that's the platform behavior.

If you start typing then only it will start searching

To perform contains search you need to type in *article and it should show the result

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@CCZMAX1 

that's the platform behavior.

If you start typing then only it will start searching

To perform contains search you need to type in *article and it should show the result

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Vaibhav_Nikam · Accepted solution]

Hi @CCZMAX1 ,

Can you please check the below article?

How can I do a contains search on 'name' as well as other fields for a Reference variable? 

[CCZMAX1]

Thank you for this. That system property explicitly tells you that contains will work when set to false.