Title: Cannot filter by checkbox fields
Last modified: August 31, 2016

---

# Cannot filter by checkbox fields

 *  [gravitylover](https://wordpress.org/support/users/gravitylover/)
 * (@gravitylover)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/cannot-filter-by-checkbox-fields/)
 * When filtering by checkbox fields, the results always return blank – it
 * e.g. filter 47 works (dropdown field) but filter 55 does not (checkbox)
    ?filter_47
   =Available&filter_55=Housekeeping
 * [https://wordpress.org/plugins/gravity-forms-addons/](https://wordpress.org/plugins/gravity-forms-addons/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [gravitylover](https://wordpress.org/support/users/gravitylover/)
 * (@gravitylover)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/cannot-filter-by-checkbox-fields/#post-7031942)
 * Fixed, some modifications needed in gravity-forms-addons.php
 * Approach 1, wildcard fields:
 * line 2819:
 *     ```
       $fuzzy_field = "$field_id.%";
       $in_search_criteria .= $wpdb->prepare( " AND l.id IN (SELECT lead_id from $detail_table_name WHERE (field_number = %s OR field_number LIKE %s) AND value LIKE %s)", $field_id, $fuzzy_field, $value );
       ```
   
 * line 2847:
 *     ```
       $fuzzy_field = "$field_id.%";
       $in_search_criteria .= $wpdb->prepare( " AND l.id IN (SELECT lead_id from $lead_detail_table_name WHERE (field_number = %s OR field_number LIKE %s) AND value LIKE %s)", $field_id,  $fuzzy_field, $value );
       ```
   
 * Approach 2: GF style (as seen in forms_model.php)
 * line 2819:
 *     ```
       $upper_field_number_limit = (string) (int) $field_id === (string) $field_id ? (float) $field_id + 0.9999 : (float) $field_id + 0.0001;
       $in_search_criteria .= $wpdb->prepare( " AND l.id IN (SELECT lead_id from $detail_table_name WHERE field_number BETWEEN %s AND %s AND value LIKE %s)", (float) $field_id - 0.0001, $upper_field_number_limit, $value );
       ```
   
 * line 2847:
 *     ```
       $upper_field_number_limit = (string) (int) $field_id === (string) $field_id ? (float) $field_id + 0.9999 : (float) $field_id + 0.0001;
       $in_search_criteria .= $wpdb->prepare( " AND l.id IN (SELECT lead_id from $lead_detail_table_name WHERE field_number BETWEEN %s AND %s AND value LIKE %s)", (float) $field_id - 0.0001, $upper_field_number_limit, $value );
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘Cannot filter by checkbox fields’ is closed to new replies.

 * ![](https://ps.w.org/gravity-forms-addons/assets/icon-256x256.jpg?rev=996787)
 * [Gravity Forms Directory](https://wordpress.org/plugins/gravity-forms-addons/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/gravity-forms-addons/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/gravity-forms-addons/)
 * [Active Topics](https://wordpress.org/support/plugin/gravity-forms-addons/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/gravity-forms-addons/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/gravity-forms-addons/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [gravitylover](https://wordpress.org/support/users/gravitylover/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/cannot-filter-by-checkbox-fields/#post-7031942)
 * Status: not resolved