Siebel Consumer Goods Handheld Guide > Print Tagging Language > Data Manipulation and Logic Tags >

sql (WHERE) Tag

The sql (WHERE) tag is placed as a parameter, and so can be a value stored in a string variable.

Usage

Use the sql (WHERE) tag, for example, as follows:

sql="\"Status\"='Defective'" and \"Quantity\">500"

in the Applet, GetTotal, GetField, GetDirect, and GetCount tags.

Syntax

To use this tag, use the following syntax:

SQL="\"Status\"='Defective'"

Example 1

<TAG:Applet name="CS HH Product Bucket List Applet" sql="\"Status\"='Defective'" maxlines="2" startat="10" recorddivider="FALSE" wrap="TRUE" grid="TRUE" offset="0" width="75" linewidth="0.4">

<TAG:SETVARIABLE variable="var_equal" name="=">

<TAG:SETVARIABLE variable="var_fieldname" name="\"Status\"">

<TAG:SETVARIABLE variable="var_criteria" name="'Good'">

<TAG:Concat variable="var_equal" prepend="<variable>var_fieldname"> append="<variable>var_criteria">

<TAG:SETY y="0">

<TAG:Applet name="CS HH Product Bucket List Applet" sql="<variable>var_equal" maxlines="2" startat="10" recorddivider="FALSE" wrap="TRUE" grid="TRUE" offset="80" width="75">

Example 2

<TAG:Getfield appletname="CS HH Orders Print Applet" fieldname="Account" variable= "var_name">

<TAG:SETVARIABLE variable="var_where" name="='">

<TAG:SETVARIABLE variable="var_fieldname" name="\"Name\"">

<TAG:CONCAT variable="var_where" prepend="<variable>var_fieldname" append= "<variable>var10">

<TAG:CONCAT variable="var_where" append="'">

<TAG:GETDIRECT sql="<variable>var_equal" businessobject="Account" businesscomponent= "Account" fieldname="Name" variable="var15">

<TAG:CELL name="<variable>var15" left="10" top="80" right="70" bottom="100" box="TRUE" linewidth="0.4" align="RIGHT">