CAPL - Bug default text according to the team DoR (Definition of Ready)

01 - PERSON OF CONTACT (PERSON THAT CAN ANSWER QUESTIONS ABOUT THE PROBLEM):
@henrique.cavarsan
02 - PROBLEM (WHAT'S THE ISSUE?):

It is necessary to optimize the Elasticsearch queries in the config; they are too heavy and affecting the ES latency times.

These queries are executed by the worker-sql in task-sql, and here is the log:
https://cloudlogging.app.goo.gl/nYDeUP8r6t5FQYs58

It would be interesting not to use config-* in these queries if possible.

ES latency in the last 30 days:

03 - STEPS TO REPRODUCE (STEP (1...N), VIDEO, SCREENSHOTS, LOGS FOLDER, HEARTBEAT, ETC. – IF IS NOT POSSIBLE TO REPRODUCE EXPLAIN THE REASON):
04 - LINKS (ADD A LINK TO THE BUG OR TO THE TENANT):
https://cloudlogging.app.goo.gl/nYDeUP8r6t5FQYs58

https://cloudlogging.app.goo.gl/WEV5EAs3h7jZc3CW6
05 - EXPECTED BEHAVIOR (LIST THE EXPECTED BEHAVIORS TO CONSIDER THIS BUG AS DONE):
We need to do this for this card:

1. We are searching for all TenantApps that matches the CarolAppName and then for each record TenantApp that we found, we are searching the Tenant based on the TenantId of the TenantApp just to find which one of all TenantApps belongs to the Unified Tenant.
2. We could search the CarolApp document based on the CarolAppName, and inside the CarolApp we will have the mdmUnifiedTenantId which already point us to the Unified Tenant Id.
   // When customer tenant has unified tenants mapping
       Optional<TenantApp> tenantAppOpt =
           tenant.getMdmUnifiedTenantsMapping().keySet().stream()
               .map(
                   tenantUnifiedId -> {
                     try {
                       return getTenantAppService()
                           .getByCarolAppName(
                               new UserAccessDetails(tenantUnifiedId),
                               carolAppName,
                               EntitySpaceType.PRODUCTION,
                               true);
                     } catch (RecordNotFoundException e) {
                       String msg =
                           String.format(
                               ERROR_MSG_GIT_CONFIGURATION_CAROL_APP, carolAppName, tenantUnifiedId);
                       log.warn(msg);
                       return null;
                     }
                   })
               .filter(Objects::nonNull)
               .findFirst();
   
       if (tenantAppOpt.isPresent()) {
         return tenantAppOpt.get();
       }
   
       // When customer tenant doesn't have unified tenants mapping
       List<TenantApp> tenantApps = getTenantAppService().getAllByCarolAppName(carolAppName);
       return getTenantAppService()
           .getUnifiedTenantAppFromList(tenantApps)
           .orElseThrow(
               () -> {
                 String errorMsg =
                     MessageFormat.format(
                         ERROR_MSG_NOT_FOUND_TENANT_UNIFIED_FOR_CAROL_APP, carolAppName);
                 logger.error(errorMsg);
                 return new ApplicationException(Status.BAD_REQUEST, errorMsg);
               });

PS: A busca de CarolApp por name pode ser feita através do método CarolAppServiceImpl.findByName