Modify the SQL of an Advanced Condition

1. Navigate to the ADVANCED CONDITIONS LIBRARY page.
2. Select the advanced condition.
3. Click Modify.

   The ACTIVE ADVANCED CONDITIONS EDITOR page appears.

4. Click View SQL.

   The Advanced Conditions SQL dialog appears.

5. Modify the SQL as per your requirement.
6. Click Save SQL to save your changes.
7. Click Close to return to the ADVANCED CONDITIONS LIBRARY page.
8. Select the modified advanced condition.
9. 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.