REGLAS AVANZADAS EN OPENWELLS

REGLAS AVANZADAS EN OPENWELLS

Los siguientes macros son soportados

Aquí el código SQL

SELECT CASE WHEN   (CDA.DATE_STATUS-DMR.DATE_REPORT)>=-0.75 AND

                   (CDA.DATE_STATUS-DMR.DATE_REPORT)<=0.25  THEN 1

                ELSE  0

            END

FROM DM_REPORT_JOURNAL DMR,  CD_ASSEMBLY_STATUS CDA, CD_ASSEMBLY CA

WHERE

DMR.report_journal_id ='[report_journal_id]' and DMR.well_id='[well_id]' and DMR.wellbore_id='[wellbore_id]'

AND CA.well_id=DMR.WELL_ID and ca.wellbore_id=DMR.WELLBORE_ID AND CA.REPORT_JOURNAL_ID=DMR.REPORT_JOURNAL_ID

AND CDA.ASSEMBLY_ID=CA.ASSEMBLY_ID and CDA.well_id=CA.WELL_ID and cda.wellbore_id=CA.WELLBORE_ID