Using Reports → Report Search Criteria → Using Advanced SQL Conditions in SBM Reports → About SBM–Processed SQL → Examples of Using LIKE and NOT LIKE Operators in SBM–Processed SQL
Suppose that the Functional Area fields have possible values of Accounting, Support Operations, Development and Internal Systems:
To find all items related to Accounting:
"Functional Area" LIKE Accounting or "Functional Area" = Accounting
To find all items that are related to any other functional area besides Accounting:
"Functional Area" NOT LIKE Accounting or "Functional Area" <> Accounting
Copyright © 2001–2016 Serena Software, Inc. All rights reserved.