Ticket-Checkin with QR-CODE
I created a wpdatatable by querying the POST and POSTMETA tables for ticktets.
Background is to find in a chart during an Event how many tickets are already check-in and how many are still outstanding.
I used for that purpose the field meta_key=’status’ in table POSTMETA. (All records showed the value “check-in”).
After having checked-in one ticket, the status however did not change.
Question: Where is this information stored in database?
many thanks and kind regards
JJ
-
-
Nov 9,2021 AT 6:33PM -
Posted 2 years ago
- #258825
Thank you for your messages, I am going to assign this ticket to Ashan and he will be able to take it from here and find you a solution. Please allow some time for him to get back to you, we greatly appreciate your patience and thank you for being a eventon customer!
-
Nov 11,2021 AT 3:53AM -
Posted 2 years ago
- #258989
Hello
Is there a chance to get this little answer quite soon, we have a large event on Saturday, and I wanted to us this new report for monitoring how many people have already checked-in during the evening.
Many thanks and kind regards
JJ
-
Nov 15,2021 AT 1:02PM -
Posted 2 years ago
- #259448
Hey Jean,
We are trying for this, we have escalated it with the highest priority
-
Nov 17,2021 AT 4:52AM -
Posted 2 years ago
- #259676
Hey,
Sorry for stressing you, but I need to get an answer, as I cannot run my statistics!
Is simply need to know where to find the STATUS of a ticket “Check-in” or “Checked” (see attachment)
I queried table POSTMETA with meta_key = ‘status’ but the status always shows the value “check-in”, even after a ticket has been checked-in. (Status should then be “checked”)
That information must therefore be stored somewhere else in Database. A simple look in your code should show this easily.
Thanks a lot !
JJ
-
Nov 17,2021 AT 4:50PM -
Posted 2 years ago
- #259839
Hey there so that is actually stored in post_type = evo-tix and then postmeta field = ‘status’
-
Nov 19,2021 AT 6:05AM -
Posted 2 years ago
- #260045
Hi,
I am quite disappointed about your feedback, as this is exactly what I already did. But the result is NOT what you state here above.
Attached is what I did against the database ! The field status always shows the value “check-in” and not “checked” for the real checked tickets !
Can you please urgently advise, as I am still blocked.
- Nov 19,2021 AT 6:07AM - Posted 2 years ago - #260048
-
Nov 19,2021 AT 6:10AM -
Posted 2 years ago
- #260050
Here the attachment
-
Nov 21,2021 AT 1:03PM -
Posted 2 years ago
- #260236
Hi There,
Can u provide us with backend access?
-
Nov 26,2021 AT 8:48AM -
Posted 2 years ago
- #260885
Hello,
Can I please have a feedback. It cannot be that I have given you an Admin Access to our Site, opening the door to you….. and that nothing happens anymore!
We pay a lot of licence fees for your plugins, support should be able to give me an answer to this little question.
Many thanks and have a good day
-
Dec 11,2021 AT 3:21AM -
Posted 1 year ago
- #262528
Hey Jean,
We are sorry for the delay, but we are still trying to figure this out.We have escalated with top priority so there are no delays.
-
Dec 14,2021 AT 4:58PM -
Posted 1 year ago
- #262949
My apologies mate, we’ve been running heavy past few weeks with cyber week stuff. Ok let me get you straightened out here. 🙂 Doing some debugging now.
-
Dec 14,2021 AT 5:06PM -
Posted 1 year ago
- #262952
Ok here you go.
So the “status” value was legacy method. My sincere apologies. We are storing the status as an array with corresponding ID and status in meta key “ticket_ids”
-
Dec 14,2021 AT 5:07PM -
Posted 1 year ago
- #262954
image again.
-
Dec 14,2021 AT 5:10PM -
Posted 1 year ago
- #262956
So you can use a query like SELECT * WHERE meta_kay LIKE ‘%checked’ I am not sure exactly what you are trying to do?
-
Nov 9,2021 AT 6:33PM -
Posted 2 years ago
- #258825
