Title: Case sensitive filtering
Last modified: September 22, 2021

---

# Case sensitive filtering

 *  [eljailer](https://wordpress.org/support/users/eljailer/)
 * (@eljailer)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/)
 * Hello Roland!
    I have this code snippet in custom pdb-single-tabs template: `
   <?php $guestLastName = $this->participant_values[‘last_name’]; $guestName = $
   this->participant_values[‘first_name’]; $guestDob = $this->participant_values[‘
   date_of_birth’]; echo do_shortcode( ‘[pdb_list fields=”last_name,first_name, 
   date_of_birth” filter=”last_name=’ . $guestLastName . ‘&first_name=’ . $guestName.‘&
   date_of_birth=’ . $guestDob . ‘orderby=”date_of_arrival” order=”asc”]’ ); ?>`
   This appears to be case sensitive. What am I doing wrong? Any help or suggestion
   would be much appreciated.
 * Thanx in advance.
    -  This topic was modified 4 years, 8 months ago by [eljailer](https://wordpress.org/support/users/eljailer/).
    -  This topic was modified 4 years, 8 months ago by [eljailer](https://wordpress.org/support/users/eljailer/).

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/#post-14899285)
 * looks like you’re missing a double quote and space in front of the “orderby” …
   the shortcode won’t work as expected.
 *  Thread Starter [eljailer](https://wordpress.org/support/users/eljailer/)
 * (@eljailer)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/#post-14899378)
 * Actually, the shortcode works.
    This snippet is just an example, maybe I copied
   it wrong, sorry. The idea is to show the visitor’s previous visits on the pdb-
   single page, in form of spoiler. But the real problem is that this works only
   if the record’s name and last name are exactly the same – case sensitive. Is 
   the problem in the database collation? The collation for those fields is utf8_croatian_ci.
   Or am I really just missing the double quotes? Thank you for your reply.
 *  Thread Starter [eljailer](https://wordpress.org/support/users/eljailer/)
 * (@eljailer)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/#post-14899467)
 * This is the actual code:
 *     ```
       <div class="wrap <?php echo $this->wrap_class ?> ">
   
        <input type="checkbox"  id="spoiler2" /> 
        <label for="spoiler2" >Raniji posjeti</label>
        <div class="spoiler">
       <?php
            $recidiv_prezime = $this->participant_values['prezime'];
            $recidiv_ime = $this->participant_values['ime'];
            $recidiv_dat_rod = $this->participant_values['datum_rodjenja'];
            echo do_shortcode( '[pdb_list fields="prezime,ime,datum_zaprimanja,status,datum_otpusta,napomena_otpust" filter="prezime=' . $recidiv_prezime . '&ime=' . $recidiv_ime . '&datum_rodjenja=' . $recidiv_dat_rod . '&u_ustanovi!DA" orderby="datum_zaprimanja" order="asc"]' );
       ?>
       ```
   
 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/#post-14899478)
 * If you have your plugin debugging on, you’ll see the query that is used to generate
   the list. It is not case-sensitive.
 * It seems to be [technically possible](https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html)
   to make it case-sensitive by changing the collation, but I don’t know much about
   this.
 *  Thread Starter [eljailer](https://wordpress.org/support/users/eljailer/)
 * (@eljailer)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/#post-14899528)
 * Okay,
    thank you for your reply.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Case sensitive filtering’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [eljailer](https://wordpress.org/support/users/eljailer/)
 * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/case-sensitive-filtering/#post-14899528)
 * Status: not resolved