Excluding record with search function + rating

Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch Forums Using Tap Forms 5 Excluding record with search function + rating

Viewing 2 reply threads
  • Author
    Posts
  • October 30, 2022 at 2:19 AM #48157

    Spotter2004
    Participant

    Hi,

    1) How come the search function exclude the record i’m trying to find?

    Example: i have a record with the “code” AF-02
    When i type AF- everything is still ok, but when i continue AF-02 the record can’t be found
    When i use only AF- or 02 i don’t have that problem.

    2) The rate function doesn’t seems to work 100%
    If i use half a star in record rating, you see a full star in the overview (see attachment)

    Attachments:
    You must be logged in to view attached files.
    October 30, 2022 at 5:04 AM #48159

    Spotter2004
    Participant

    Hmm, just found out if you enter AF 02 you get the record

    October 30, 2022 at 10:29 PM #48161

    Brendan
    Keymaster

    Hi Spotter,

    If you surround the query with double-quotes (straight quotes, not curly quotes), then you’ll get an exact match. The search engine Tap Forms uses treats the dash as a negative query. So when you type AF-02, you’re telling Tap Forms to fetch every record that has AF in it, but NOT 02 in it. But when you search for "AF-02" with the double-quotes, Tap Forms does an exact match on that phrase.

    Thanks,

    Brendan

Viewing 2 reply threads

You must be logged in to reply to this topic.