Skip to content
Snippets Groups Projects
  • JediKev's avatar
    f6b4201a
    issue: List & Choice Searching · f6b4201a
    JediKev authored
    This addresses issues 3703, 3493, 2625, and others where searching for
    List or Choice values in a Custom Field will yield no results. This was
    due to us using `FIND_IN_SET()` and `IN()` to search, which will not work
    with the way the values are stored in the database. This updates the
    search methods to use `REGEXP()` to search for the IDs of the List and
    Choice values which will give the correct results whether it's multiple
    choice or not.
    f6b4201a
    History
    issue: List & Choice Searching
    JediKev authored
    This addresses issues 3703, 3493, 2625, and others where searching for
    List or Choice values in a Custom Field will yield no results. This was
    due to us using `FIND_IN_SET()` and `IN()` to search, which will not work
    with the way the values are stored in the database. This updates the
    search methods to use `REGEXP()` to search for the IDs of the List and
    Choice values which will give the correct results whether it's multiple
    choice or not.