Problems with search and dashes

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Problems with search and dashes

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
  • November 5, 2024 at 9:09 AM #51262

    John Hamill
    Participant

    I have struggled with the search in Tapforms for sometime. Here is an example:

    Can anybody explain why search_1 below operates correctly while search_2 does not. The phrase “usa-rogue”  (in search_2) does not appear anywhere in the enclosed record (PDF enclosed). As such, it should not be returned in the list of search results. It is listed however (erroneously, it seems).

    Is it not possible to use a “minus sign / dash” in a search?

    There is even more confusion when you operate a search within a note type field – the rules (when using double quotes seem to change) from the main search.

    Has anyone got definitive rules and how to search for these types of phrases?

    Thank you for your assistance.

    • This topic was modified 1 week, 6 days ago by John Hamill.
    Attachments:
    You must be logged in to view attached files.
    November 5, 2024 at 10:32 AM #51267

    Glen Forister
    Participant

    I have a note from Brendan.

    “The general search field will only do a begins with type search.

    If you need to do a contains type search, you’ll need to click the filter button just to the left of the general Search field and build a search rule to find what you need.”

    I don’t know if this will help???

    November 5, 2024 at 8:20 PM #51271

    Brendan
    Keymaster

    The - means NOT. That is, find all records that contain usa, but NOT rogue.

    However, the SQLite FTS search engine I use ignores punctuation, so it’s actually finding the occurrence of “use; rogue” that you have in your Note field.

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.