Re: query on appointment reference field - need closed entries

[vgangoo]

Need a query on the appointment reference field that pulls both open and closed calendar entries. Got an excellent one from DJ Hunt but it pulls only open entries:

select *
from CAL
where Ref like '%find this%'

 

[DJHunt]

Closed Calendar activities are stored in the ContHist ( History ) table:

select *
from ContHist
where Ref like '%find this%'

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- GoldMine Premium - The Definitive Guide
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US