The widget crashes when changing the filter with "downloads" in DM management toolbar

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.4.3.5 CE GA5, 7.4.13 DXP U1, Master
• Component/s: Documents & Media
• Labels:
  • 7.4-known-issues
  • INACTIVE
  • liferay-ga1-dxp-7413
  • liferay-ga4-ce-743
• Story Points: 1
• Fix Priority: 4
• Sprint: LIMA | QA Sprint 16
• Git Pull Request: https://github.com/liferay-core-infra/liferay-portal/pull/19

Steps to reproduce:

1. Add some documents in DM to enable the Filter and Order
2. Attempt to change the filter (In this case, Select "Recent" > "Downloads")

Expected result:
The widget displays as normal.

Actual result:
The widget crashes.

2021-07-28 08:06:20.944 ERROR [http-nio-8080-exec-8][render_portlet_jsp:131] null
java.sql.SQLSyntaxErrorException: Unknown column 'readCount' in 'order clause'
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql.jar:8.0.21]
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql.jar:8.0.21]
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql.jar:8.0.21]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql.jar:8.0.21]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql.jar:8.0.21]
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[hikaricp.jar:?]
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.Loader.doQuery(Loader.java:802) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.Loader.doList(Loader.java:2542) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.Loader.list(Loader.java:2271) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) ~[hibernate-core.jar:3.6.10.Final]
        at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157) ~[hibernate-core.jar:3.6.10.Final]
        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:176) ~[portal-impl.jar:?]
        at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.list(SQLQueryImpl.java:168) ~[portal-impl.jar:?]
        at com.liferay.portal.kernel.dao.orm.QueryUtil.list(QueryUtil.java:84) ~[portal-kernel.jar:?]

Note: This only occurs when changing the filter with "Downloads".