RequiredDataSet Class

Represents a required data set in a survey template. The required data set is populated before the main data source query but it can be executed in another database. It has the same parameters as the main query. The result is stored in a temporary table which can be used in the main query.

Inheritance Hierarchy

SystemObject
Omada.OE.Solution.OIM.AppLogic.SurveyFeatureRequiredDataSet

Namespace: Omada.OE.Solution.OIM.AppLogic.SurveyFeature
Assembly: Omada.OE.Solution.OIM.AppLogic (in Omada.OE.Solution.OIM.AppLogic.dll) Version: 15.0.0.0

Syntax

Copy

public class RequiredDataSet

The RequiredDataSet type exposes the following members.

Constructors

	Name	Description
	RequiredDataSet

Top

Properties

	Name	Description
	Connection	The name of a Data Connection to the SQL database in which the required data must be executed. If "." is specified as connection, the connection to the enterprise server database is used.
	DataType	Either "guid" or "integer" or "string" or "datatime". The temp table "value" column will be created with that data type
	Sql	A SQL statement which must return 1 column with the data type specified in the "dataType" attribute. The paramters provided to the main query is also available for this query.
	TableName	The name of the temporary table(without # prefix) that will be created. The table always contains a single column named "value" and the data type will be the one specified in dataType

Top

Extension Methods

	Name	Description
	ToBool	Converts object to boolean. (Defined by ObjectExtensions.)
	ToDateTime	Converts object to DateTime. (Defined by ObjectExtensions.)
	ToInt	Converts object to integer. (Defined by ObjectExtensions.)

Top

Reference

Omada.OE.Solution.OIM.AppLogic.SurveyFeature Namespace