Assure DQ

 View Only
Expand all | Collapse all

Perceive Ad-hoc View - how to filter based on day of week condition

  • 1.  Perceive Ad-hoc View - how to filter based on day of week condition

    Posted 12-13-2021 04:31

    Good day Community,

    I find myself with a business requirement where I need to set the adhoc view filter based on a condition.

    This report is setup with a report event to send out an email to recipient list, so I cannot filter it manually before running the report.

    The adhoc view is set to filter data with effective = day - 1. this works the majority of the time however on a Monday it needs to be day - 2, because of Sunday not having data and Saterday's data only coming through on the Monday.

    If I could use something similar to Assure's @if_else function with @day_of_week and @now functions within the filter's between fields, I could accomplish this.

    But I don't think that is possible. See attachments for more info.

    How would I accomplish this in Perceive?

     

    Attached files

    PerceiveAdhocViewFilter.png
    SimularToAssure_val_if_else.png

     



  • 2.  RE: Perceive Ad-hoc View - how to filter based on day of week condition

    Employee
    Posted 01-14-2022 10:11

    Hi Rocco,

    Week day filtering is not something provided by the Jasper-Report filter. One thing that may be done to achieve this behavior is through adding control fields within Assure ( populating within Assure for the week days, 1-7 ). Once Perceive receives that data, it can in turn apply a filter based on the field.

    Matthew Kennedy