Search results limits to only 50 results with Elasticsearch

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.X, 7.1.X, Master
• Fix Version/s: 7.1.10 DXP FP17, 7.1.10.4 SP4, 7.1.X, 7.2.0 GA1
• Component/s: Search Infrastructure, Search Infrastructure > Elasticsearch Connector
• Labels:
  • backend_test
  • ee-ts
  • liferay-dxp-71-sp4
  • liferay-fixpack-dxp-17-7110
  • search-line-of-work-assigned
• Branch Version/s:
  7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Sprint: Search | S02 Sprint 16, Search | S02 Sprint 17, Search | S02 Sprint 18, Search | S02 Sprint 19
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/73255

Solution/QA Notes
"Title Field Query Builder" has been added to the Search System Settings (com.liferay.portal.search.configuration.TitleFieldQueryBuilderConfiguration) as part of the changes to control this behavior. It has two properties:

• exactMatchBoost : Set the boost value to be applied when search terms match a title as an exact phrase. Defaults to 2.0.
• maxExpansions : Set the number of unique titles that can be matched when search terms match a title as a phrase prefix. Defaults to 50.

You need to increase the value for "maxExpansions" depending on your needs and to pass testing the scenario described below.

---

Issue
Search for entities is limited to 50 results. The reproduction steps use Organizations, though it's a generic problem.

Steps to reproduce

1. Set in your portal-ext. This property is to set the maximum number of organizations, roles, and user groups to display for each user in the user's administration search container:

   users.admin.organization.column.limit=100
   

2. Log in and go to CP > Server Administration > Scripts
3. Run the following script that adds 65 organizations

   import com.liferay.portal.kernel.service.OrganizationLocalServiceUtil;
   import com.liferay.portal.kernel.util.PortalUtil;
   long userId = PortalUtil.getUserId(actionRequest);
   
   for (int i=0; i<65; i++) {
       OrganizationLocalServiceUtil.addOrganization(userId, 0, "liferay_2000_" + i, false);
   }
   

4. Go to CP > Users and organizations > Organizations
5. Search for "liferay"

Actual results
Results only show 50 of the 65

Expected results
Results show all organizations

Reproduced in

7.0.x (ed7b27ae6d8157987719b1b94c2f6748a15c9e28)
7.1.x (ee3cc2d128e09e039854f643acc4d3963069dfc0)
master (48bd8550621fbf1dce9568571ba0c4489adde249)

Note
Same behavior in "Liferay DXP > Members > Site Membership > Organizations > Add" screen

Increasing the value for the following property does not help either

    #
    # Set the maximum number of organizations, roles, and user groups to display
    # for each user in the user's administration search container.
    #
    users.admin.organization.column.limit=50
    users.admin.role.column.limit=50
    users.admin.user.group.column.limit=50