DataAccessFormControlProperties Type

The SQL Request control allows you to look up values from SQL databases.

This topic describes the syntax of the FormControlProperty complex element with the type attribute of DataAccessFormControlProperties.

Syntax


<d2p1:FormControlProperties xmlns:d3p1="http://schemas.datacontract.org/2004/07/Nintex.Forms.SharePoint.FormControls" i:type="d3p1:DataAccessFormControlProperties">
    <d2p1:Border />
    <d2p1:BorderColor>#000000</d2p1:BorderColor>
    <d2p1:BorderStyle>Solid</d2p1:BorderStyle>
    <d2p1:BorderWidth>2</d2p1:BorderWidth>
    <d2p1:CanResizeAtRuntime>true</d2p1:CanResizeAtRuntime>
    <d2p1:ControlVersion>101.1.1.0</d2p1:ControlVersion>
    <d2p1:CssClass i:nil="true" />
    <d2p1:DisplayName>SQL Request</d2p1:DisplayName>
    <d2p1:FormControlTypeUniqueId>7733d5bf-11c6-4bdc-a430-79c3065a796c</d2p1:FormControlTypeUniqueId>
    <d2p1:FormType>ListForm</d2p1:FormType>
    <d2p1:InRepeater>false</d2p1:InRepeater>
    <d2p1:InsertReferences xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
    <d2p1:InternalPropertyBag xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
    <d2p1:IsDirty>false</d2p1:IsDirty>
    <d2p1:IsLocked>false</d2p1:IsLocked>
    <d2p1:IsVisible>true</d2p1:IsVisible>
    <d2p1:PaddingWidth>0</d2p1:PaddingWidth>
    <d2p1:TabIndex>0</d2p1:TabIndex>
    <d2p1:UniqueId>3bfd50f6-0217-4b94-bf18-8e67591f13c5</d2p1:UniqueId>
    <d2p1:VariableSource>Unspecified</d2p1:VariableSource>
    <d2p1:VerticalAlign>NotSet</d2p1:VerticalAlign>
    <d2p1:BackgroundColor i:nil="true" />
    <d2p1:Bold>false</d2p1:Bold>
    <d2p1:FontColor i:nil="true" />
    <d2p1:FontFamily i:nil="true" />
    <d2p1:FontFamilyItemId i:nil="true" />
    <d2p1:FontSize i:nil="true" />
    <d2p1:FontSizeItemId i:nil="true" />
    <d2p1:HorizontalAlignment>NotSet</d2p1:HorizontalAlignment>
    <d2p1:Italics>false</d2p1:Italics>
    <d2p1:StrikeThrough>false</d2p1:StrikeThrough>
    <d2p1:ThemeClass i:nil="true" />
    <d2p1:Underline>false</d2p1:Underline>
    <d2p1:ControlCssClass i:nil="true" />
    <d2p1:ControlMode>Auto</d2p1:ControlMode>
    <d2p1:CustomErrorMessage i:nil="true" />
    <d2p1:CustomValidationFunction i:nil="true" />
    <d2p1:DataField i:nil="true" />
    <d2p1:DataFieldDisplayName i:nil="true" />
    <d2p1:ExposeClientIdAsJavascriptVariable>false</d2p1:ExposeClientIdAsJavascriptVariable>
    <d2p1:ExposedClientIdJavascriptVariable i:nil="true" />
    <d2p1:HelpText i:nil="true" />
    <d2p1:HelpTextSet i:nil="true" />
    <d2p1:IsEnabled>true</d2p1:IsEnabled>
    <d2p1:IsRequired>false</d2p1:IsRequired>
    <d2p1:Name i:nil="true" />
    <d2p1:RequiredErrorMessage i:nil="true" />
    <d2p1:UseCustomValidation>false</d2p1:UseCustomValidation>
    <d3p1:CascadeFilterFieldStoredProc i:nil="true" />
    <d3p1:CascadeFilterValueStoredProc i:nil="true" />
    <d3p1:CascadeType>None</d3p1:CascadeType>
    <d3p1:ConnectionTimeout>10</d3p1:ConnectionTimeout>
    <d3p1:CustomPleaseSelectText i:nil="true" />
    <d3p1:DataConnectionType>MsSql</d3p1:DataConnectionType>
    <d3p1:DataFieldId i:nil="true" />
    <d3p1:DataFieldText i:nil="true" />
    <d3p1:Database i:nil="true" />
    <d3p1:DefaultValue i:nil="true" />
    <d3p1:DisplayFormat>DropDownList</d3p1:DisplayFormat>
    <d3p1:ExecuteInEditMode>true</d3p1:ExecuteInEditMode>
    <d3p1:ExecuteInNewMode>true</d3p1:ExecuteInNewMode>
    <d3p1:ExecuteInViewMode>false</d3p1:ExecuteInViewMode>
    <d3p1:IdField i:nil="true" />
    <d3p1:QueryType>StoredProcedure</d3p1:QueryType>
    <d3p1:SecureStoreTargetApplicationId i:nil="true" />
    <d3p1:Server i:nil="true" />
    <d3p1:SqlStatement i:nil="true" />
    <d3p1:StoredProcName i:nil="true" />
    <d3p1:StoredProcParameters></d3p1:StoredProcParameters>
    <d3p1:TypeOfAuthentication>SqlAuthentication</d3p1:TypeOfAuthentication>
    <d3p1:UseCustomPleaseSelectText>false</d3p1:UseCustomPleaseSelectText>
    <d3p1:ValidateDataMismatch>Yes</d3p1:ValidateDataMismatch>
    <d3p1:ValueField i:nil="true" />
</d2p1:FormControlProperties>

Element Characteristics

Characteristic Description
Data type and length String
Default value None
Cardinality 1..1: Required element that occurs only once.

Element Attributes

Attribute Description
  Required

Relationships

Relationship Element
Parent element FormForm/FormControls
Child elements See the child element table.

Parent Element Namespace

Prefix Namespace
d2p1 http://schemas.datacontract.org/2004/07/Nintex.Forms.FormControls

Parent Element

Attribute Description
  Required

Child Elements

Name Data Type Default value Cardinality Description
Border String blank 1..1

The line style. Values include: Bottom, Left, Right, and Top.
BorderColor String #000000 1..1

The color of the line.
BorderStyle String Solid 1..1

The line style. Values include: Dashed, Dotted, Double, Groove, Inset, None, None, NotSet, Outset, Ridge, and Solid. For more information see the base enumeration documentation on MSDN.
BorderWidth Integer 2 1..1

The width of the line in pixels.
CanResizeAtRuntime Boolean true 1..1

Indicates if the control can resize at run time.
ControlVersion String 101.1.1.0 1..1

The version number of the control.

CssClass String Choice 1..1

The CSS class.
DisplayName String SQL Request 1..1

The display name.
FormControlTypeUniqueId String 7733d5bf-11c6-4bdc-a430-79c3065a796c 1..1

The form control type unique id.
FormType String ListForm 1..1

The type of the form.
InRepeater Boolean false 1..1

Value is true if in repeater; otherwise, false.
InsertReferences String blank 1..*

The insert references.
InternalPropertyBag String blank 1..*

The internal property bag.
IsDirty Boolean false 1..1

True if the object is dirty; otherwise, false. The value indicating whether the control exists in any layout. If this flag is set then it is safe to delete the control from the list.
IsLocked Boolean false 1..1

True if this instance is locked; otherwise, false.
IsVisible Boolean true 1..1

True if this instance is visible; otherwise, false.
PaddingWidth Integer 0 1..1

The width of the padding.
TabIndex Integer 0 1..1

The index of the tab.
UniqueId String Guid 1..1

The unique id. For more information see "Guid Structure" on MSDN/
VariableSource String Unspecified 1..1

The source. Values include: External, SharePoint, Unspecified, and Workflow.
VerticalAlign String NotSet 1..1

The width of the padding. Valid values include:

  • Bottom

    Text or object is aligned with the bottom of the enclosing control.

  • Middle

    Text or object is aligned with the center of the enclosing control.

  • NotSet

    Vertical alignment is not set.

  • Top

    Text or object is aligned with the top of the enclosing control.
BackgroundColor String blank 1..1

The color of the background.
Bold Boolean false 1..1

True if bold; otherwise, false.
FontColor String blank 1..1

The color of the font.
FontFamily String blank 1..1

The font family.
FontFamilyItemId String blank 1..1

The font family item id.
FontSize String blank 1..1

The size of the font.
FontSizeItemId String blank 1..1

The font size item id.
HorizontalAlignment String NotSet 1..1

The horizontal alignment. Values include: Center, Justify, Left, NotSet, and Right. For more information, see "Horizontal Enumeration" in MSDN.
Italics Boolean false 1..1

True if italics; otherwise, false.
StrikeThrough Boolean false 1..1

True if [strike through]; otherwise, false.
ThemeClass String blank 1..1

The theme class.
Underline Boolean false 1..1

True if use custom validation; otherwise, false.
ControlCssClass String blank 1..1

The control CSS class.
ControlMode String Auto 1..1

Species the mode of the control. Valid values include:

  • Auto
  • Edit
  • ReadOnly
CustomErrorMessage String blank 1..1

The required error message.
CustomValidationFunction String blank 1..1

The custom validation function.
DataField String blank 1..1

The binding path field name.
DataFieldDisplayName String blank 1..1

The display name of the data field.
ExposeClientIdAsJavascriptVariable Boolean false 1..1

True if expose client id as JavaScript variable; otherwise, false.
ExposedClientIdJavascriptVariable String blank 1..1

The exposed client id JavaScript variable.
HelpText String blank 1..1

The help text.
HelpTextSet String blank 1..1

The help text set.
IsEnabled Boolean true 1..1

True if this instance is enabled; otherwise, false.
IsRequired Boolean false 1..1

True if this instance is required; otherwise, false.
Name String blank 1..1

The name of the control.
RequiredErrorMessage String blank 1..1

The required error message.
UseCustomValidation Boolean false 1..1

True if use custom validation; otherwise, false.
CascadeFilterFieldStoredProc String blank 1..1
CascadeFilterValueStoredProc String blank 1..1
CascadeType String None 1..1
ConnectionTimeout String 10 1..1
CustomPleaseSelectText String blank 1..1
DataConnectionType String MsSql 1..1
DataFieldId String blank 1..1
DataFieldText String blank 1..1
Database String blank 1..1
DefaultValue String blank 1..1
DisplayFormat String DropDownList 1..1
ExecuteInEditMode Boolean true 1..1
ExecuteInNewMode Boolean true 1..1
ExecuteInViewMode Boolean false 1..1
IdField String blank 1..1
QueryType String StoredProcedure 1..1
SecureStoreTargetApplicationId String blank 1..1
Server String blank 1..1
SqlStatement String blank 1..1
StoredProcNme String blank 1..1
StoredProcParameters String blank 1..1
TypeOfAuthentication String SqlAuthentication 1..1
UseCustomPleaseSelectText Boolean false 1..1
ValidateDataMismatch String Yes 1..1
ValueField String blank 1..1

Example

The following example contains an example of the complex element.



<d2p1:FormControlProperties xmlns:d3p1="http://schemas.datacontract.org/2004/07/Nintex.Forms.SharePoint.FormControls" i:type="d3p1:DataAccessFormControlProperties">
    <d2p1:Border />
    <d2p1:BorderColor>#000000</d2p1:BorderColor>
    <d2p1:BorderStyle>Solid</d2p1:BorderStyle>
    <d2p1:BorderWidth>2</d2p1:BorderWidth>
    <d2p1:CanResizeAtRuntime>true</d2p1:CanResizeAtRuntime>
    <d2p1:ControlVersion>101.1.1.0</d2p1:ControlVersion>
    <d2p1:CssClass i:nil="true" />
    <d2p1:DisplayName>SQL Request</d2p1:DisplayName>
    <d2p1:FormControlTypeUniqueId>7733d5bf-11c6-4bdc-a430-79c3065a796c</d2p1:FormControlTypeUniqueId>
    <d2p1:FormType>ListForm</d2p1:FormType>
    <d2p1:InRepeater>false</d2p1:InRepeater>
    <d2p1:InsertReferences xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
    <d2p1:InternalPropertyBag xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" />
    <d2p1:IsDirty>false</d2p1:IsDirty>
    <d2p1:IsLocked>false</d2p1:IsLocked>
    <d2p1:IsVisible>true</d2p1:IsVisible>
    <d2p1:PaddingWidth>0</d2p1:PaddingWidth>
    <d2p1:TabIndex>0</d2p1:TabIndex>
    <d2p1:UniqueId>3bfd50f6-0217-4b94-bf18-8e67591f13c5</d2p1:UniqueId>
    <d2p1:VariableSource>Unspecified</d2p1:VariableSource>
    <d2p1:VerticalAlign>NotSet</d2p1:VerticalAlign>
    <d2p1:BackgroundColor i:nil="true" />
    <d2p1:Bold>false</d2p1:Bold>
    <d2p1:FontColor i:nil="true" />
    <d2p1:FontFamily i:nil="true" />
    <d2p1:FontFamilyItemId i:nil="true" />
    <d2p1:FontSize i:nil="true" />
    <d2p1:FontSizeItemId i:nil="true" />
    <d2p1:HorizontalAlignment>NotSet</d2p1:HorizontalAlignment>
    <d2p1:Italics>false</d2p1:Italics>
    <d2p1:StrikeThrough>false</d2p1:StrikeThrough>
    <d2p1:ThemeClass i:nil="true" />
    <d2p1:Underline>false</d2p1:Underline>
    <d2p1:ControlCssClass i:nil="true" />
    <d2p1:ControlMode>Auto</d2p1:ControlMode>
    <d2p1:CustomErrorMessage i:nil="true" />
    <d2p1:CustomValidationFunction i:nil="true" />
    <d2p1:DataField i:nil="true" />
    <d2p1:DataFieldDisplayName i:nil="true" />
    <d2p1:ExposeClientIdAsJavascriptVariable>false</d2p1:ExposeClientIdAsJavascriptVariable>
    <d2p1:ExposedClientIdJavascriptVariable i:nil="true" />
    <d2p1:HelpText i:nil="true" />
    <d2p1:HelpTextSet i:nil="true" />
    <d2p1:IsEnabled>true</d2p1:IsEnabled>
    <d2p1:IsRequired>false</d2p1:IsRequired>
    <d2p1:Name i:nil="true" />
    <d2p1:RequiredErrorMessage i:nil="true" />
    <d2p1:UseCustomValidation>false</d2p1:UseCustomValidation>
    <d3p1:CascadeFilterFieldStoredProc i:nil="true" />
    <d3p1:CascadeFilterValueStoredProc i:nil="true" />
    <d3p1:CascadeType>None</d3p1:CascadeType>
    <d3p1:ConnectionTimeout>10</d3p1:ConnectionTimeout>
    <d3p1:CustomPleaseSelectText i:nil="true" />
    <d3p1:DataConnectionType>MsSql</d3p1:DataConnectionType>
    <d3p1:DataFieldId i:nil="true" />
    <d3p1:DataFieldText i:nil="true" />
    <d3p1:Database i:nil="true" />
    <d3p1:DefaultValue i:nil="true" />
    <d3p1:DisplayFormat>DropDownList</d3p1:DisplayFormat>
    <d3p1:ExecuteInEditMode>true</d3p1:ExecuteInEditMode>
    <d3p1:ExecuteInNewMode>true</d3p1:ExecuteInNewMode>
    <d3p1:ExecuteInViewMode>false</d3p1:ExecuteInViewMode>
    <d3p1:IdField i:nil="true" />
    <d3p1:QueryType>StoredProcedure</d3p1:QueryType>
    <d3p1:SecureStoreTargetApplicationId i:nil="true" />
    <d3p1:Server i:nil="true" />
    <d3p1:SqlStatement i:nil="true" />
    <d3p1:StoredProcName i:nil="true" />
    <d3p1:StoredProcParameters></d3p1:StoredProcParameters>
    <d3p1:TypeOfAuthentication>SqlAuthentication</d3p1:TypeOfAuthentication>
    <d3p1:UseCustomPleaseSelectText>false</d3p1:UseCustomPleaseSelectText>
    <d3p1:ValidateDataMismatch>Yes</d3p1:ValidateDataMismatch>
    <d3p1:ValueField i:nil="true" />
</d2p1:FormControlProperties>

Related information

Form XML Complex Elements