I am looking to report on the metadata of my server.
In historical_event there are no lines on some of my sites.
I have data from these sites in other PostGreSQL tables, but not in the main table. I do not have the events of these sites.
Could you help me on the subject?
4 answers
OK thanks a lot !
In fact Id of hist_site join with Actor_SiteID of hisorical_events.
But the If of Site table is not the same as the Actor_Site_ID of historical_events!
Site ID join with hist_site Site_id
OK, it's not very easy and understandable, but thanks to your help, I got it.
The doc should be clearer on the joins. It's not really user friendly :)
