Home Applications global-name-search

global-name-search

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
4.5
1 reviews
0
Awards
147
Views
0
IPM installs
0
0
Details
Releases
Reviews
Issues
Pull requests
Implementation using globals indices for user name search.

What's new in this version

Initial Release

Global Name Search

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.

Prerequisites

Make sure you have git and Docker desktop installed.

Installation

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

Get Started

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%'

Result:

Compare to

	SELECT ID, Name FROM dc_data.Person WHERE ID %INLIST dc.GetListIdsByName('jose',,,500)

Dream team

Read more
Made with
Version
1.0.004 Apr, 2022
Category
Technology Example
Works with
InterSystems IRISCaché
First published
04 Apr, 2022
Last checked by moderator
27 Jun, 2023Works