Show logs in integration log table for last 8 hours weekdays

[raman_kumar]

I have created a report in which one of my requirement is such that only last 8 hours integration logs should be filtered for weekdays in integration logs.

I have checked other ways without scripting but not found any filter for this scenario can anyone guide me if there's any filter condition/way/steps available which we can use to achieve this.

Thank you

[Tanushree Maiti]

Hi @raman_kumar 

First tell me in which table you are doing reporting. Is this requirement for Inbound or Outbound.

Did you consider to check sys_outbound_http_log  //This is for Outbound

Here you can Do filtering by Created field . ( Created relative 8 days ago)

[raman_kumar]

Hi @Tanushree

I am doing on sn_ind_tmt_orm_u_integration_logs table and this requirement is for Outbound for sending email notification.

Yes i checked u_integration_logs but here's no default filter available for last 8 hours integration logs,

Can you pls mention steps to approach further.

[jcmings · Accepted solution]

Can you do something like this:

Encoded query: 

sys_created_onRELATIVEGT@hour@ago@8^sys_created_onDATEPARTMonday@javascript:gs.datePart('dayofweek','monday','GE')^sys_created_onDATEPARTFriday@javascript:gs.datePart('dayofweek','friday','LE')

[raman_kumar]

Okay thank you @jcmings  for the solution.