F9 Search ignores "Case Sensitive" check box

  1. 2 years ago

    RandallG

    16 Feb 2021 Test Pilot

    Hi Chris,

    DoogiePIM Version 2.3.0.0

    I noticed just today that if I have a document name that includes caps, then implement a search by using F9 (for that same name but type in all lowercase, doogie won't find the document. Even though I uncheck the option that says, "Case Sensitive"
    For the search I click the tab "Search by Field", Then select Documents in "Search in" and Name in "Record Field".

  2. Chris

    16 Feb 2021 Developer, Moderator, Test Pilot
    Edited 2 years ago by Chris

    That's a great find. Many thanks for spotting and reporting it.

    It was a quick fix and ready for the next update version 3.

    If you're feeling hardcore right now, you could pop over to the "Advanced (SQL)" tab on the Database Search window and enter the following (Replace somesearchtext with your own search term):

    Select Name, CreationDate, id From Folders 
    Where (FolderType=202) and (lower(Name) Like "%somesearchtext%")

    This will give you the same results but won't care about the character case.

 

or Sign Up to reply!