Filter on empty date in ListView

Question

When building a filter in ListView, the date field filter options do not include Is Empty/Is Not Empty options (as it does in Reports)

Sugar Support have logged this as a defect/enhancement

Does anyone have a way of dealing with this. It is a basic business requirement to list records which don't have a date field completed.

My specific requirement involves a number of date fields so I want to avoid creating a custom calculated field (which would be an option if only one field involved) which I could filter on (eg date present)

Thanks

Neil Conacher · Accepted Answer

Hi Neil Conacher

I believe you can create a custom filter operators (custom/clients/base/filters/operators/operators.php) and set the operators $empty and $not_empty for date type fields:

<?PHP
include 'clients/base/filters/operators/operators.php';
$viewdefs['base']['filter']['operators']['date']['$empty'] = 'LBL_OPERATOR_EMPTY';
$viewdefs['base']['filter']['operators']['date']['$not_empty'] = 'LBL_OPERATOR_NOT_EMPTY';
$viewdefs['base']['filter']['operators']['datetime']['$empty'] = 'LBL_OPERATOR_EMPTY';
$viewdefs['base']['filter']['operators']['datetime']['$not_empty'] = 'LBL_OPERATOR_NOT_EMPTY';
$viewdefs['base']['filter']['operators']['datetimecombo']['$empty'] = 'LBL_OPERATOR_EMPTY';
$viewdefs['base']['filter']['operators']['datetimecombo']['$not_empty'] = 'LBL_OPERATOR_NOT_EMPTY';

Go to Admin -> Repar -> "Quick Repair and Rebuild" / "Clear Additional Cache" after saving this file.

Regards

André Lopes
Lampada Global

Skype: andre.lampada

Neil Conacher · Answer

You must always check $viewdefs to be not empty and use the "||" operator, not "or". Try this code, it just worked with 10.1: 
 require_once 'clients/base/filters/operators/operators.php';
if (!empty($viewdefs['base']['filter']['operators']))
{
	foreach($viewdefs['base']['filter']['operators'] as $key => $view)
	{
 if(($key == 'date') || ($key == 'datetime') || ($key == 'datetimecombo'))
 {
 $viewdefs['base']['filter']['operators'][$key]['$empty'] = 'LBL_OPERATOR_EMPTY';
 $viewdefs['base']['filter']['operators'][$key]['$not_empty'] = 'LBL_OPERATOR_NOT_EMPTY';
 }
	}
}