How to code pdb_list filter for Multiselect/Other field

After further review, this will work

[pdb_list fields=”first_name,last_name,address,city,state,zip, phone, email, interests” filter=”Interests=sports”]

[pdb_list fields=”first_name,last_name,address,city,state,zip, phone, email, interests” filter=”Interests=photography”]

One more question

Can the above two filter lists be combined into one?

Can a filter isolate participants with multiple interests?

try filter="interests=photography&interests=sports"

remember, to name the field in the filter, use the name not the title.

Still not displaying participants

status is a field I added to Personal Fields tab that contains member, mate, officer, director, HC, FC, PC, SC, SD, BOD, Treasurer, Secretary, Fleet Chaplain

[pdb_list fields=”first_name,last_name, title, phone, email, seq, status” filter=”status=officer&status=director” orderby=”seq” order=”asc” display_count=”true”]

Total Records Found: 0, showing 20 per page

The 1st three pdb_list work OK

https://lasalleyachtclub.com/about/technical-notes/participants-database/

Do you have records where the status is both “officer” and “director”? That is what the filter is looking for. It’s not possible (without doing some coding) with the current version of the plugin to select either of two options: i.e. either “officer” or “director”

I have that in the next version.

That’s exactly what I want to accomplish, I can wait

Another wish item list for your future consideration:

Is There a List Title?

Example of existing record count
display_count=”true”
Total Records Found: 15, showing 20 per page

How about a similar command that displays a list title above the list?
display_title=”Name and Address List of Participants”
Name and Address List of Participants

How about a command that displays a list title & count above the list?
display_title_count=”Name and Address List of Participants”
Name and Address List of Participants – Count 15

You can do all this in a custom template.

Further review on above question:

One more question

Can the above two filter lists be combined into one?

Can a filter isolate participants with multiple interests?

Answer

FYI

Digging througt your readme.txt I discovered the following and it works:

It’s now also possible to use an “or” operator to link statements, for instance if you wanted to show all records with a city of Boston or Providence, you

would use [pdb_list filter="city=boston|city=providence"] and they can be combined: [pdb_list filter="last_name=smith&city=boston|city=providence"]

This works:

[pdb_list fields=”first_name,last_name, title, phone, email, seq, status” filter=”status=officer|status=director|status=Treasurer|status=Secretary|status=PC|status=SD|status=Fleet Chaplain” orderby=”seq” order=”asc” display_count=”true”]

Ah, I forgot I had added that in that last release. Glad to hear that’s working for you.,