I tried a complex condition (in SOA) on the Customer explorer: I wanted was to include all customers that started with "A" and had letter "l" in their name, or customers with more than 85,000 balance.
Balance > 85000 AND Cust Begins with A OR Cust Contains l
and got the wrong results. Turning it around to
Cust Contains l AND Cust Begins With A OR Balance Is greater than 85000
Got me my expected results.
But, since this isn't a given, you can do something a little uglier, but more reliable. I'm not calling it the greatest work around, but perhaps it will serve your needs and keeps you just using MAS 500 UI:
1) Add a Column and put the condition in that column, setting the column to 0 when false and 1 when true,
2) Group by that column - separating the data into those that met your criteria and those that didn't
FYI - It treats the column as if it were a SQL column, so if you know SQL syntax, you can build something like this (still using the Customer criteria example above):
So, continuing with the same example from above I did this:
1) I added a field called DBC with this calculation:
CASE WHEN ([CustID] like 'A%' AND [CustID] like '%l%') OR [Balance] > 85000 THEN 1 ELSE 0 END
I didn't see it in the Filter column list, so I
2) enabled grouping and selected this column into the grouping.
Now I can at least look at those that met the criteria separate from those that didn't meet it.
Hope that helps a little.
