Bookshelf Home | Contents | Index | PDF |
Siebel Pharma Handheld Guide > Print Tagging Language > Data Manipulation and Logic Tags > sql (WHERE) TagThe sql (WHERE) tag is placed as a parameter, and so can be a value stored in a string variable. UsageUse the sql (WHERE) tag, for example, as follows:
in the Applet, GetTotal, GetField, GetDirect, and GetCount tags. SyntaxExample 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: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"> |
Siebel Pharma Handheld Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |