How the search works

For every functionality in the left menu, there are search Tab and search result Tab. Below is the SDN List Tabs.

1. If you do not input any data in the search criteria, it will get the first 50 records from the database
2. For criteria in each field,it will create a where clause, for example, if you type "Joe" in sdn name field, It will create a where clause like this lower(snd_name) like '%joe%"

   If you type "Joe smith" in sdn name field, It will create a where clause like this lower(snd_name) like '%joe smith%"

   If you type "Joe, smith" in sdn name field, It will create a where clause like this lower(snd_name) like '%Joe, smith%"

   This is standard SQL Query. The best practice is only type ONE word, for example "Joe", so all the name with "Joe" will be in the result list, which will include "Joe smith", "smith, Joe", "Joe x smith" etc.

3. Criteria in each field will join together using "OR" or "AND", depends on the option "OR" or "AND" selected

For Free text lookup or file scan, It uses innovative indexing and search technology. Those names/messages are pre-processed and tokenized. It will search against name and name synonym. The space between the words will be ignored, the order of the words will affect its score, but NOT as important as its in the standard SQL Query.