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.
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 byJim Glass JrMonday, May 18, 2009 2:39 PM
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.
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 byJim Glass JrMonday, May 18, 2009 2:39 PM