The ACTIVE ADVANCED CONDITIONS EDITOR page appears.
Click View SQL.
The Advanced Conditions SQL dialog appears.
Modify the SQL as per your requirement.
Click Save SQL to save your changes.
Click Close to return to the ADVANCED CONDITIONS LIBRARY
page.
Select the modified advanced condition.
Click Execute.
The search results appear based on your modified SQL.
Note:
You cannot modify an advanced condition once you have added
user defined SQL in that, you can modify SQL but cannot add new items in
advanced condition.
If you want to add new items, you have to revert the SQL to
original by clicking Revert to Original.