Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

FieldRef Element (List)

Windows SharePoint Services 3

Represents a reference to a field. The FieldRef element is used in computed fields to refer to the constituent fields.


<FieldRef
  Alias = "Text"
  Ascending = "TRUE" | "FALSE"
  CreateURL = "Text"
  DisplayName = "Text"
  Explicit = "TRUE" | "FALSE"
  ID = "Text"
  Key = "Text"
  Name = "Text"
  RefType = "Text"
  ShowField = "TRUE" | "FALSE"
  TextOnly = "TRUE" | "FALSE"
  Type = "Text">
</FieldRef>
Attribute Description

Alias

Optional Text.

Ascending

Optional Boolean. This specifies the sort order on a FieldRef element that is defined in a view. The default value is TRUE.

CreateURL

Optional Text. Specifies the URL for the .aspx file that is used to create a Meeting Workspace site.

DisplayName

Optional Text. This attribute provides the display name of the field that is referenced.

Explicit

Optional Boolean. This attribute is supported only within the ViewFields element. TRUE if the field is explicitly declared in the view definition and is not returned in a Fields enumeration inside a view.

ID

Optional Text. Specifies the GUID that identifies the field.

Key

Optional Text. If set to Primary, specifies that the field is the primary key for its table and thus uniquely identifies each record in the table.

Name

Required Text. This attribute provides the internal name of the field that is referenced.

RefType

Optional Text. Specifies the type of reference for a field in an events list.

ShowField

Optional Text. The ShowField attribute can be set to the field name to display. By default, a hyperlinked text from the Title field of the record in the external list is displayed. But the ShowField attribute can be used to override that and display another field from the external list.

The following data types are allowed as targets of a ShowField attribute: Text, Choice, and Counter.

TextOnly

Optional Boolean. Specifies that the field contains only text values.

Type

Optional Text. Specifies the function that is applied to a totals column or a calculated column. The following table describes possible values.

  • AVG   Average value. Applies to DateTime Number, Integer, and Currency field types.

  • COUNT   Number of items. Applies to all field types that allow aggregation.

  • MAX   Maximum value. Applies to DateTime Number, Integer, and Currency field types.

  • MIN   Minimum value. Applies to DateTime Number, Integer, and Currency field types.

  • SUM   Sum of values. Applies to Number, Integer, and Currency field types.

  • STDEV   Standard deviation. Applies to Number, Integer, and Currency field types.

  • VAR   Variance. Applies to Number, Integer, and Currency field types.

The values for the Type attribute are not case-sensitive.

Minimum: 0

Maximum: Unbounded

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.