Primary Content

The Primary Content page is default category. You need to configure one or more elements in this page to get started using this web part.

Primary Content contains the following:

 

Table 1. Primary Content

Element	Description
Title	Allows you to enter a title for the web part.
Catalog	See Catalog.
Data Member	Allows you to define the name of the data table that contains the data to be displayed. This is useful when the operation that retrieves the data from external system returns multiple data tables. If the data table does not have any meaningful name, use the Data Index property.
Data Index	Allows you to define the index of the data table that contains the data to be displayed. This is useful when the operation that retrieves the data from external system returns multiple data tables and those tables do not have any meaningful name. If the data table has meaningful name, you can refer to it by using the Data Member property. If neither the Data Member or the Data Index property is specified, the first data table in the data set is used.
Primary Key Field Name	Allows you to define the field name in the returned data table that is used as the primary key. The primary key field must have a unique value for every row in the data table. The qSISelector will use the value in the primary key field to differentiate one row in the data table from another.
Display Field Name	Allows to enter the name of the field that you want to display in the selector.If you want to display information from multiple fields, use the Display Format properties. The Display Field Name property is ignored if the Display Format property is defined.
Display Format	Allows you to define the format of the items that are displayed in the selector. You can use field replacement expression (<%field name %>) to refer to a field name.
Display Fields	Allows you to define the fields that are displayed in the drop-down menu of the web part. If defined, the choices in the drop-down menu are displayed in a grid. This property is an XML string in this format: <Fields>    <Field Name="fieldName" Width="width" />    <Field Name="fieldName" Width="width" />  </Fields> The <Fields> element may contain one or more <Field> elements. • Name - The name of the field. The field name is case-sensitive. • Width - The display width of the field. The value can be in pixel (for example: 200px) or percent (for example: 30%).
Eliminate Duplicate Values	Allows you to define whether or not you want to eliminate duplicate values in the drop-down menu. This is useful in case you want to use the selector as a filter to another Web Part.

Catalog

This property defines the entity and the operations related to the entity. This property is an XML string in this format:

 

NOTE: If you are using a Salesforce system, the parameters that are available depend on the method selected. See the System Integration Developer Guide for the methods and parameters.

The Catalog section contains one or more entities. An entity identifies which system and service you have defined in the Configuration Editor. An entity contains one or more operations that can be executed on the entity, and consists of the following attributes:

 

Table 2. Catalog

Element	Description
Advanced Mode	Turn on if you want to edit Catalog in XML format. <Catalog>    <Entity Name="entityName" System="systemName" Service="serviceName" Default="true/false" SetSessionName="sessionName" ResetSessionNames="sessionName">       <Properties>          <Property Name="propertyName" Type="typeName" Value="propertyValue" />          <Property Name="propertyName" Type="typeName" Value="propertyValue" />       </Properties>       <Operation Name="operationName" Method="methodName" Default="True/False" >          <Parameter Source="sourceType" SessionName="sessionName" SourceName="sourceName" Type="parameterType" Name="parameterName" Usage="usageType" Value="value" />          <Parameter Source="sourceType" SessionName="sessionName" SourceName="sourceName" Type="parameterType" Name="parameterName" Usage="usageType" Value="value" />       </Operation>    </Entity>    <Entity>...</Entity> </Catalog>
System	Allows you to specify the system name that is defined in the System Integration configuration file. If the system name does not exist in the System Integration configuration file, you will get an error.
Service	Allows you to specify the service name that is defined in the System Integration configuration file. The service name that you specify here must belong to system that you specify in the System attribute. If the service name does not exist in the System Integration configuration file, you will get an error.
Name	Allows you to specify the name of the entity which must be unique within this Catalog. The name does not have to match with any name in your external system. However, it is recommended that you use a descriptive name for your entity. This field is mandatory.
Set Session Name	Allows you to enter name of the session variable where the edited or newly created item is stored when it is saved, or the item that is being displayed or edited is stored when it is loaded.
Reset Session Names	Allows you to reset (set to NULL) the value of the session variable whose name is specified in this attribute. Specify multiple names by separating them with commas.
Default	Allows you to define this entity as the default for the list form. If this element is not specified, the first entity that is listed in the catalog becomes the default entity. The default operation of the default entity is the operation that is used to retrieve the data when the list form is loaded for the first time in edit or display mode.

Operations

An operation contains the following properties.

 

Table 3. Operations

Element	Description
Name	Allows you to define the name of the operation. This name does not have to match with any name in your external system. This field is mandatory.
Method	There are three supported types: • TableDirect — select this type to return all the data in a table. Specify the schema and table name in the Method field below. • Stored Procedure — select this type to use a stored procedure to update or return data. Specify the schema and stored procedure in the Method field below. Once a stored procedure is selected, the Editor updates with the parameters that are defined for the stored procedure. It is recommended that you do not add or remove these parameters or change the “Name”, “Source”, or “Usage” fields. • Text — select this type to use free form PL/SQL string to query or update the database. If your SQL string requires parameters, you will need to add them manually by clicking the Add Parameter button. NOTE: This attribute is only applicable for Oracle systems.
Method	Allows you to set the real name of the operation in your external system. For example, it may refer to the name of a web service method. Or it may refer to the name of a stored procedure in your SQL Server database.
Default	Allows you to select this operation as the default for the entity. The default operation is the first operation that is called to retrieve the entity to be displayed. If this attribute is not specified, the first operation listed in the entity becomes the default operation.

Operation Parameters

You can click Edit to add parameters to your operation. You can define the following:

 

Table 4. Operation Parameters

Parameter	Description
Name	Allows you to set the parameter name that is used when calling the operation in your external system.
Source	Allows you to define the source of this parameter, which can be one of the following: • Default Value — the default value of the parameter type or default instance of the parameter type. You must specify a type and usage (the direction for the parameter). For example, if the parameter type is Boolean, the Default Value for the parameter is false; if the parameter type is String, the default value is null. If a simple class or structure is involved, an instance of the object is created and used as the parameter value. • NullValue — the value of the parameter is null. You must specify a type and usage. • FixedValue — the value of the parameter. You must specify a value, type, and usage. • HttpRequest — the value of the parameter is retrieved from the HTTP parameters in the page URL. You must specify a Source Name (the source name where the value is retrieved) and usage. As an example, say the current page URL is http://mysite.com/default.aspx?ProductType=Hardware. If the SourceName attribute is ProductType, the value of the ProductType HTTP parameter, which is Hardware, is used as the value of the parameter. • Input — you can link a field on the form to an operation parameter. You must specify a Source Name, type, and usage. You can also use this source type to retrieve the current user information as the value of the parameter. You can retrieve the following information: CurrentUserName - display name of the current user CurrentLoginName - login name of the current user CurrentUserID - ID of the current user CurreUserEmail - email address of the current user • RowFromAnotherWebPart — the value of the parameter that is retrieved from the row that is consumed from another web part. You must specify a Source Name and type. • Session — the value of the parameter that is retrieved from the row that is stored in the session. You specify Session Name (define the name of the session where the row of information is retrieved), Source Name, type, and usage. • ComplexType — the value of the parameter is an object based on the Type attribute and Member definition inside the Parameter. Array and nested complex types are supported. You must specify type and usage. • Array — the value of the parameter is an array of values. You must specify type and usage. • XML — the value of the parameter that is dynamically built when the condition is execute at runtime. You must specify type and usage. NOTE: For sources related to Salesforce, see the System Integration Developer Guide.

Properties

The Catalog section contains the following properties:

Element	Description
Name	Allows you to specify the name of the property. Refer to the documentation for the DAO Provider to your external system will tell you the name of the property that you must define.
Type	Allows you to specify type of value that is specified in the Value attribute. Example: System.String.
Value	Allows you to specify the value of the property.