select * from tpas.edt_task where status = 'ERROR' and (source_date_time at TIME ZONE source_time_zone)::DATE = current_date - integer '1'
dslContext.selectFrom(TPAS.EDT_TASK)
.where(TPAS.EDT_TASK.STATUS.eq("ERROR"))
.and(field("(source_date_time at TIME ZONE source_time_zone)::DATE", LocalDate.class)
.eq(DSL.currentLocalDate().sub(1)))
.fetch()
.forEach(record -> DBHelper.constructMap(record, columns, results));
select
tpas.edt_task.id,
tpas.edt_task.tpasns_id,
tpas.edt_task.advertiser_id,
tpas.edt_task.data_source,
tpas.edt_task.log_type,
tpas.edt_task.source_uri,
tpas.edt_task.source_date,
tpas.edt_task.source_size,
tpas.edt_task.status,
tpas.edt_task.state,
tpas.edt_task.start_time,
tpas.edt_task.end_time,
tpas.edt_task.executed_by,
tpas.edt_task.parent_id,
tpas.edt_task.part_num,
tpas.edt_task.records_invalid,
tpas.edt_task.records_read,
tpas.edt_task.submission_time,
tpas.edt_task.submitted_by,
tpas.edt_task.source_time,
tpas.edt_task.config_pk,
tpas.edt_task.source_time_zone,
tpas.edt_task.source_date_time
from tpas.edt_task
where (tpas.edt_task.status = 'ERROR' and
(source_date_time at TIME ZONE source_time_zone) :: DATE = (current_date + (-(1) || ' day') :: interval))
--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAJ7OkQ81-my0AMT5gFX4HO%3DR2myRf1Nurp%2B%3D4N6sMnBmY7Bpmg%40mail.gmail.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6Xn6bnkirdSKxK4a82e-BQGB4kCv69MySDDXAWX0fgrQ%40mail.gmail.com.