Search by last name - variable attribute in record producer

[miro2]

Hi,
I have a quick question.
In the variable, I have an attribute that displays name and fields from the department. I want to be able to search by last name, but I don't want to display the last name column.

column.ref_ac_columns=department.name;department.id,ref_ac_columns_search=true,ref_ac_order_by=name,ref_auto_completer=AJAXTableCompleter

Currently, it's not possible to search using the last name without displaying it. How can I modify the variable attribute to achieve this?

[Siva Jyothi M]

Hi @miro2,

Since the last name is part of the name, users can search by (*) Last name and it will be visible like below.

Mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.

[miro2]

yeah, I know, but I don't want to use wildcards here
users should be able to type Tuter or tuter and find the user record

[Peter Bodelier]

Hi @miro2,

You cannot directly search on Last name, without displaying it. However, you can enable contains search, without having to use a wildcard.

This will work that way for every reference field if you set that up. So please be aware of this.

Take a look here to see how to set it up.

[miro2]

Hi @Peter Bodelier 
This option works, but I have the OOB glide.ui.ref_ac.startswith system property set to true on the business instance. Changing that and creating '<referenced table>.autocomplete.contains, would result in a global change. On the business instance where the variable attribute is not set, I can search by last name, but the last name column isn't displayed in the reference field.
This configuration is set somewhere on client instance, but I need to customize it in variable attribute slightly to meet my requirements.*
*I had to edit previous post.