Search issue - type ahead in AIS is not bringing up expected records (Stop Word related)

Version 1

    Details

    Search issue - type ahead in AIS is not bringing up expected records


    For example, typing matthew.so or matthew so into the Profilelink on Incident returns no results, but the Employee record is there, active, and can be reached by browsing via the magnifying glass icon.

    The issue I have is when I type “Matthew So”, it is telling me “No records have been found”.
    First of all, that message is incorrect as “Matthew So” does exists and is active. The pick list should return his result.

    What I’ve already tried but still unable to get it to work
    •        using “matthew.so” which is the mandatory Login ID
    •        using the email address
    •        I don’t think the last name is too short as well because I changed all instance of my last name in Employee from “Yeo” to “Yo” and the list still picks up “Jamie Yo”. 

    What I want to know is 
    1.      The reason why that is happening.
    2.      if there is any configuration that I can do as an Administrator to return “Matthew So” when the full text is entered instead of the incorrect “No records have been found”.
    3.      if above is not possible, is there a way I should type in the list box to get it returned.

     


    Resolution

     

    This issue is happening because Matthew's last name matches one of the 'Stop Words' that the database ignores in search queries. If you search for So in the Employee workspace, you'll get a message to that effect. If there were less than 50 Matthews you could still choose him from the list, but since there are more, his last name is required to filter, and the search will fail. Unfortunately, there is nothing that can be done about this; they will just have to select him via the magnifying glass icon. 

    Here is the current list of stop words that the database will exclude from searches in the application:

    stopword           
    $              
    0              
    1              
    2              
    3              
    4              
    5              
    6              
    7              
    8              
    9              
    A             
    B             
    C             
    D             
    E              
    F              
    G             
    H             
    I               
    J              
    K             
    L              
    M            
    N             
    O             
    P             
    Q             
    R             
    S              
    T              
    U             
    V             
    W            
    X             
    Y              
    Z              
    about    
    after      
    all            
    also        
    an           
    and        
    another                
    any         
    are         
    as            
    at            
    be           
    because               
    been     
    before  
    being     
    between             
    both      
    but         
    by           
    came     
    can         
    come     
    could     
    did          
    do           
    does      
    each      
    else        
    for          
    from      
    get         
    got         
    had        
    has         
    have      
    he           
    her         
    here      
    him        
    himself 
    his          
    how       
    if             
    in            
    into        
    is             
    it             
    its           
    just        
    like         
    make     
    many     
    me         
    might    
    more     
    most      
    much     
    must      
    my          
    never    
    no           
    now       
    of            
    on           
    only       
    or            
    other     
    our         
    out         
    over       
    re            
    said        
    same     
    see         
    should  
    since      
    so           
    some     
    still         
    such       
    take       
    than       
    that        
    the         
    their      
    them     
    then      
    there     
    these    
    they       
    this         
    those    
    through                
    to            
    too         
    under    
    up           
    use         
    very       
    want      
    was        
    way        
    we          
    well        
    were     
    what      
    when    
    where   
    which    
    while     
    who       
    will         
    with       
    would   
    you        
    your