Property Name

Description

Source Type

This field indicate where the data comes from.  There are four possible values for this field.

• Table (DNN) : This option indicates that the source table is a DNN type table.  DNN typed table is a table that uses the ObjectQualifier attribute in DNN

• Table (Non-DNN): This option indicates that the source table is a normal table without using the DNN object qualifier attribute.

• Stored Procedure (DNN):  This option indicates that source data comes from a stored procedure that uses the ObjectQualier attribute in DNN

• Stored Procedure (Non-DNN): This option indicate the source data comes from a stored procedure that does not use the ObjectQualifier attribute in DNN

Source Name

Specifies the table name or the stored procedure name of the data source.  Stored procedure can have a list dynamic parameters separated by a comma

.

Supported dynamic parameters for Stored procedures are:

• {UID} : User ID of current logged on user

• {USERNAME} : User name of current logged on user

• {FULLNAME} : Full name of current logged on user

• {PORTALID} : ID of the current portal

• {PORTALNAME} : Name of the current portal

• {PORTALALIAS} : Alias of the current portal

• {MODULEID} : ID of the current Enterprise Forms module

• {PAGEID} : ID of the current page the Enterprise Forms module belong to

• {PAGENAME} : Name of the current page the Enterprise Forms module belong to

• {HOSTIP} : IP address of the current logged on user

• {HOSTNAME} : Host name address of the current logged on user

• {USERAGENT} : User agent string of the browser

• {STATEID}:  ID of current form state

Example:  SomeStoredProcedureName {UID}, {PORTALID}, \'Hardcoded text\'

The above stored procedure have 3 parameters, 2 of which are dynamic and the last one is a static value.

Value Column

Specifies the name of the source table column to bind to the Value field for the element.

Text Column

Specifies the name of the source table column to bind to the Text field for the element.