How to get search result when we search users by using last name followed by first name

[Veda3]

In the form and in portal when we search for users by.

• 1.First name
• 2.Last name 
• 3.First name followed by last name(first name_last name)
• 4.Last name followed by first name(last name_first name)
• All 1,2,3 use cases are working when I added last name in reference field attribute.But when we search with 4th use case last name followed by first name results are not coming .How to get the search result 

[Slava Savitsky · Accepted solution]

Use cases 1–3 work because for each of them there is a field in the User record that stores exactly that information:

1. First Name

2. Last Name

3. Name (which by default is concatenated from First Name + Last Name)

The 4th use case is not supported out of the box. To make it possible to search like that, you need an additional field in the User record where you would store the first and last name in reverse order (i.e. Last Name + First Name).