Hey there,
I’m trying to understand more about actions in their respective visit. Precisely, I’m looking for a timestamp related to actions stored in log_action db. As a timestamp is missing in log_action, I was going to join log_action and log_link_visit_action. But I’m not sure about the appropriate join key to log_action.idaction and I’m down to guessing. Any suggestion out there? Help appreciated!
Many thanks in advance,
Steffen
There are more possible join keys. That depends on what data you’re searching for. idaction url / action name / url ref / etc. the actions table is just a lookup. I think, in general, you can use all columns starting with “idaction” from the “log_link_visit_action” table to join with the actions table.
I think you’re on the right track joining those two tables. From what I remember, idaction is the key that links them, so you can match log_link_visit_action.idaction_url or idaction_name with log_action.idaction. The timestamp should come from log_link_visit_action.server_time. It’s a bit confusing at first, but once you map those fields it starts to make sense.