General

Re: Understanding Rule conditions

ZhenYuan — Wed, 12 Jan 2011 02:00:50 GMT

Thanks Jimmy for your suggestion! I was all resigned to do coding already...

Using expressions to act as parenthesis works!

Re: Understanding Rule conditions

Jimmy — Tue, 11 Jan 2011 15:35:35 GMT

I couldn't give you a definitive answer without doing some experimenting myself, but generally in computing contexts, AND has a higher associativity than OR, which means that ANDs are grouped before ORs. This is true for XPath as well, so my guess is that in your example, the latter version is the way the logic would be evaluated.

The condition builder dialog in InfoPath is ambiguous when you start mixing ANDs and ORs, so I would suggest that rather than doing so and causing yourself or someone else some confusion and headaches down the road, that you either:

-Handwrite one large expression, combining the ANDs and ORs the way you want with parentheses, or...

-Arrange your condition so that you are only using either AND or OR in the dropdowns, and use handwritten expressions for the sub-conditions where necessary, e.g.:

A is blank [AND]<---dropdown

(B != '' or C != '')

This way there is no ambiguity, and no confusion.

Re: Understanding Rule conditions

ZhenYuan — Tue, 11 Jan 2011 11:39:55 GMT

And what happens if my IF condition is: A is blank and One is not blank or Two is not blank?

Will it be read as (A is blank) and (One is not blank or Two is not blank)

(A is blank and One is not blank) or (Two is not blank)

Understanding Rule conditions

ZhenYuan — Tue, 11 Jan 2011 11:31:14 GMT

Hi,

I am stumped by how rule conditions work when there are multiple fields to consider. For example if there are 3 fields, "A", "One", and "Two" and want to set a "Results" field to be = 1 if "A" is blank and ("One" or "Two" is not blank).

Do I set the condition as IF: A is blank and One is not blank or Two is not blank? What happens if I set it as IF: One is not blank or Two is not blank and A is blank?

Will my second statement be recognized as ("One" or "Two" is not blank) and ("A" is blank)? Or will the AND condition take precedence and cause my second condition to be (One is not blank) OR (Two is not blank and A is blank)?

I have 4 fields to do such filtering and this logic is driving me nuts... So how does InfoPath read its condition statements?

Bangs head on wall,

Zhen Yuan