a!queryEntity(
   entity:  cons!V_BOM_REQUEST_CDT,
   query: a!query(
     aggregation: a!queryAggregation(
       aggregationColumns: {
         a!queryAggregationColumn(
           field: "running_status_code",
           alias: "stato",
           isGrouping: true
         ),
        a!queryAggregationColumn(
           field: "running_status_code",
           alias: "totale",
           aggregationFunction: "COUNT"
         )
       }
     ),
     logicalexpression: a!queryLogicalExpression(
       operator: "AND",
       filters: {
         a!queryFilter(
           field: "running_status_code",
           operator: "not in",
           value: {cons!STATUS_PAUSE, cons!STATUS_DELETE, cons!STATUS_LOCK}
         ),
         a!queryFilter(
           field: "request_process_insert_time",
           operator: "between",
           value: {toDatetime(ri!startDate), toDatetime(ri!endDate)},
           applyWhen: and(not(isnull(ri!startDate)), not(isnull(ri!endDate)))
         ),
         a!queryFilter(
           field: "user_id",
           operator: "=",
           value: ri!user,
           applyWhen: not(isnull(ri!user))
         ),
         a!queryFilter(
           field: "psp_new",
           operator: "=",
           value: ri!psp_new,
           applyWhen: not(isnull(ri!psp_new))
         ),
         a!queryFilter(
           field: "psp_old",
           operator: "=",
           value: ri!psp_old,
           applyWhen: not(isnull(ri!psp_old))
         ),
         a!queryFilter(
           field: "istituto",
           operator: "=",
           value: ri!istituto,
           applyWhen: not(isnull(ri!istituto))
         ),
         a!queryFilter(
           field: "banca",
           operator: "=",
           value: ri!banca,
           applyWhen: not(isnull(ri!banca))
         ),
         a!queryFilter(
           field: "cod_filiale",
           operator: "=",
           value: ri!cod_filiale,
           applyWhen: not(isnull(ri!cod_filiale))
         ),
         a!queryFilter(
           field: "tipo_operazione",
           operator: "=",
           value: ri!tipo_oper,
           applyWhen: not(isnull(ri!tipo_oper))
         ),
       },
       ignoreFiltersWithEmptyValues: true
     ),
     pagingInfo: a!pagingInfo(
       startIndex: 1,
       batchSize: 10,
       sort: {
         a!sortInfo(
           field:"totale"
         )
       }
     )
   ),
   fetchTotalCount: false
)