|
asteiner
|
May 11, 2017 at 3:31 am
Hi,
I am using
get_events_for_person()
like
$events = EEH_People_View::get_events_for_person();
to get events for person. But order of events looks all messed up.. Is there any way I can get this list ordered by event start date?
Thank you.
|
|
Josh
|
May 11, 2017 at 9:26 am
Hi there,
It may help to see the code that you’re working with in context. Can you post the template file into a pastebin or gist and share a link here?
|
|
asteiner
|
May 11, 2017 at 12:57 pm
Sure.. https://pastebin.com/2vDg5diR
I am working with content-espresso_people-details.php template
Thanks
|
|
asteiner
|
May 12, 2017 at 7:19 am
Also this method returns past events too..
Can I exclude past events somehow?
Thanks.
|
|
Josh
|
May 12, 2017 at 1:50 pm
OK so the order that the events get displayed with that method is the order of assignment. So the first event assigned to that person will be the first event in the list and so on. I’m afraid there are no filters in the
_get_rel_objects method to change the order_by or filter out expired events. So I can suggest building out your own method or function and include a custom query that changes the order_by to use the Event start date and filters out any events that start before today.
|
|
asteiner
|
May 14, 2017 at 3:39 am
Any idea how this query should look like?
In _get_rel_objects there is no clear SQL pieces or something that might help to replicate it..
Thanks.
|
|
Josh
|
May 15, 2017 at 6:35 pm
Hi there,
The reason you’re seeing SQL code there is the queries are all generated by the model system. Here’s a link to the documentation that shows how to use the Event Espresso 4 Model system to build queries:
https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/model-querying.md
|
