[Esperando confirmación del usuario] Mostrar en una vista los eventos pasados

[Autor]

Mensajes

[Rafael Corts]

Tengo una vista que mostrava los eventos pasados, ahora des de hace un teimpo alguna cosa se a actualizado y no consigo mostrar los eventos ya realizados,porfavor a ver si alguien de habla española me puede ayudar.
Saludos.
Rafa Corts

[Minesh]

Hello. Thank you for contacting the Toolset support.

Spanish support is not available at the moment. If you agree we can continue in English. Please be patinent and share details that supporter require and that information will help us to guide you in the right direction.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

As shared with the prevous ticket:
- https://toolset.com/forums/topic/problemas-con-el-filtro-de-una-vista/page/2/#post-2791179

With the 2nd view - do you want to keep the Query Filters you added to 2nd view?

Taxonomy filter:
Select posts with taxonomy:
Categories d'Esdeveniment in one of these: Monogràfics

Post search filter
Filter post content and title based on the frontend input search filter.

Also, can you please share screenshot to ensure with what date custom field you want to compare the date against the value 1st Oct 2024 to till date?

[Rafael Corts]

Hello, at first glance everything seems perfect.
In the second view, I want to keep the taxonomy filter for "categoria moinograficos". This is okay.
The publication search filter is also okay.

The third filter is not working correctly. I want to show past events by date.
For example:
Event 1 - December 2, 2024
Event 2 - December 9, 2024
Event 3 - December 16, 2024.
With the filter I had before, it worked, but for some reason, it has stopped working.
I am filtering by a custom date field called 'Data esdeveniment'. I want to show all events that have already occurred based on the date.
Do you understand the problem?"

[Rafael Corts]

I forgot to mention that you can view the view on the page:
enlace oculto
Saludos.
Rafa corts

[Minesh]

After diggig this again - I'm circle back to where we were and the information I shared with you with your previous ticket.

When you try to query the Events it looks like the Events Calendar plugin took the mysql query control and it generates the query that I shared with you before:
- https://toolset.com/forums/topic/problemas-con-el-filtro-de-una-vista/#post-2787609

You are not the only person who is affected due to this and if you search on google you will be able to find many reports about this issue:
- https://wordpress.org/support/topic/mysql-query-wp_tec_occurrences-occurrence_id-10000000/
- https://wordpress.org/support/topic/unknown-column-wp_tec_occurrences-start_date-in-field-list/page/2/
- https://wordpress.stackexchange.com/questions/414768/unexpected-results-custom-wp-query-and-the-query-request

I found few tickets where solution suggested by Events Calendar support but its better to check with them for the latest possible fix.
- https://wordpress.org/support/topic/table-wp_tec_occurrences-doesnt-exist/#post-16453367
- https://wordpress.org/support/topic/not-unique-table-alias-wp-tec_occurrences/#post-16849003

But I'm not sure how it will affect your current data so I strongly suggest you should get in touch with Events Calendar support and check with them how it should build normal query without those additional unwanted "wp_tec_occurrences" table and its associated column.

I also checked with test-view and I see the same query generated on the following test page:
Page - enlace oculto
View - enlace oculto

Once you get this issue resolve we are happy to help you further.

[Rafael Corts]

Hello Minesh, I understand what you're saying, that if I use the date generated by the calendar plugin, I might encounter this difficulty when filtering. This happened to me the first time I did it. But as you can see, I created a custom field with Toolset to avoid this problem. The filter is applied to “Data Esdeveniment”, so it's no longer an issue with the Calendar plugin.
I’m attaching some images so you can see that the filter I’m using is to filter a custom date field from the Toolset plugin.
Best regards,
Rafa Corts

[Minesh]

What I sugget:
- Create a new post type Book
- Add a custom field group and add a custom date field "book-publish-date" and set this custom field group to display with post type Book
- Add few posts to Book post type and setup date field.
- Create a view "display-books" for post type Books and add custom date filter for custom field "book-publish-date"
- create a new page and add the view "display-books" and review the results. Do you see custaom date field working?