How do you do filter not equal?
-
I’m trying to filter the pdb_list, to only show first name, last name, email, and services and to only show records where the services field is not empty. Not having much luck. What I’m getting is the email and the services for all the records. This is my shortcode:
[pdb_list fields=”first_name, last_name, email, services” filter=services!]
I’ve tried a number of different ways to do “not equal” but none of them work. I have gone into phpmyadmin and the Null values in that column to ”.
Thanks in advance.
-
The filter you have in your example looks correct for what you’re trying to do.
filter="services!"Will show all records with a “not empty” value for the “services” column. This is because the plugin will be looking for a comparison value after the “!” (which does mean “not equals”) and since there is none, it makes the comparison to an empty value.
The double quotes are not necessary, but can be visually helpful.
If you turn plugin debugging on, you will be able to see the database query that is used to generate the list. This will help you understand the result you’re getting.
The topic ‘How do you do filter not equal?’ is closed to new replies.
