{"id":16049,"date":"2023-11-10T14:15:35","date_gmt":"2023-11-10T20:15:35","guid":{"rendered":"https:\/\/sada.services\/?p=16049"},"modified":"2023-11-10T14:15:35","modified_gmt":"2023-11-10T20:15:35","slug":"sigesa-select-update-para-determinar-rangos-incorrectos","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=16049","title":{"rendered":"SIGESA: SELECT \/ UPDATE para determinar Rangos Incorrectos"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>Estas consulta determinan cuales meta poa evaluaci\u00f3n tienen datos incorrrectos en el rango <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>--*********************************************************************************************\n--CAT\u00c1LOGO: CONSULTA DE DATOS ERRONEOS\n--*********************************************************************************************\nSELECT \n    MPE.ID_META_POA_EVALUACION,\n    MPE.EJECUCION,\n    MPE.NOMBRE_RANGO,\n    COALESCE(RC.NOMBRE, 'Sin coincidencia') AS VALOR_CORRECTO\nFROM\n    META_POA_EVALUACION MPE\n    INNER JOIN META_POA_DATO_CAT MPDC ON MPDC.META_POA = MPE.META_POA AND MPDC.ETAPA_PLAN = :etapaPlan\n    INNER JOIN DATO_FORMULA DF ON DF.ID_DATO_FORMULA = MPDC.DATO_FORMULA\n    INNER JOIN FORMULA_CALCULO FC ON FC.ID_FORMULA_CALCULO = DF.FORMULA_CALCULO\n    LEFT JOIN RANGO_CONSIDERACION RC \n        ON RC.FORMULA_CALCULO = FC.ID_FORMULA_CALCULO \n        AND ROUND(MPE.EJECUCION,2) BETWEEN ROUND(RC.MINIMO,2) AND ROUND(RC.MAXIMO,2)\nwhere \nMPE.ETAPA_PLAN = :etapaPlan\nAND MPE.EJECUCION IS NOT NULL\nAND (MPE.NOMBRE_RANGO &lt;> COALESCE(RC.NOMBRE, 'Sin coincidencia') OR MPE.NOMBRE_RANGO IS NULL)\nORDER BY MPE.ID_META_POA_EVALUACION;\n\n\n\n--*********************************************************************************************\n--CAT\u00c1LOGO: CONSULTA DE UPDATE\u2019S\n--*********************************************************************************************\nSELECT \n    'UPDATE META_POA_EVALUACION SET NOMBRE_RANGO = ' || \n    CASE \n        WHEN MPE.NOMBRE_RANGO &lt;> COALESCE(RC.NOMBRE, 'Sin coincidencia') OR MPE.NOMBRE_RANGO IS NULL THEN\n            COALESCE('''' || RC.NOMBRE || '''', 'NULL')\n        ELSE \n            '''' || MPE.NOMBRE_RANGO || ''''\n    END || ' WHERE ID_META_POA_EVALUACION = ' || MPE.ID_META_POA_EVALUACION || ';' AS UPDATE_STATEMENT\nFROM\n    META_POA_EVALUACION MPE\n    INNER JOIN META_POA_DATO_CAT MPDC ON MPDC.META_POA = MPE.META_POA AND MPDC.ETAPA_PLAN = :etapaPlan\n    INNER JOIN DATO_FORMULA DF ON DF.ID_DATO_FORMULA = MPDC.DATO_FORMULA\n    INNER JOIN FORMULA_CALCULO FC ON FC.ID_FORMULA_CALCULO = DF.FORMULA_CALCULO\n    LEFT JOIN RANGO_CONSIDERACION RC \n        ON RC.FORMULA_CALCULO = FC.ID_FORMULA_CALCULO \n        AND ROUND(MPE.EJECUCION,2) BETWEEN ROUND(RC.MINIMO,2) AND ROUND(RC.MAXIMO,2)\nWHERE \n    MPE.ETAPA_PLAN = :etapaPlan\n    AND MPE.EJECUCION IS NOT NULL\n    AND (MPE.NOMBRE_RANGO &lt;> COALESCE(RC.NOMBRE, 'Sin coincidencia') OR MPE.NOMBRE_RANGO IS NULL)\nORDER BY MPE.ID_META_POA_EVALUACION;\n\n\n--*********************************************************************************************\n--PERSONALIZADOS: CONSULTA DE DATOS ERRONEOS\n--*********************************************************************************************\nSELECT \n    MPE.ID_META_POA_EVALUACION,\n    MPE.EJECUCION,\n    MPE.NOMBRE_RANGO,\n    COALESCE(RC.NOMBRE, 'Sin coincidencia') AS VALOR_CORRECTO\nFROM\n    META_POA_EVALUACION MPE\n    INNER JOIN META_POA_DATO_PER MPDP ON MPDP.META_POA = MPE.META_POA AND MPDP.ETAPA_PLAN = :etapaPlan\n    INNER JOIN DATO_FORMULA DF ON DF.ID_DATO_FORMULA = MPDP.DATO_FORMULA\n    INNER JOIN FORMULA_CALCULO FC ON FC.ID_FORMULA_CALCULO = DF.FORMULA_CALCULO\n    LEFT JOIN RANGO_CONSIDERACION RC \n        ON RC.FORMULA_CALCULO = FC.ID_FORMULA_CALCULO \n        AND ROUND(MPE.EJECUCION,2) BETWEEN ROUND(RC.MINIMO,2) AND ROUND(RC.MAXIMO,2)\nwhere \nMPE.ETAPA_PLAN = :etapaPlan\nAND MPE.EJECUCION IS NOT NULL\nAND (MPE.NOMBRE_RANGO &lt;> COALESCE(RC.NOMBRE, 'Sin coincidencia') OR MPE.NOMBRE_RANGO IS NULL)\nORDER BY MPE.ID_META_POA_EVALUACION;\n\n\n\n--*********************************************************************************************\n--PERSONALIZADOS: CONSULTA DE UPDATE\u2019S\n--*********************************************************************************************\nSELECT \n    'UPDATE META_POA_EVALUACION SET NOMBRE_RANGO = ' || \n    CASE \n        WHEN MPE.NOMBRE_RANGO &lt;> COALESCE(RC.NOMBRE, 'Sin coincidencia') OR MPE.NOMBRE_RANGO IS NULL THEN\n            COALESCE('''' || RC.NOMBRE || '''', 'NULL')\n        ELSE \n            '''' || MPE.NOMBRE_RANGO || ''''\n    END || ' WHERE ID_META_POA_EVALUACION = ' || MPE.ID_META_POA_EVALUACION || ';' AS UPDATE_STATEMENT\nFROM\n    META_POA_EVALUACION MPE\n    INNER JOIN META_POA_DATO_PER MPDP ON MPDP.META_POA = MPE.META_POA AND MPDP.ETAPA_PLAN = :etapaPlan\n    INNER JOIN DATO_FORMULA DF ON DF.ID_DATO_FORMULA = MPDP.DATO_FORMULA\n    INNER JOIN FORMULA_CALCULO FC ON FC.ID_FORMULA_CALCULO = DF.FORMULA_CALCULO\n    LEFT JOIN RANGO_CONSIDERACION RC \n        ON RC.FORMULA_CALCULO = FC.ID_FORMULA_CALCULO \n        AND ROUND(MPE.EJECUCION,2) BETWEEN ROUND(RC.MINIMO,2) AND ROUND(RC.MAXIMO,2)\nWHERE \n    MPE.ETAPA_PLAN = :etapaPlan\n    AND MPE.EJECUCION IS NOT NULL\n    AND (MPE.NOMBRE_RANGO &lt;> COALESCE(RC.NOMBRE, 'Sin coincidencia') OR MPE.NOMBRE_RANGO IS NULL)\nORDER BY MPE.ID_META_POA_EVALUACION;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[480,444,590],"class_list":["post-16049","post","type-post","status-publish","format-standard","hentry","category-sigesa","tag-select","tag-sigesa","tag-update"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/16049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16049"}],"version-history":[{"count":1,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/16049\/revisions"}],"predecessor-version":[{"id":16050,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/16049\/revisions\/16050"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}