Workflow query is generated with too many parameters

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.X EE, 7.0.X, Master
• Fix Version/s: 7.0.0 DXP FP31, 7.0.5 CE GA6, 7.0.X, 7.1.X, Master
• Component/s: Workflow
• Labels:
  • ee-ts
  • fw_code_review
  • fw_test_needed
  • liferay-digital-enterprise-70-sp6
  • liferay-fixpack-de-31-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.75
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/46101

Steps to reproduce

1. Use SQL Server 2012
2. Add 3000 organizations
3. Visit My Account > My Workflow Tasks > Assigned to My Roles
4. Assert exception is displayed in the logs and the page does not render successfully