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.

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).
    CD1.PNG
    "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 
  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 section, 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'.

CD2.PNG

Resolution

If you want to remove specific query (other than standard queries), 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. They can only be made invisible.

See Also

For more information, please check the video How to Disable and Delete a Custom Query - SAP Cloud for Customer.

Keywords

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

Product

SAP Cloud for Customer add-ins all versions