Change Waiting List order

Currently the oldest non-complete registration, as determined by the lowest registration ID, is selected. If you have the ability to create a custom module you can change that in a few different ways. What logic do you want to use instead?

Dang, that's what I was afraid of. I was hoping that it was the oldest non-complete registration based on Registration Date. It's easy to update the registration date and not mess with much. It's difficult to change the registration number as you'll have to swap them with another one correct? Am I missing an easy way to handle that?

Thanks for your reply!

PS, I'm not a coder so making my own module will be difficult. I'm good once I have a module though.

Ah, Registration Date is a reasonable choice. Just curious - are you sure you want to enable Autofill? If you disable Autofill, you can hand select and edit the Registration you want to take the place of the deleted/canceled registration and set its state to Complete, avoiding this issue entirely. I guess the downside would be someone could do a new registration before you get a chance to fill it manually, but editing the registration date in advance of a cancellation is manual too.

Yes, my client wants the Autofill because MOST of the time, he's fine with the "first come, first served" approach to the waiting list. However, every now and then (fairly rarely), he wants someone to be at the first of the waiting list line. So, he would like an easy method to do that.

He's very pleased with the views method I set up that shows the people on the waiting list (filter by status), and then just adjusting the registration date/time to his liking to move someone to the front. But that doesn't actually work we found out thanks to you and noting that it's registration number. We don't care much about when someone registered so adjusting that isn't an issue.

So, what would need to be done to create the module you spoke about earlier to make the waiting list sort by registration date instead of registration number?

Thanks again!

This could be a common need - the ability to override what gets autofilled next. Let me mull this over and see if I can get something into the next release of the module, due out in mid-May.

Oh that's awesome! I think you're right that surely I'm not the only one that would appreciate this. You of course are the designer, but I could see a check box right under the Enable Waiting List check box that says "sort waiting list by" and you check which one you'd like, registration number or registration date. I can't think of any other options for sorting I'd use, but maybe someone else has an extra one to add.

Thank you so much!

I just had a different idea. I'm not a coder, so this might not be feasible, but could you possibly add a weight value similar to other Drupal values (like a list or taxonomy) to each registration? Each registration would have a default value of say 5 or something. But it would be built into the interface to change the weight on the edit page for the registration. Then, if you wanted to prioritize someone, you would just edit their registration and change their weight to say 1. Then when someone cancels a registration, the system would look to the weights first, would sort by the lowest weight, and then sort by the registration number within each weight like it does now.

That way, you don't have to change any actual values like the registration number or the registration date. You could leave them alone as they have possible value in other parts of the system. But you could "play" with the waiting list order all you wished.

Was thinking along the same lines.

Committed to dev branch and will be in the next release which should be in a week. To use this feature, install the Weight module → and then add a weight field to your registration type, make sure it has a Default value of 0. Configure the form display for your registration type so the Weight field is shown on the "default" display that admins use, but is hidden on the "register" form display that registration forms use (create the "register" form display if needed, make sure the machine name is register). Then edit the registration type and change the Autofill Sort Field setting to use the your new weight field instead of Registration ID. When your site admins want to prioritize a given wait listed registration for autofill, they would set the weight field to -10 for example, and it will autofill first. If you prefer the admins use a positive number so it is more like a Priority, simply flip the AutoFill Sort Order on the registration type from ASC to DESC.