Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Campaign OwnerIdType? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello - I've noticed a Campaign.OwnerIdType of 8 in the database for a campaign.  Based on some googling this indicates that the campaign is owned by a User.  A Campaign.OwnerIdType of 9 indicates that the campaign is owned by the team.

    Where is a list of OwnerIdTypes stored?  I'm aware of 8 and 9 but is there a 1-7 stored somewhere as well?  I didn't find a OwnerIdType or OwnerType table in the database.

    Also, what is the impact of having 8 (user) vs 9 (team).  If OwnerTypeId = 8 then does this prevent other users having Append To access from being able to update the Campaign?

    Thursday, February 14, 2013 6:40 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Look in the view 'EntityView' - OwnerIdType = refers back to and Entity/Object Type Code

    SELECT ObjectTypeCode, Name
FROM
EntityView

    There shouldn't be any other type besides 8 or 9 because the Campaign entity is either owned by a User or Team record (see entity properties).

    Security is cumulative - ownership shouldn't prevent anything - your individual security profile and the profiles of any teams you are a member dictate your access/privileges on a record.

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Thursday, February 14, 2013 7:04 PM
    Moderator