Notes Field

Melvin F

Does any one know what table in SQL the notes field in the CRM ties back to?
Or does anyone know how i can extract notes along with other fields for an
export.
--
IT Manager

MD

You can access CRM Notes data from the FilteredAnnotation view. The text of
the Notes are in the column "NoteText". You will need to join on the ObjectId
to the enitity's Id field. For eg:
SELECT
Ac.[Name], An.NoteText
FROM
FilteredAccount Ac
LEFT JOIN FilteredAnnotation An
ON Ac.AccountId = An.AnnotationId

HTH,

--MD



"Melvin F" wrote:

> Does any one know what table in SQL the notes field in the CRM ties back to?
> Or does anyone know how i can extract notes along with other fields for an
> export.
> --
> IT Manager

Melvin F

Thank you . This works perfectly. I will modify the query to suit me but
thank you.
--
IT Manager


"MD" wrote:

> You can access CRM Notes data from the FilteredAnnotation view. The text of
> the Notes are in the column "NoteText". You will need to join on the ObjectId
> to the enitity's Id field. For eg:
> SELECT
> Ac.[Name], An.NoteText
> FROM
> FilteredAccount Ac
> LEFT JOIN FilteredAnnotation An
> ON Ac.AccountId = An.AnnotationId
>
> HTH,
>
> --MD
>
>
>
> "Melvin F" wrote:
>
> > Does any one know what table in SQL the notes field in the CRM ties back to?
> > Or does anyone know how i can extract notes along with other fields for an
> > export.
> > --
> > IT Manager