This is an implementation using globals for user name search.
You can use this algorithm to favor the search of individuals
This application contains a Person table populated with many users, where the search takes place through the users Name, FirstName, MiddleName and LastName.
Clone/git pull the repo into any local directory
$ git clone https://github.com/Davi-Massaru/global-name-search.git
Open the terminal in this directory and run:
$ docker-compose build && docker-compose up -d
Use this feature in a scenario where there is a many volume of data and you need to return a limited length of records, for example, when selecting selects or datacombos.
This technique allows the data to be returned faster and also with a much smaller amount of global accesses than a "SELECT TOP", for example.
Open the Manegement Portal and try execute the selects:
SELECT TOP 500 ID, Name FROM dc_data.Person WHERE Name LIKE '%jose%'
SELECT ID, Name FROM dc_data.Person WHERE ID %INLIST dc.GetListIdsByName('jose',,,500)