locked
easy question? Where are the notes data stored? e.g. the notes data from the account entity? RRS feed

  • Question

  • easy question? Where are the notes data stored? e.g. the notes data from the account entity...
    I need to access it via SQL.

    Thanks :)
    Thursday, April 30, 2009 1:55 AM

Answers

All replies

  • found it :)

    use table "AnnotationBase" (in the Notetext Field)

    • Marked as answer by Phil98765 Thursday, April 30, 2009 2:09 AM
    Thursday, April 30, 2009 2:08 AM
  • Ideally you should be using the FilteredAnnotations view rather than hitting the tables directly.

    Leon Tribe
    Want to hear me talk about all things CRM? Check out my blog
    Sunday, May 3, 2009 7:42 AM
  • Leon is correct - you're better off using the FilteredAnnotations view.

    (Using the Filteredentity views are inevitably better than querying the tables directly, not only because it's the supported method, but also because it preserves security, adjusts the date/times to your local time settings and takes care of the joins to related entities and lables for picklists.)
    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Sunday, May 3, 2009 10:26 AM
    Moderator
  • OK - Thanks :)
    Sunday, May 3, 2009 11:27 PM