src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_Hours_data.xsql
changeset 1605 8a0fe0193bef
parent 423 ecf368072c48
child 6701 690d2af86089
equal deleted inserted replaced
1604:a1c518e6ed93 1605:8a0fe0193bef
    30       <![CDATA[
    30       <![CDATA[
    31         select hour
    31         select hour
    32         from (
    32         from (
    33         select TO_CHAR(MEASUREHOUR, 'HH24:MI') as hour
    33         select TO_CHAR(MEASUREHOUR, 'HH24:MI') as hour
    34                 from MA_MEASURE_TIME
    34                 from MA_MEASURE_TIME
    35                 where MA_Measure_Group_ID = TO_NUMBER(?)
    35                 where MA_Measure_Group_ID = ?
    36             union all
    36             union all
    37             select null as hour
    37             select null as hour
    38             from ad_integer
    38             from ad_integer
    39             where value <= (select 10-count(*) from MA_Measure_time
    39             where value <= (select 10-count(*) from MA_Measure_time
    40                    where ma_measure_group_ID = TO_NUMBER(?))
    40                    where ma_measure_group_id=?)
    41             ORDER BY hour) A
    41             ORDER BY hour) A
    42       ]]>
    42       ]]>
    43       </Sql>
    43       </Sql>
    44       <Parameter name="maMeasureGroupId"/>
    44       <Parameter name="maMeasureGroupId"/>
    45       <Parameter name="maMeasureGroupId"/>
    45       <Parameter name="maMeasureGroupId"/>