Hello, it’s me again!
I would like to ask how can I see where my created events are being stored.
For example, could be a table named “33in_my_tribe_events” but I can’t seem to be able to find something…
What I’m trying to do is, iterate that table and compare my payload to each event of those events.
Hi @koulouridis, nice to hear from you again.
You should be able to see it on your Events Page on your Admin Dashboard.
If I understand correctly you wanted to verify if the events are stored on the database, and you wanted to have another table to segregate the events you created using the API?
Looking forward to hearing from you.
Have a great day.
after a more careful search, I’ve found the table named ” _posts ” contains my created events…
I wanted to ask, is there a way to uniquely identify an event inside that table.
I need to go thorough the table and compare the events stored to that table with my events coming from the API.
Furthermore, I know there is a column in that table named ID, but that number is not helpful to me because my event ID does not match with that table’s ID.
So, is there a way to add a meta field maybe or another field to my events through API when creating my events?
I was also thinking ACF, but it would be overkill to use a plugin so big for one field only…
Hi @koulouridis, appreciate you digging further into this.
Yes, please hold that thought of implementing it with ACF, I’m curious and would love to check it with our devs first before you move forward. 🙂
Would reach back to you as soon as I hear from them.
Have a great day.
Thank you for taking the time to help me once again Abz!
Have a great day!
Hi @koulouridis, no worries we are here to help.
I heard back from one of our devs saying:
As long as their post_meta has been registered to apply to events and to show in rest:
register_post_meta( 'tribe_events',// events only - leave blank to apply to all post types '_custom_meta_key', array( 'single' => true, 'type' => 'string', 'show_in_rest' => true, // This is required for it to be accessible via the API ) );
That’s core functionality. Our swagger docs don’t have any info on adding meta… the worst case they can create the event and then make a second request to edit it and add the meta.
That being said, perhaps you could also try doing the ACF implementation you have in mind, as an option.
Let me know if this helps.
Have a great week ahead.
Hey Abz, sorry for the late reply, I took some days off.
About the events:
Since there was no way to identify an event uniquely, I used tags.
Before creating an event, I check the tags list, if the tag exists (e.g. tag with name 32 which is my event ID), update the event that is connected with that tag, if not, create the tag and the event.
Yes the tags do show up when opening an event, but that does not have any performance impact so all good!
I tried ACF and Metabox, but it wasn’t clean, maybe my approach wasn’t, either way tags to the rescue!
Next on my list is how to delete an event if it’s NOT on my payload, but it is on the tags list. Not a must-have, but a good to have.
Thank you for being helpful once more, I wish you all the best!
Hi @koulouridis, no worries. Apologies for the delay here as well been out for a couple of days. I’m back now.
Yea, not very clean but there’s no other workaround we could suggest for this one. Perhaps it is the only way for now via tags.
Would check with the devs again, but my initial idea would be using “NOT IN” wp_query for this one since we do not have an endpoint to do this. However, I would double-check with the team in regard to this. I would get back to you as soon as I hear from them.
I wish you all the best, and again no worries!
Have a great weekend ahead.
Hi @koulouridis, thanks for your patience here. I could confirm that one of our devs agreed to what I suggested to you saying:
Yes, They’d want two WHERE clauses, one for the tag and a “not in” for the “payload”.
Let me know if this helps.
Hey Abz, all good so far!
I’ve created a manual step by step on how the whole events process is working, it’s in a private GitHub repo.
If you need me to share it with you, let me add you as a collaborator for the time being because the company I’m currently working, they do not feel ready to share it yet.
Thank you for all your time!!
Hi @koulouridis, awesome! Good to know, and thanks for confirming. No need to add me as a collaborator, and as per our policy, we are not allowed to do so as well.
No worries, and please do not hesitate to contact us again if you need help or assistance. We’d be glad to help you out.
Lastly, if you have some time to review — that would be amazing and will make my day. 🙂
Appreciate your patience as well. Have a great day.
Hey Abz, I tried to write a review, but it redirects me to a review I already submitted few weeks ago.
I can edit it if you wish, or is there another way that I’m missing?
Hi @koulouridis, awesome it seems like you already submitted a review before. No need to update it, appreciate you reviewing us and spreading the word.
I’d be marking this ticket as resolved, please do create another ticket for different issues as it helps us track down issues/topics more efficiently.
Have a great long weekend. 🙂
- You must be logged in to reply to this topic.