Advanced Filter Issues

Just made a minor change to the Advanced Filter screen which is accessed from the report screens. It no longer adds periods to the AND and OR statements when it adds them into a filter expression. That syntax works in ZP 32 but not ZP SQL. We're finding that you also have to be more careful with OR statements in ZP SQL Advanced Filter expressions. If you create a filter expression that includes an OR statement it is usually best to enclose your entire filter expression in parenthesis. One last note, if you are converting Advanced Filters from ZP 32 to ZP SQL keep in mind that the same field name changes that apply to documents also apply to filters.