CAML Requires Internal Name

Whenever querying anything in CAML it requires internal name of field / list. for e.g

  • Field name with ‘AS.TaskName’ will have internal name AS_x002e_TaskName so in query it woud be like
    FieldRef Name=’AT_x002e_TaskName’
  • Field name ‘Created’ is having internal name ‘Author’
  • Best way to find the internal name of the filed is to edit the field and it will be found in the end of URL


    1. May 7, 2008 at 11:21 AM

      […] CAML Requires Internal Name […]

    2. Nita Arvind said,

      October 21, 2009 at 11:11 AM

      Agreed that internal names are to be used in a caml… but how do you find the internal column names programatically?

      • Nita Arvind said,

        October 21, 2009 at 11:13 AM

        think I found the answer:

        DataTable table = list.GetItems (list.DefaultView).GetDataTable();
        foreach(DataColumn column in table.Columns)
        column.ColumnName = list.Fields.GetFieldByInternalName(column.ColumnName).Title;

    3. Perie Morsta said,

      February 5, 2011 at 7:19 PM

      Hammer! Diese Story hatte ich garnicht fur moglich gehalten 😉

    Leave a Reply

    Fill in your details below or click an icon to log in: Logo

    You are commenting using your account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: