Accessing Notes field for reporting

hi

CRM has a notes field in pretty much all of its system entities and custom
entities. I am wanting to know how using SQL i can grab the information in
notes field.

For example, if i run a simple query select * from lead

there is no field called notes .

Can someone please advice me on this.

Kind Regards
Ridhima

Frederic
Thu Sep 21 05:32:13 CDT 2006

Their is a seperate table called AnnotationBase in which the notes are
stored.

HTH,

Frederic @ Travi@ta

Ridhima Sood schreef:

> hi
>
> CRM has a notes field in pretty much all of its system entities and custom
> entities. I am wanting to know how using SQL i can grab the information in
> notes field.
>
> For example, if i run a simple query select * from lead
>
> there is no field called notes .
>
> Can someone please advice me on this.
>
> Kind Regards
> Ridhima

RidhimaSood
Thu Sep 21 21:43:02 CDT 2006

Thanks heaps Frederic. Was perfect :).... thanks tonnes again.

"Frederic @ Traviata" wrote:

> Their is a seperate table called AnnotationBase in which the notes are
> stored.
>
> HTH,
>
> Frederic @ Travi@ta
>
> Ridhima Sood schreef:
>
> > hi
> >
> > CRM has a notes field in pretty much all of its system entities and custom
> > entities. I am wanting to know how using SQL i can grab the information in
> > notes field.
> >
> > For example, if i run a simple query select * from lead
> >
> > there is no field called notes .
> >
> > Can someone please advice me on this.
> >
> > Kind Regards
> > Ridhima
>
>