on 06-23-2009 7:30 PM
Hello all. I have two (2) opportunities with the options/text attributes. I am using the following in a local variable and assigning to the options:
<?xml version="1.0" encoding="UTF-8"?><OPTIONS>
<item>
<TEXT>AUFPL EQ '#Transaction.RoutingNumber#'</TEXT>
</item>
<item>
<TEXT> AND VORNR EQ '2010'</TEXT>
</item>
</OPTIONS>
Opportunity 1 - '#Transaction.RoutingNumber#'
Only works if I hard code a value for the routing number. If I do not use the local variable assignment in the options - assign it directly to the options/item/text as '#Transaction.RoutingNumber#', it works.
Opportunity 2 - grouping
I really want this to work as follows:
<?xml version="1.0" encoding="UTF-8"?><OPTIONS>
<item>
<TEXT>AUFPL EQ '#Transaction.RoutingNumber#'</TEXT>
</item>
<item>
<TEXT> AND (VORNR EQ '2010' OR VORNR EQ '2010')</TEXT>
</item>
</OPTIONS>
It does not like to parenthesis.
Try putting a space around the '(' and ')' e.g
AND ( VORNR EQ '2010' OR VORNR EQ '2010' )
vs
AND (VORNR EQ '2010' OR VORNR EQ '2010')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No luck.
It works fine as :
<?xml version="1.0" encoding="UTF-8"?><OPTIONS>
<item>
<TEXT>AUFPL EQ '405893'</TEXT>
</item>
<item>
<TEXT> AND ( VORNR EQ '2010' OR VORNR EQ '1030'</TEXT>
</item>
<item>
<TEXT> OR VORNR EQ '1040' OR VORNR EQ '1050'</TEXT>
</item>
<item>
<TEXT> OR VORNR EQ '1060' )</TEXT>
</item>
</OPTIONS>
The 405893 routing number needs to be stored in a variable. I have tried both transaction variables and local variables. Someting with the syntax.
No luck.
It works fine as :
<?xml version="1.0" encoding="UTF-8"?><OPTIONS>
<item>
<TEXT>AUFPL EQ '405893'</TEXT>
</item>
<item>
<TEXT> AND ( VORNR EQ '2010' OR VORNR EQ '1030'</TEXT>
</item>
<item>
<TEXT> OR VORNR EQ '1040' OR VORNR EQ '1050'</TEXT>
</item>
<item>
<TEXT> OR VORNR EQ '1060' )</TEXT>
</item>
</OPTIONS>
The 405893 routing number needs to be stored in a variable. I have tried both transaction variables and local variables. Someting with the syntax.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.