Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix B Understanding the Data Access Parameter Syntax : Data Key Value Syntax

Data Key Value Syntax
The data key value provides table access predicates in a syntax very similar to the syntax used for rules, but without the table specification, the WHERE, or any ordering.
The following example specifies two dynamic substitutions, {ARG1} (a numeric value) and '{TABLEA}.{FIELDA}' (a string value). If the value to be substituted is a string value, the expression must be enclosed in single quotation marks.
Example
FIELD1 = 'A Value' AND FIELD2 > {ARG1} OR FIELD3 = '{TABLEA}.{FIELDA}'
Syntax in BNF Notation
<key predicate> ::=
   <where not expression> {<logical operator>
   <where not expression>}
<where not expression> ::=
   [<not>] <where expression>
<where expression> ::=
   <where relation>
   (<where predicate>)
<where relation> ::=
   <field reference> <relational operator>
   <where expression>
<where expression> ::=
   [<unary operator>] <where expression term>
   {<add operator> <where expression term>}
<where expression term> ::=
   <where expression factor> {<multiplication operator>
   <where expression factor>}
<where expression factor> ::=
   <where expression primary> [<exponent operator>
   <where expression primary>]
<where expression primary> ::=
   <passed argument name>
   <table reference>
   <data value>
<passed argument name> ::=
   <{argument name}>
<table reference> ::=
   <{tablename}.{fieldname}>
<data value> ::=
   <Numeric Value>
   <Quoted String>
<Quoted String> ::=
   <'string'>
 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved