Query on appointment reference field

[vgangoo]

How would I do a query on the Reference field of Goldmine appointments? We can do queries on the opportunity/project field but not on reference.

 

[DJHunt]

select *
from CAL
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

 

[vgangoo]

Thanks for your reply, DJ. That worked! Only thing is that it only pulls open calendar entries and not closed ones. Is there a way I can pull all entries, both open and closed?