SAP Knowledge Base Article - Public

2637802 - Query Still Available Even After Been Disabled

Symptom

When you disable a query under Organize Query, it is still available in the dropdown list.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the affected work center, e.g. Customer.
  2. Go to the affected view, e.g. Accounts.
  3. Click on Advanced Filter button.
  4. Click on Organize Queries button.
  5. Check the Disable checkbox for query XYZ (XYZ represents the name of the query).
    Disable Query.jpg

  6. Click on Apply button.
  7. Notice that the query XYZ still available in the dropdown list.

Cause

Disable query functionality works as below:

  • All the queries will be displayed in the query menu, even if the query is disabled.
  • Upon executing the disabled query, the data is not loaded directly. In its place a link is displayed 'Click here to execute query'.

Disable Query1.jpg

Resolution

If you want to remove a specific query (other than standard queries) from the query menu, follow below steps:

  1. Go to the affected work center, e.g. Customer.
  2. Go to the affected view, e.g. Accounts.
  3. Click on Advanced Filter button.
  4. Click on Organize Queries button.
  5. Check the Remove checkbox for query XYZ.
  6. Click on Apply button.

Note: Standard queries, e.g. "All", "My Accounts", "My Team's Accounts", cannot be removed from the menu. They can only be made 'invisible' as described in KBA 2866460.

See Also

Keywords

Disable; Query; Organize Queries; Advanced Filter; Not; Working; Click here to execute query; Not; Remove; Execute Query; Still Shown; , KBA , query not removed , organize queries , disable queries , disable query , default set , remove query , not working , AP-RC-UIF-FLX , Page Layout & Key User Configuration , LOD-CRM-ACC , Account , AP-RC-UIF-FLX-FRW , UI Adaptation Framework , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions