Query Folders Showing Total Folder Items Which are Less then the Actual Items Pulled Back from the Query (Doc ID 1540241.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.6.0 version, Content Server

When attempting to view a query folder which has a query pulling back more then 200 items, At the bottom of the page there is a message that reads: "200 of 200 displayed" there is a "Load More Files".
This message is wrong as they query is pulling back more then 200 items in this queryfolder.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

On WebCenterContent 11.1.1.6.0 + MLR 11 with FrameworkFolders enabled, using database metadata search engine and having the following entry set in the config.cfg: DisableTotalItemsSearchQuery=true:


Step 1: Login as any user who can create an folder on the enterprise side
Step 2: Create a query folder with the name of TestQueryFolder that uses a query that returns more then 200 content items
Step 3: Save the Folder
Step 4: Access this folder from WEB UI

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete UAT testing

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms