OOFILE Validation Suite - Test 28
Use keyword indexing to retrieve by words within fields.
Adding test data

People with 'bloke' in their Description (keyword file non-indexed):
Last Name   Other Names 

Smith   John    

People with word starting with 'blo' in their Description (John Smith):
Last Name   Other Names 

Smith   John    

Now rebuilding the database indices, to see if above faster
People with 'bloke' in their Description (John Smith):
Last Name   Other Names 

Smith   John    

People with 'blo' in their Description (nobody):
Last Name   Other Names 


People with word starting with 'blo' in their Description (John Smith):
Last Name   Other Names 

Smith   John    

People with 'Andy' in their Description (Andy & Trissa Dent):
Last Name   Other Names 

Dent    Trissa  
Dent    Andy    

People with 'Andy' in their Description and also (via searchSelection) 'married' (Trissa Dent):
Last Name   Other Names 

Dent    Trissa  

People with 'bloke' in their Description (John Smith & Trissa Dent):
Last Name   Other Names 

Smith   John    
Dent    Trissa  

People with 'bloke' or 'software' in their Description (John Smith, Andy & Trissa Dent):
Last Name   Other Names 

Smith   John    
Dent    Trissa  
Dent    Andy    

People with 'bloke' and 'software' in their Description (nobody):
Last Name   Other Names 


People with 'blo' and 'so' in their Description (John Smith):
Last Name   Other Names 

Smith   John    

People with 'giraffe' or 'boots' in their Description (John Smith):
Last Name   Other Names 

Smith   John    

People with 'giraffe' and 'boots' in their Description (nobody):
Last Name   Other Names 




******** Now search table, regardless of field *********

People with 'bloke' (John Smith & Trissa Dent):
Last Name   Other Names 

Smith   John    
Dent    Trissa  

People with 'bloke' or 'software' (John Smith, Andy & Trissa Dent):
Last Name   Other Names 

Smith   John    
Dent    Trissa  
Dent    Andy    

People with 'bloke' and 'software' (nobody):
Last Name   Other Names 


People with 'blo' and 'so' (John Smith):
Last Name   Other Names 

Smith   John    

People with 'giraffe' or 'boots' (John Smith):
Last Name   Other Names 

Smith   John    

People with 'giraffe' and 'boots' (nobody):
Last Name   Other Names 


People with 'Trissa' and 'married' (Trissa Dent):
Last Name   Other Names 

Dent    Trissa  

Test Completed