Example External Data Source (EDS) Configurations in Forms

Set the following property values:

ZoomTo = ExternalDataDisplay.aspx?Source=SourceName

ReadOnly = True

Set the following property values:

DataLookup Type= External Data Source

DataObject = SourceName

DataTextField = “Column Name To Determine Value to Display”

DataValueField = “Column Name To Determine Value to Store”

Set the following property values:

ZoomTo = string.format(“ExternalDataDisplay.aspx?Source={0}”,{[field Name]}

Set the following property values:

FilterColumn = “Column name to filter in select statement”

FilterDataType = “System.String”

FilterOp = “EQ”, “GT”, “LT” or “NEQ” for (Equal, Greater Than, Less Than, Not Equal)

FilterWithControl = ”field in the form that contains value to pass for filtering”

ReadOnly = ”True”

ZoomTo = ”ExternalDataDisplay.aspx?source=source”

Set the following property values:

DataLookUp Type = Other DataSource = “EQM.UI.Web.ExternalDataProvider.ODBC.GetListValues(“SourceName”,CurrentUser, new string(){[FieldName]})”
DataTextField = “Column Name To Determine Value to Display ”
DataValueField = “Column Name To Determine Value to Store”
DynamicDataSource=”True”

NOTE: Make sure the SQL Query Statement in the external data display accepts the parameters as shown below:

Select ACT_CODE from V_ACT_ACTOR where ACT_Manager_Code = ?

Follow the steps below to convert a text field to a zoom field.

1. From the form, select the text field to be converted.
2. In the Zoom To field, enter ExternalDataDisplay.aspx?Source=SourceName (SourceName was defined in the SmartSolve application).
   Result: This maps the field to the external data source.
3. Replace SourceName with the External Data Source Name.

Multiple values are defined in Column to Return in External Data Sources and configure it to access an External Data Source.

This is an example of how to configure the Product Exception record to allow the PO Number field to zoom to an external data source, and also when selecting a PO number, a return PO Number, a Lot Number and a Unit Cost.

1. In External Data Sources, define three columns in the Columns To Return field. These are: PO Number; Lot Number; Part Cost.
2. From the Forms Designer window of the form, select the PO Number field to be used to access external data source.
3. In the ControlToUpdate field, enter the Control ID's of the Part Number, the Lot Number, and the Unit Cost fields, separated by a semicolon.

EXAMPLE: PXP_PO_NUMBER; EPL_LOT_NUMBER;PXP_UNIT_COST

The PO number will be saved in the PO Number field. The lot number will be saved in the Lot Number field. The part cost will be saved in the Unit Cost field.

4. In the ZoomTo field, enter ExternalDataDisplay.aspx?Source=SourceName.
5. Replace SourceName with the External Data Source Name.
6. In the ReadOnly field, enter True.

Follow the steps below to add external data to a drop down field.

1. Enter ExternalData in the DataObject field.
2. Enter ExternalData in the DataMember field.
3. Enter iif(not Page.IsPostBack,EQM.UI.Web.ExternalDataProvider.ODBC.GetListValues(“SourceName”,CurrentUser),nothing) in the DataSource field (i.e., SourceName was defined in the SmartSolve application).
4. Replace SourceName with the External Data Source Name.
5. Enter the column name to determine the value to display in the DataTextField field (this is the name of the column to be displayed in the drop down menu, such as Part name). If SQL Query Statement contains an alias column name, you must enter the alias name.
6. Enter the column name to determine the value to store in the DataValueField field (this is the name of the column to be entered into a record after the user has selected the data from the drop down menu, such as Part number).

NOTE: If the SQL Query Statement contains an alias column name, you must enter the alias name.

The procedure below is an example of further defining the use for External Data, for example; Filtering the Employee List by Department.

1. In External Data Sources, define an SQL Query Statement in the SQL Query Statement field with a where clause and use ? as the condition.

EXAMPLE: Select EH_NUMBER "Employee Number", EH_FIRST_NAME "First Name" from EH_EMPLOYEE where EH_DEPARTMENT_NO=?

2. Enter ExternalData in the DataObject field.
3. Enter ExternalData in the DataMember field.
4. Enter iif(not Page.IsPostBack,EQM.UI.Web.ExternalDataProvider.ODBC.GetListValues(“SourceName”,CurrentUser), New String(){"value"},nothing) in the DataSource field (i.e., SourceName was defined in the SmartSolve application).
5. Replace SourceName with the External Data Source Name.
6. Replace value with your condition.

EXAMPLE: iif(not Page.IsPostBack,EQM.UI.Web.ExternalDataProvider.ODBC.GetListValues("SourceName",CurrentUser,New String() {"QC"}), nothing)

7. Enter the column name to determine the value to display in the DataTextField field (this is the name of the column to be displayed in the drop down menu, such as Part name).

NOTE: If the SQL Query Statement contains an alias column name, you must enter the alias name.

8. Enter the column name to determine the value to store in the DataValueField field (this is the name of the column to be entered into a record after the user has selected the data from the drop down menu, such as Part number). If the SQL Query Statement contains an alias column name then you must enter the alias name.

NOTE: If the SQL Query Statement contains an alias column name, you must enter the alias name.