-
1. Re: What table for Activity's Reference?
JErste Aug 10, 2017 11:29 AM (in response to FOzali)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'
-
2. Re: What table for Activity's Reference?
FOzali Aug 10, 2017 4:42 PM (in response to JErste)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
-
3. Re: What table for Activity's Reference?
John Neighbors Aug 10, 2017 5:06 PM (in response to FOzali)1 of 1 people found this helpfulGoldMine 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.
-
4. Re: What table for Activity's Reference?
FOzali Aug 10, 2017 5:35 PM (in response to John Neighbors)Hi John!
Thank you very much for the answer!
It really helps! Thanks heaps man!!