Improve JournalArticleFinderImpl methods that use status as filter

• Type: Task
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: None
• Fix Version/s: 7.4.3.8 CE GA8, 7.4.13 DXP U4, Master
• Component/s: Performance, Web Content > Web Content Administration
• Labels:
  • core-infra-board-out
  • echo-board-out
  • fc_21_12
  • liferay-update-dxp-5-7413
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/6890

Right now when status is used as filter in the JournalArticleFinderImpl methods a full table scan is performed against the tempJournalArticle table because only status is used as where clause and no index can then be suggested.