Siebel Sales 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
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">
|