TechTalkz.com Logo Ask the Experts!

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Dynamics CRM

Notes Field

Microsoft Dynamics CRM

 
 
Thread Tools Display Modes
Unread 04-02-2008, 02:21 PM   #1
Melvin F
Guest
 
Posts: n/a
Notes Field

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
 
Unread 04-02-2008, 04:28 PM   #2
MD
Guest
 
Posts: n/a
RE: Notes Field

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

 
Unread 04-02-2008, 04:28 PM   #3
Melvin F
Guest
 
Posts: n/a
RE: Notes Field

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

 
 

Thread Tools
Display Modes



< Home - Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT. The time now is 03:06 PM.


vBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2013, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional