Search guide   2012-05-16
    
 Main Menu   Back   List Search   Specific Search 
  Search guide        
 
   
 
Advanced search
On this page you will get some additional guidance in order to improve your search result and explain the use of the advanced Search.

Learn to use the advanced search
Choose the first parameter you would like to search on, When you have entered or selected an value and you are about to choose the next parameter you will see that the first parameter will disappear and show up in the “Search for substance with following criteria” field.

This happens because if you would like to search for the same parameter multiple times
Ex. ((CodeNo LIKE "*400*")) AND ((CodeNo LIKE "*500*"))
If you first enter 400 in the CodeNo field and then leave the focus from the control. You can enter 500 in the CodeNo field. This search will search for all CodeNo that contains 400 and 500.

You can directly edit your search query in the “Search for substance with following criteria” field. so if you make an error in you input you can change the values in this field there
Ex. ((CodeNo LIKE "401*")) OR ((CodeNo LIKE "*500*"))
I’ve now changed the query so it searches for CodeNo that starts with 401 OR contains 500. As you notice you can even change the logical operators AND, OR, etc. You can also remove the default wildcards (*) so it search for the parameter in the beginning or at the end of a string.

How to send a query search to colleague or friend.
Select the value in the “Search for substance with following criteria” field and do ctrl+c(Copy) you can now paste it in a document or send the query in a e-mail or similar. The one who receives the query ctrl+v(paste) it in to the “Search for substance with following criteria” field. You will both now see the same result.