Selector

A Selector defines the data to extract from the Repository to insert into the XML document.

When you double-click on the Selector icon on the Data Pipe, the Workbench displays the Selector dialog. The Selector has two slightly different versions.

• The default version of the dialog displays the WHERE table. In general you should use the WHERE table to select your data unless the query involves complex joins that are not handled by the Join Editor or the query includes nested boolean statements.

• WHERE Table Column Descriptions

  Variable The Repository data to match. You can specify either a table column or a SQL function.

  Op The logical operator to use to select the data.

  Value The value the Repository data must match.

  bool Boolean operator used to link multiple WHERE statements together. Options include AND and OR (AND takes precedence over OR). Note that these statements cannot be nested in the WHERE table; if you need to nest boolean operations in your WHERE clause, you must use manual SQL.

  Omit if Null Specifies that the database table row should be skipped if the value of the specified database column is null.

  Make entries distinct Specifies that redundant rows in result data should be removed.

• The alternate version of the dialog allows you to enter your SQL statement manually. You must enter the complete SQL statement; you cannot enter the WHERE clause by itself.

Enter the SQL Statement in the SELECT statement field.

When entering SQL manually, use the standard SQL syntax for your RDBMS. To pass variable values derived from HTML parameters, use the syntax:
:"PSXPARAM/Name"
For example:
CONTENTSTATUS.CONTENTID=:"PSXPARAM/contentid"
If the value of the HTML parameter is character data, you must enclose the parameter statement in single quotation marks. For example, if you wanted to use a LIKE query in your SQL statement, you would use the following SQL code:
select ... where Company_Name like ':"PSXParam/CompanyName"%'