[Plugin: Participants Database] Sort & Search

Em,

Right now, you are limited to what you can accomplish with CSS as far as relocating the search forms is concerned. I am working on a template for the list display, and that will give you more flexibility in the future.

Now, for the fields that you don’t want to see on the sort dropdown, the way it works right now (and I’m not saying this is the best thing!) is that all fields that are marked as “sortable” will show up there, so you can take them out of the list if you want. The search fields are are the same as are displayed in the list, so that should all be OK.

–Roland

Em,

In the update I’m issuing today, the sort fields won’t include any columns that aren’t displayed in the list.

In my main pdb_list which shows all approved participants, there are at least 6 fields set to be sortable but only one shows up in the search and sort dropdown list. This is the code I’m using:

[pdb_list filter="approved=yes" orderby="date_updated" order="desc" list_limit="500" class="artistelist" fields="full_name, photo, area, description, age, height, ethnicity" search="false" sort="false"]

See https://abcast.co.uk/index.php/artistes/ – although I’ve had to disable the search and sort as it doesn’t work yet, as also, when search is set to true it shows all records (including those not approved). If we happen to be online at the same time tonight (for me) and in the morning (for you!) I’ll set them to true so you can see what I mean!

Cheers, Em

I was having the same issue with sort and search, and a could others.

I left the page public so you can see it, there is no personal info on it.
Page: https://jhcband.org/wordpress/member-resources/search-members
Shortcode[pdb_list search="true" sort="true" CSS="jhcb_members" orderby="last_name" fields="first_name, last_name, other_instruments, status" display_count="true"]
Fields marked sortable in admin:

• First Name 1
• Last Name 2
• Instruments 3
• Birth Month 4
• Section 5
• Status 6
• Mailing City 7
• Mailing State 8
• Mailing Zip 9
• Date Updated (non displayed group) 99

When typed the above list I found/fixed my problem. Before I typed the list above, the fields I picked to be ‘sortable’ did not all show in the drop-down list, and the ‘sort by’ drop down list. When I started the list above and looked at the field choices I matched up display columns and numbered as above. This fixed the problem. When I had the display column set to zero it would not show up on the search drop down list. I’m assuming this is supposed to work this way. (cool function)

I would like to add to a wish list… At least one more search argument choice i.e. Search Status=active & Instruments=flute.

I tried to add filter=”active” to the above shortcode but when I pressed clear it ignored my filer and listed all. It was also doing something weird if I paginated the results, when I went to the next page it listed all and lost the search perimeters.

Thanks You,
Julie

You are right, Julie, well spotted ??

However, I have date_updated and date_recorded checked as sortable and numbered, but they don’t show up. It would also be nice to have a ‘clear’ button so the sort can return to the default.

I would also assume the list would be ordered in the numbered order I gave them but they seem to be listed arbitrarily!

It still shows unapproved members when search is set to true ??

Thanks, Em

Em,

I don’t use the date updated in the front end, I just use it for reference. However I may change that soon.

I looked at how my list is sorting. My default order is last name but it gets ignored when I change the sort drop down. Because I uploaded my members in batches I can tell it’s secondary sort is the ID# generated by the computer (or at least that what it looks like).

I got some interesting results when I stacked shortcodes and had the filter and sort options on the top shortcode only. Musicians need to be displayed by section in score order. So I did a short code for every section and ordered each section by last name. When I tested the new functions on the top shortcode it filtered/sorted all the shortcodes on the page. I would find out if this is a bug before you exploit it though. ??

Here is a visible page with stacked shortcodes:
https://www.jhcband.org/members/

TTFN
Julie

Hi Julie,

My default sort is date_updated and that works now, but is not an option in the dropdown sort list!

I really like the way you have yours laid out but I haven’t managed it yet. I don’t suppose you could send me the code as an example for me to follow? I too want to place one photo (my clients can upload up to 6) next to relevant details as a sort of snapshot before deciding to visit their main profile page.

My email is info [at] abcast.co.uk and I’d really appreciate it as I’m struggling with the PHP ??

Nice work!
Em
P.S. Sorry for hijacking your post page, Roland!!

Em~ That page is a hack that I’m still working on but have not had time to make perfect. I’ll email you tonight or in the morning. (I’m at work, my files are easier to access from my home computer). I’m a PHP newbie too, we could probably help each other. ~J

Great idea ??

@tetontrekker,

Could you tell me which lines you modified in PdBlist.class.php to have the hyperling on the Name to access the detailled info on your user ?
I did an hack which just consist in adding the column “Private ID” but your solution is much more elegant.

@sev

That’s in “Settings”. Scroll down to “Single Record Link Field” and choose whichever field you want the hyperlink to be on!

Hope this helps, Em

@sev,

Em is correct. I also used some CSS to make the link look the same as regular text. First I surrounded the short-code with a custom class
<div class="jhcb_members">[shortcode]</div>
then used this CSS

.jhcb_members a:link, .jhcb_members a:hover, .jhcb_members a:active, .jhcb_members a:visited {
	text-decoration:none;
	color:#3e3e3e;
	font-family:Tahoma, Arial, sans-serif;
	font-size:11px;
}

I hope this helps.
~Julie