locked
Each task includes a column called “ID”. Where the “ID” column came from? RRS feed

  • Question

  • Hi,

    When I review the “Task” list’s columns, it includes a column called “ID”. When I trace the chain of content type inheritance, I cannot find which exact content type includes the “ID” column.

    Where the “ID” column in each task came from?

    Thank you,

    Monday, May 14, 2012 1:08 PM

Answers

  • Hi Allan,

    The "ID" column that you see in your task list is an Internal column (hidden site column). You can verify this by adding "/_layouts/fldedit.aspx?field=ID" after the url of your site collection (for eg: http://sharepoint2010server/_layouts/fldedit.aspx?field=ID)

    Few attributes of this hidden site column (ID) are as follows:

    Internal Name : "ID"
    Display Name: "ID"
    Field Guid : {1d22ea11-1e32-424e-89ab-9fedbadb6ce1}
    Field Type : Counter
    Site column group : "_Hidden"

    Also, the Base Content Type that adds this hidden internal "ID" column to all SharePoint lists/documents is "Item" Content Type (0x01). However, you won't be able to see this "ID" field directly from the SharePoint UI (i.e. on the "/_layouts/ManageContentType.aspx?ctype=0x01" page) just like the ootb "Title" field as this "ID" field is hidden. 

    Please have a quick look at other internal field names that are used in SharePoint:
    http://blogs.msdn.com/b/michael_yeager/archive/2008/11/03/reference-list-for-internal-field-names.aspx

    Hope this helps!

    Regards, 
    Devang Bhavsar

    Monday, May 14, 2012 5:14 PM
  • Hi,

    You can get the internal name for a column by browsing to the List Settings > Edit Column and look at the QueryString.  This will be url encoded but is a simple way of retrieving the internal name without writing any code.  You will get something like:

    /_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

    %5F is a '_'.  The field name is Product_x0020_Description.

    The code option is to use:

    string itemInternalName = item.Fields["Field Display Name"].InternalName;

    http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/75ca6fab-56f3-4bf4-aae0-2d29821778a2

    Thanks,

    Rock Wang

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Rock Wang TechNet Community Support

    Tuesday, May 15, 2012 2:35 AM

All replies

  • Hi Allan,

    The "ID" column that you see in your task list is an Internal column (hidden site column). You can verify this by adding "/_layouts/fldedit.aspx?field=ID" after the url of your site collection (for eg: http://sharepoint2010server/_layouts/fldedit.aspx?field=ID)

    Few attributes of this hidden site column (ID) are as follows:

    Internal Name : "ID"
    Display Name: "ID"
    Field Guid : {1d22ea11-1e32-424e-89ab-9fedbadb6ce1}
    Field Type : Counter
    Site column group : "_Hidden"

    Also, the Base Content Type that adds this hidden internal "ID" column to all SharePoint lists/documents is "Item" Content Type (0x01). However, you won't be able to see this "ID" field directly from the SharePoint UI (i.e. on the "/_layouts/ManageContentType.aspx?ctype=0x01" page) just like the ootb "Title" field as this "ID" field is hidden. 

    Please have a quick look at other internal field names that are used in SharePoint:
    http://blogs.msdn.com/b/michael_yeager/archive/2008/11/03/reference-list-for-internal-field-names.aspx

    Hope this helps!

    Regards, 
    Devang Bhavsar

    Monday, May 14, 2012 5:14 PM
  • Hi,

    You can get the internal name for a column by browsing to the List Settings > Edit Column and look at the QueryString.  This will be url encoded but is a simple way of retrieving the internal name without writing any code.  You will get something like:

    /_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

    %5F is a '_'.  The field name is Product_x0020_Description.

    The code option is to use:

    string itemInternalName = item.Fields["Field Display Name"].InternalName;

    http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/75ca6fab-56f3-4bf4-aae0-2d29821778a2

    Thanks,

    Rock Wang

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Rock Wang TechNet Community Support

    Tuesday, May 15, 2012 2:35 AM