Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to get the CreatedOn field value for Campaign Activity RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi there,

    I am querying the campaignactivity entity. When i am trying to set the order of result acc to "createdon" field, i am getting error that field does not exist. So i looked into following tables which are related to campaignactivity.

    campaignactivitybase,campaignactivityextensionbase,campaignactivityitembase.

    None of them actually have that field. What exactly i am missing here?

    Thanks!
    Thursday, May 14, 2009 6:47 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    In addition to Richard's response, you want to use filtered views when running queries.  Try to avoid querying the base tables.  The filtered views sometimes have the data you need and eliminate the need to join additional tables.

    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Monday, May 18, 2009 2:39 PM
    Thursday, May 14, 2009 8:07 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    The campaign activity is a sub-type of activity, so the only fields that appear in those tables are fields specific to campaign activities.  You need to query the activity pointer table and filter on activitytypecode 4402 to get the campaign activities.
    Thursday, May 14, 2009 7:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In addition to Richard's response, you want to use filtered views when running queries.  Try to avoid querying the base tables.  The filtered views sometimes have the data you need and eliminate the need to join additional tables.

    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Monday, May 18, 2009 2:39 PM
    Thursday, May 14, 2009 8:07 PM