- TLC Home Home
- Discussions Discussions
- Documentation Documentation
- Knowledge Base Knowledge Base
- Education Education
- Blog Blog
- Support Desk Support Desk
12-01-2020 08:59 AM
Sorry if this is answered somewhere, but I've been trying to search and haven't found an answer.. So here goes... I'm querying the visitors table with a specific visitor_id inthe where clause and getting multiple rows. I was under the impression that visitor_id was the PK in this table and there would only be one row per distinct visitor_id.
In my example, I get 7 rows with an identical visitor_id, identical visitor_created timestamps, and different updated timestamps.
While this is an isolated visitor_id, there are others and I'm ultimately looking to query a few property values and badge values for visitors as of "now" and am having trouble getting unique values. Am I going about it wrong?
Solved! Go to Solution.
12-02-2020 09:34 AM
If you are wanting to query a current snapshot of visitors, we recommend using the visitors_view_normalized table instead of the visitors table.
Please let me know if that helps.
Copyright All Rights Reserved © 2008-2023