DB Request for registered location without event?

Add on to my question:

I use the shortcode “#_EVENTDATES” and #_EVENTLINK” to display a registered event in the future. I like to show all events in the future without “#_EVENTDATES” and #_EVENTLINK.

The positive question is
[events_list country=”…” orderby=”location_name” pagination=”1″]

thank you for help
mustermann

Hi,

Could you clarify what you mean by, “all locations for the future which did not have an registered event in the future”?

Do you mean you want to list locations that have only events in the past?

Hi,

In my Event Management DB are some Locations with events in the past. But in this moment they have no events in the future.

I like to have a request (shortcode) to get a list with all locations without an event in the future.

Thank you for help
mustermann

Ok, something like this is probably what you’re looking for:

[locations_list scope="past"]

Hi caimin_nwl,

I have test this shortcode:

[locations_list scope=”past” limit=”30″ orderby=”??????” pagination=”1″ order=”ASC” country=”AT”]
#_LOCATIONPOSTCODE #_LOCATIONTOWN, #_LOCATIONADDRESS[/locations_list]

The result of this shortcodes worked, but the order for the adresses are wrong. Do you know the database name for locations postcode for the attribute orderby=”…”

I would like to sort the results in the post after the postcodes.

These attributes are necessary to bring the results in the right arrangement.

Thank you for help
mustermann

sorry but do you want to sort by location post/postal code ?

Hi caimin_nwl,

I would like to sort by postal code or location.

The problem is that [locations_list scope=”past” …] did not sort the locations.

Thank you for help
mustermann

Haven’t tested, but I think using

orderby="location_postcode"

in your shortcode should work.

Hi caimin_nwl,

the list works with this shortcodes:
[locations_list scope=”past” limit=”40″ orderby=”location_postcode” pagination=”1″ order=”ASC” country=”AT”]
#_LOCATIONPOSTCODE #_LOCATIONTOWN, #_LOCATIONADDRESS
[/locations_list]

All adresses are shown in the list, which are in the database. To make a perfect list like my question in my first post:

Which additional code is necessary to show only the adresses without events in the future?

By “adresses” do you mean locations?

Hi caimin_nwl,
the adresses is built from “location postcode, location town and location adress (street or place)”. We name postcode, town and street as adress.

I would like to get a list of all locations, which did not have an event in the future.

With the following example I get an output from all sorted postcode, towns and streets (place) from the database:

[locations_list scope=”past” limit=”40″ orderby=”location_postcode” pagination=”1″ order=”ASC” country=”AT”]

The problem is: I don′t know if one adress in the list is connect with an event in the moment.

I ask for a solution to list only the adresses without an event in the future.

Thank you for help
mustermann

sorry for the confusion, did you mean list location with an event ?

Hi angelo,

no problem about the confusion.

I would like to see a list with locations (postcode, town and adress) without an event.

Thank you for help.
mustermann

thanks, did you tried to add eventless=1 ?

https://wp-events-plugin.com/documentation/event-search-attributes/

Hi angelo,

I have solved the my problem like this shortcodes and attributes:

[locations_list scope=”2015-01-01,2018-12-31″ limit=”40″ orderby=”location_postcode” pagination=”1″ order=”ASC” country=”AT” eventless=”1″]#_LOCATIONPOSTCODE #_LOCATIONTOWN, #_LOCATIONADDRESS[/locations_list]

Thank you for help
mustermann