Timeline for Complicated `orderby` based on text in custom field
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 23, 2023 at 16:35 | comment | added | Sally CJ | Yes, I also noticed that issue and thus, I revised the Option 1. But that would be the last revision (for now), so I hope it'll continue to work for you. Happy weekend! | |
| Sep 22, 2023 at 18:52 | comment | added | NW Tech | I've updated my template with the revised option 1. i will say, it seems to perform better -- the one I tired earlier worked but it took a little longer for the page to load. | |
| Sep 22, 2023 at 17:45 | comment | added | Sally CJ | Thanks for accepting my answer, and I'm happy that the previous variation worked for you, but I suggest you to use the new code in Option 1 in my revised answer (and let me know how it goes) :) I also added Option 2, just in case you'd like to give it a try.. | |
| Sep 22, 2023 at 17:35 | history | edited | Sally CJ | CC BY-SA 4.0 |
Better answer
|
| Sep 22, 2023 at 13:37 | comment | added | NW Tech | This new variation worked out great. Thank you! | |
| Sep 22, 2023 at 13:37 | vote | accept | NW Tech | ||
| Sep 22, 2023 at 9:57 | comment | added | Sally CJ | To be honest, I think I misread/misinterpreted your question.. 😅 Therefore I completely revised my answer. I might add another update soon, but for now, I hope the current update helped you? | |
| Sep 22, 2023 at 9:39 | history | edited | Sally CJ | CC BY-SA 4.0 |
Better answer
|
| Sep 21, 2023 at 13:45 | comment | added | NW Tech | The query is way faster using regexp. It's almost there, but not quite. the order isn't quite there. Here are some of the actual position titles: Engineering Manager; Transmission & substation systems supervisor; contracts coordinator; sr. power systems project coordinator. This order puts them in alphabetical order. Additionally, do you know how I might get the rest of the users in this department that don't match this positional criteria? Would I do another query and exclude these users somehow? Thanks for the insight! | |
| Sep 21, 2023 at 12:13 | history | answered | Sally CJ | CC BY-SA 4.0 |