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

    Advertisements

    4 Comments

    1. May 7, 2008 at 11:21 AM

      […] CAML Requires Internal Name […]

    2. Nita Arvind said,

      October 21, 2009 at 11:11 AM

      Hi,
      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:

    WordPress.com Logo

    You are commenting using your WordPress.com 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: