I have a qvw where I allow users to select a set of dates in the current year from a couple of calendar objects. These are then placed into variables.
What I would like to do is select records based on these values. I know I can do this via set analysis, but was wondering if using a Select in Field trigger would be a better option for performance? (the table that holds the records has nearly 4 million rows).
Also, when selecting a date range I would like the records from the previous year that has the same dates to also be selected. I.e. user selects 01 Oct 2016 to 09 Oct 2016 and I would like those records, as well as 01 Oct 2015-09 Oct 2015 to be selected.
