Support

Home Forums Event Espresso Premium Event Table Add-on Filter by Venue?

Event Table Add-on Filter by Venue?

Posted: February 4, 2018 at 6:54 pm


waverlyadmin

February 4, 2018 at 6:54 pm

How can I filter the results of the event table add-on by venue? I can pass the venue ID.

I have created a short-code that will list the event “Cities” (using the REST API) now I want to create a link for each of these CIties that when clicked will show a list of events in that city.

q.1 How would I do this?

q.2 Is there a faster way to just simply to do a SELECT query to find the list of Cities in which I have venues configured? I feel that the REST API might be too slow?

q.3 How would I find out that there are no upcoming events at a given city? Ideally I would like to do this with a SELECT query and not use REST.

I am brand new to WP. php and EE but feel like I am getting a lot done with even my very limited knowledge.

Thanks,
-Anu


Tony

  • Support Staff

February 5, 2018 at 2:33 pm

Hi there,

q.1 How would I do this?

These kinds of customizations are outside the scope of support we provide, we support the plugin itself, but not customizations.

q.2 Is there a faster way to just simply to do a SELECT query to find the list of Cities in which I have venues configured? I feel that the REST API might be too slow?

You can use our models to pull the information in:

https://github.com/eventespresso/event-espresso-core/tree/master/docs/G–Model-System

The REST API is great, but more suited for pulling information from an external site, say you wanted to list your events on another site, you can use the REST API to pull any information you may need to display them. If you have access to the site you are adding the customization on, you can do it locally by pulling the info from the database yourself (there’s lot of method to do so, our models do alot of the EE work for you).

q.3 How would I find out that there are no upcoming events at a given city? Ideally I would like to do this with a SELECT query and not use REST.

You’re going to need working knowledge of PHP, WP and EE to do what you are trying to do, whilst I certainly don’t want to discourage you from attempting the above its not something we can step you through on the forums.

I noticed you request recommendations for a freelancer in your other thread here: https://eventespresso.com/topic/need-help-customizing-ee4/#post-261748

Imo you would be much better off requesting they build this for you as its not something you want to just jump straight into without any previous experience.

The support post ‘Event Table Add-on Filter by Venue?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso