We are trying to see what the state of our CONTACT database is. We want to find the last action taken (wtih date) and type of that action for each CONTACT in our database.
I am using, as suggested by the Dutch SO-supportteam, the TRAVELTRANSACTIONLOG table.
This is my query so far:
CONTACT.name, TRAVELTRANSACTIONLOG.ttime, TRAVELTRANSACTIONLOG.type
inner join SuperOffice7.CRM7.CONTACT on
TRAVELTRANSACTIONLOG.record_id = CONTACT.contact_id
It looks like it's getting met the latest actions taken on our CONTACTs, but I can't find the TRAVELTRANSACTIONLOG.type, so I have no clue what the action taken actually means...
Of course there's also the possibiblity of me having taken a wrong approach on the problem in the first place.