select
        umfalertco0_.id as id1_0_,
        umfalertco0_.action as action2_0_,
        umfalertco0_.creation_date as creation3_0_,
        umfalertco0_.creation_user as creation4_0_,
        umfalertco0_.delay as delay5_0_,
        umfalertco0_.description as descript6_0_,
        umfalertco0_.last_updated_date as last_upd7_0_,
        umfalertco0_.last_updated_user as last_upd8_0_,
        umfalertco0_.optional_email as optional9_0_,
        umfalertco0_.product as product10_0_,
        umfalertco0_.trigger_event as trigger11_0_,
        umfalertco0_.trigger_event_type as trigger12_0_,
        umfalertco0_.valid_from as valid_f13_0_,
        umfalertco0_.valid_to as valid_t14_0_
    from
        UMF_ALERT_CONFIGURATION umfalertco0_
    where
        umfalertco0_.trigger_event=?
        and umfalertco0_.valid_from<=?
        and umfalertco0_.valid_to>=?