How to add option to date condition in search criteria?

[sam_yan]

Hello expert,

There's a dropdown list for created in search criteria page. Is it possible to add my customizing option?

Thank you!

[Harsh Vardhan]

i dont think so you can made some modification because we can't access those class. if you inspect on the drop down you can see it has designed in one class. and every option has used some java-script function in value.

<select class="filerTableSelect select2 form-control" title="" aria-label="Choose Value" id="GwtGFD_215ff021766021f29021dac021201021_select_GwtGFD_215ff021766021f29021dac021201021" data-original-title="Choose Input" style="vertical-align: top; margin-right: 3px;"><option value="Today@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()">Today</option><option value="Yesterday@javascript:gs.beginningOfYesterday()@javascript:gs.endOfYesterday()">Yesterday</option><option value="Tomorrow@javascript:gs.beginningOfTomorrow()@javascript:gs.endOfTomorrow()">Tomorrow</option><option value="This week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()">This week</option><option value="Last week@javascript:gs.beginningOfLastWeek()@javascript:gs.endOfLastWeek()">Last week</option><option value="Next week@javascript:gs.beginningOfNextWeek()@javascript:gs.endOfNextWeek()">Next week</option><option value="This month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()">This month</option><option value="Last month@javascript:gs.beginningOfLastMonth()@javascript:gs.endOfLastMonth()">Last month</option><option value="Next month@javascript:gs.beginningOfNextMonth()@javascript:gs.endOfNextMonth()">Next month</option><option value="Last 3 months@javascript:gs.beginningOfLast3Months()@javascript:gs.endOfLast3Months()">Last 3 months</option><option value="Last 6 months@javascript:gs.beginningOfLast6Months()@javascript:gs.endOfLast6Months()">Last 6 months</option><option value="Last 9 months@javascript:gs.beginningOfLast9Months()@javascript:gs.endOfLast9Months()">Last 9 months</option><option value="Last 12 months@javascript:gs.beginningOfLast12Months()@javascript:gs.endOfLast12Months()">Last 12 months</option><option value="This quarter@javascript:gs.beginningOfThisQuarter()@javascript:gs.endOfThisQuarter()">This quarter</option><option value="Last quarter@javascript:gs.beginningOfLastQuarter()@javascript:gs.endOfLastQuarter()">Last quarter</option><option value="Last 2 quarters@javascript:gs.beginningOfLast2Quarters()@javascript:gs.endOfLast2Quarters()">Last 2 quarters</option><option value="Next quarter@javascript:gs.beginningOfNextQuarter()@javascript:gs.endOfNextQuarter()">Next quarter</option><option value="Next 2 quarters@javascript:gs.beginningOfNext2Quarters()@javascript:gs.endOfNext2Quarters()">Next 2 quarters</option><option value="This year@javascript:gs.beginningOfThisYear()@javascript:gs.endOfThisYear()">This year</option><option value="Next year@javascript:gs.beginningOfNextYear()@javascript:gs.endOfNextYear()">Next year</option><option value="Last year@javascript:gs.beginningOfLastYear()@javascript:gs.endOfLastYear()">Last year</option><option value="Last 2 years@javascript:gs.beginningOfLast2Years()@javascript:gs.endOfLast2Years()">Last 2 years</option><option value="Last 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()">Last 7 days</option><option value="Last 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()">Last 30 days</option><option value="Last 60 days@javascript:gs.beginningOfLast60Days()@javascript:gs.endOfLast60Days()">Last 60 days</option><option value="Last 90 days@javascript:gs.beginningOfLast90Days()@javascript:gs.endOfLast90Days()">Last 90 days</option><option value="Last 120 days@javascript:gs.beginningOfLast120Days()@javascript:gs.endOfLast120Days()">Last 120 days</option><option value="Current hour@javascript:gs.beginningOfCurrentHour()@javascript:gs.endOfCurrentHour()">Current hour</option><option value="Last hour@javascript:gs.beginningOfLastHour()@javascript:gs.endOfLastHour()">Last hour</option><option value="Last 2 hours@javascript:gs.beginningOfLast2Hours()@javascript:gs.endOfLast2Hours()">Last 2 hours</option><option value="Current minute@javascript:gs.beginningOfCurrentMinute()@javascript:gs.endOfCurrentMinute()">Current minute</option><option value="Last minute@javascript:gs.beginningOfLastMinute()@javascript:gs.endOfLastMinute()">Last minute</option><option value="Last 15 minutes@javascript:gs.beginningOfLast15Minutes()@javascript:gs.endOfLast15Minutes()">Last 15 minutes</option><option value="Last 30 minutes@javascript:gs.beginningOfLast30Minutes()@javascript:gs.endOfLast30Minutes()">Last 30 minutes</option><option value="Last 45 minutes@javascript:gs.beginningOfLast45Minutes()@javascript:gs.endOfLast45Minutes()">Last 45 minutes</option><option value="One year ago@javascript:gs.beginningOfOneYearAgo()@javascript:gs.endOfOneYearAgo()">One year ago</option><option value="This fiscal month@javascript:gs.beginningOfThisSchedulePeriod('0ca8ae11d7222100738dc0da9e6103e3','This fiscal month')@javascript:gs.endOfThisSchedulePeriod('0ca8ae11d7222100738dc0da9e6103e3','This fiscal month')">This fiscal month</option><option value="Last fiscal month@javascript:gs.beginningOfLastSchedulePeriod('0ca8ae11d7222100738dc0da9e6103e3','Last fiscal month')@javascript:gs.endOfLastSchedulePeriod('0ca8ae11d7222100738dc0da9e6103e3','Last fiscal month')">Last fiscal month</option><option value="Next fiscal month@javascript:gs.beginningOfNextSchedulePeriod('0ca8ae11d7222100738dc0da9e6103e3','Next fiscal month')@javascript:gs.endOfNextSchedulePeriod('0ca8ae11d7222100738dc0da9e6103e3','Next fiscal month')">Next fiscal month</option><option value="Last 3 fiscal months@javascript:gs.beginningOfSchedulePeriodsAgo(3, '0ca8ae11d7222100738dc0da9e6103e3','Last 3 fiscal months')@javascript:gs.endOfSchedulePeriodsAgo(1, '0ca8ae11d7222100738dc0da9e6103e3','Last 3 fiscal months')">Last 3 fiscal months</option><option value="Last 12 fiscal months@javascript:gs.beginningOfSchedulePeriodsAgo(12, '0ca8ae11d7222100738dc0da9e6103e3','Last 12 fiscal months')@javascript:gs.endOfSchedulePeriodsAgo(1, '0ca8ae11d7222100738dc0da9e6103e3','Last 12 fiscal months')">Last 12 fiscal months</option><option value="Next 3 fiscal months@javascript:gs.beginningOfSchedulePeriodsAgo(-1, '0ca8ae11d7222100738dc0da9e6103e3','Next 3 fiscal months')@javascript:gs.endOfSchedulePeriodsAgo(-3, '0ca8ae11d7222100738dc0da9e6103e3','Next 3 fiscal months')">Next 3 fiscal months</option><option value="Next 12 fiscal months@javascript:gs.beginningOfSchedulePeriodsAgo(-1, '0ca8ae11d7222100738dc0da9e6103e3','Next 12 fiscal months')@javascript:gs.endOfSchedulePeriodsAgo(-12, '0ca8ae11d7222100738dc0da9e6103e3','Next 12 fiscal months')">Next 12 fiscal months</option><option value="This Fiscal Quarter@javascript:gs.beginningOfThisSchedulePeriod('b198ae11d7222100738dc0da9e6103d7','This fiscal quarter')@javascript:gs.endOfThisSchedulePeriod('b198ae11d7222100738dc0da9e6103d7','This fiscal quarter')">This Fiscal Quarter</option><option value="Last Fiscal Quarter@javascript:gs.beginningOfLastSchedulePeriod('b198ae11d7222100738dc0da9e6103d7','Last fiscal quarter')@javascript:gs.endOfLastSchedulePeriod('b198ae11d7222100738dc0da9e6103d7','Last fiscal quarter')">Last Fiscal Quarter</option><option value="Last 4 fiscal quarters@javascript:gs.beginningOfSchedulePeriodsAgo(4, 'b198ae11d7222100738dc0da9e6103d7','Last 4 fiscal quarters')@javascript:gs.endOfSchedulePeriodsAgo(1, 'b198ae11d7222100738dc0da9e6103d7','Last 4 fiscal quarters')">Last 4 fiscal quarters</option><option value="Next Fiscal Quarter@javascript:gs.beginningOfNextSchedulePeriod('b198ae11d7222100738dc0da9e6103d7','Next fiscal quarter')@javascript:gs.endOfNextSchedulePeriod('b198ae11d7222100738dc0da9e6103d7','Next fiscal quarter')">Next Fiscal Quarter</option><option value="Next 4 fiscal quarters@javascript:gs.beginningOfSchedulePeriodsAgo(-1, 'b198ae11d7222100738dc0da9e6103d7','Next 4 fiscal quarters')@javascript:gs.endOfSchedulePeriodsAgo(-4, 'b198ae11d7222100738dc0da9e6103d7','Next 4 fiscal quarters')">Next 4 fiscal quarters</option><option value="This fiscal year@javascript:gs.beginningOfThisSchedulePeriod('3f682e11d7222100738dc0da9e610353','This fiscal year')@javascript:gs.endOfThisSchedulePeriod('3f682e11d7222100738dc0da9e610353','This fiscal year')">This fiscal year</option><option value="Last fiscal year@javascript:gs.beginningOfLastSchedulePeriod('3f682e11d7222100738dc0da9e610353','Last fiscal year')@javascript:gs.endOfLastSchedulePeriod('3f682e11d7222100738dc0da9e610353','Last fiscal year')">Last fiscal year</option><option value="Next fiscal year@javascript:gs.beginningOfNextSchedulePeriod('3f682e11d7222100738dc0da9e610353','Next fiscal year')@javascript:gs.endOfNextSchedulePeriod('3f682e11d7222100738dc0da9e610353','Next fiscal year')">Next fiscal year</option></select>

Thanks,

Harshvardhan

[sam_yan · Accepted solution]

Thank you Harshvardhan.

It's in the BR: Get Date Filter Options for Date Filters

[ShabbirAbbS]

Can we add like this , I tried but it is not working.

answer.add('180_First quarter@javascript&colon;gs.beginningOfThisQuarter(1)@javascript&colon;gs.endOfThisQuarter(1)', gs.getMessage('First quarter'));

    answer.add('185_Second quarter@javascript&colon;gs.beginningOfThisQuarter(2)@javascript&colon;gs.endOfThisQuarter(2)', gs.getMessage('Second quarter'));

    answer.add('190_Third quarter@javascript&colon;gs.beginningOfThisQuarter(3)@javascript&colon;gs.endOfThisQuarter(3)', gs.getMessage('Third quarter'));

    answer.add('195_Fourth quarter@javascript&colon;gs.beginningOfThisQuarter(4)@javascript&colon;gs.endOfThisQuarter(4)', gs.getMessage('Fourth quarter'));

My requirement is to apply the Quarter 1, Quarter 2, Quarter 3, Quarter 4 to the reports by Interactive filter, I'm able to add these in the dropdown by customizing the OOTB BR but it is not working.

[amyrobben]

Were you able to successfully add options to this filter through the business rule?

Modifying the script (adding options or removing options) does not affect the values I see in the dropdown list.