Search by Pick List: Duplicate Records

Viewing 3 reply threads
  • Author
    Posts
  • September 28, 2014 at 1:58 PM #10939

    1Levite
    Participant

    macbook air: OSX 10.9.5, 1.7 GHz i7
    TF: Version 2.2.3 (522)

    Apologies if this is a redundant post–I looked for similar comments and found none.

    When I search for records in a form using
    “Pick List”>Contains>”Pick List Selection”
    criteria as the ONLY search criteria, the records returned are duplicated (each record appears twice).

    If I used a combination of
    “Pick List”>Contains>”Pick List Selection” and
    “Another Pick List”>Contains>”Another Pick List Selection”
    the returned records are not duplicated. Same with “Pick List” and “Text” as search criteria.

    Interestingly, if I select this as the only search criteria:
    “Pick List”>Does Not Contain>”Pick List Selection”
    there is no duplication.

    I experimented to see if the duplication occurs using other field types. It seems to happen only with a lone “Pick List”>Contains search term.

    September 29, 2014 at 1:31 PM #10946

    Brendan
    Keymaster

    Hi 1Levite,

    Can you try running the Rebuild Search Index command on the Database Maintenance Screen to see if that fixes the problem?

    Thanks,

    Brendan

    September 29, 2014 at 4:24 PM #10949

    1Levite
    Participant

    Rebuilding the search index solved the duplicate search record issue. Should have thought of that before posting.

    Thanks

    September 29, 2014 at 8:11 PM #10951

    Brendan
    Keymaster

    Excellent. I’m glad that worked for you.

    Thanks!

    Brendan

Viewing 3 reply threads

You must be logged in to reply to this topic.