Appointments in the Pending tab are stored in the [CAL] table with [RECTYPE] = 'A'
Appointments in the History tab are stored in the [CONTHIST] table with [SRECTYPE] = 'A'
Hi Joseph,
Im running query like this:
SELECT userid, count(*) as seen from conthist
WHERE srectype = 'A'
AND ref= 'In Home Meeting'
GROUP by userid
ORDER by seen desc
But it will give me zero result because the refence that I put in Appointment is not saved in conthist.ref (somehow).
Do you know what is the solution for this?
Thank you
GoldMine tucks some additional content into the reference line, behind the scenes.
Instead of this:
AND ref= 'In Home Meeting'
Try this:
AND ref like 'In Home Meeting%'
Hope this feedback helps.
Hi John!
Thank you very much for the answer!
It really helps! Thanks heaps man!!
