Identify the Internal SharePoint Column Name

SharePoint retains the column name used at the time the column was created, even if the column is renamed. The internal column name is the one that BrightWork Reporter needs. There are a few ways to identify the real column name.

Note:

Column names are case sensitive, for example, if the internal column name was 'soMEcolUMN', this is the arrangement you would have to use.

From the Column Visibility Settings Page

  1. Click List | List Settings.
  2. Click Column Visibility Settings (BrightWork)

From the Column Setting Page URL

  1. Click List | List Settings.
  2. Click the Link belonging to the column whose name you want to identify.
  3. The column name will be appended to the page URL, for example:
    http://sitecolection/sites/site/list/_layouts/FldEditEx.aspx?List=%7B41B7A352%2D7FD4%2D4D34%2D8DE6%2DF542D45A58AD%7D&Field=AssignedTo

Note:

Spaces in column names in SharePoint are returned as _x0020_ (or %5Fx0020%5F in a browser address window). This is why it is good practice not to use spaces in column names when creating them!

From Business Data Catalog Columns

Business Data Catalog is a shared service that stores information about the data in business applications that exist outside Microsoft Office SharePoint Server. You can use the service to display business data on a SharePoint site and thus display the data in BrightWork Reporter.

To find out the underlying SharePoint name of a Business Data Catalog column:

  1. Open a view where the column is displayed.
  2. Right-click and select View Source.
  3. Search for the Displayname of the Business Data Catalog column whose real SharePoint name you want to find out.
    The real name will be displayed before the DisplayName, as shown in the below image.

Project Metrics List Columns

See Project Metrics Columns for all the Project Metrics List column names.

Hidden Columns

Certain columns in some lists are not displayed on the List settings page. These columns and their real SharePoint names are detailed below.

Column Display Name

Real SharePoint Column Name

Outline Level

bwWBSOutlineLevel

Outline Number

bwWBSOutlineNumber

Status Code

bwStatusCode

Priority Code

bwPriorityCode

Status Indicator Code

bwStatusIndicatorCode

Send feedback on this help.