20250217 - IG 수정 가능항목에 폰트 색상 Class 넣기

SQL :

     , case

         when delivery_req is null or delivery_req = '' then ''

         when regexp_instr(delivery_req, '/[0-9]|[0-9]일|[0-9].[0-9]|평일|주말|요일|[0-9]월') > 0 then 'css-red'

         else ''

       end as delivery_req_style

     , delivery_req

Column Initialization JavaScript Function :

function(options) {

    options.defaultGridColumnOptions = {

        cellCssClassesColumn: "DELIVERY_REQ_STYLE"

    }

    return options;

}

읽기 전용 항목이면, 간단히 HTML Expression으로.

     , decode(regexp_instr(nvl(delivery_req,''), '/[0-9]|[0-9]일|[0-9].[0-9]|평일|주말|요일|[0-9]월'), 0

              , '<span>'||delivery_req||'</span>'

              , '<span class="css-red">'||delivery_req||'</span>') delivery_req_css

참고

https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-2656&cs=1UuSgWyFNcx0mxFPVL9acva6DYDiz8xoQU3igQfQX24AfPiSBv0TbsWdvNk6cKRXRJnAQd-FirfRIh0qh3XMbQA