Steps to reproduce

1. Start Camunda (version 7.13.0)
2. Open process definition history view in Cockpit
3. Filter process instances by variable

Expected behavior
List of process instances is shown

Observed behavior

• Process engine persistence exception is thrown:

  Error querying database.  Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Mehrdeutiger Feldname "PROC_DEF_ID_"
  Ambiguous column name "PROC_DEF_ID_"; SQL statement:
  select count(distinct RES.ID_ )   
      from
        ACT_HI_PROCINST RES
          LEFT JOIN ACT_HI_VARINST VI0
          ON RES.PROC_INST_ID_ = VI0.PROC_INST_ID_
         WHERE PROC_DEF_ID_ = ?
            and (VI0.ID_ IS NOT NULL
            AND  
               VI0.NAME_= ?
   
                and
                (
                  (  VI0.VAR_TYPE_ = ?
                      and VI0.TEXT_
      =
                      ? )              )          ) [90059-200]
  The error may exist in org/camunda/bpm/cockpit/impl/plugin/history/historicProcessInstance.xml
  The error may involve cockpit.history.selectHistoricProcessInstancesCount
  

Hint

• Column PROC_DEF_ID_ is present in both tables ACT_HI_PROCINST and ACT_HI_VARINST.
• The prefix pointing to the correct table is missing in the SQL query, see https://github.com/camunda/camunda-bpm-platform-ee/blob/7.13.0/webapps/camunda-webapp/plugins/src/main/resources/org/camunda/bpm/cockpit/impl/plugin/history/historicProcessInstance.xml#L98-L100