Filter on empty date in ListView

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

Hi Andre,

That works very well

Thanks for your knowledge on this - it will be very useful.

Neil

Hi Andre,

Your solution works perfectly. I added "is not empty" option in filter dropdown for related field(assign to).

Thank you.

Hello all...

Thank you  André Lopes!  That is sooooo handy to look for empty or not empty date fields!  Leaves me wondering why Sugar don't have that by default?

Like Jairam Madankar we also deployed an addition (below) so we can also filter for a relate field which is empty or not empty. We plan to add text fields (varchar?) to it also.

- Why?  I wanted to find Contacts where Account is Empty, then do a recalculate values.  I did a report export import but that seemed to not work for populating a text field on contact's with a related lookup formula to the account - but mass update works a treat.

This is what was added to Andre's code above:

$viewdefs['base']['filter']['operators']['relate']['$empty'] = 'LBL_OPERATOR_EMPTY';

$viewdefs['base']['filter']['operators']['relate']['$not_empty'] = 'LBL_OPERATOR_NOT_EMPTY';

I have also added this comment to the following 'idea':

Add operator "is empty" on text field filter 

Thanks again!

I have done this way as well but doing 

require_once 'clients/base/filters/operators/operators.php';

foreach($viewdefs['base']['filter']['operators'] as $key => $view)
{
    if($key == 'date' or $key == 'datetime')
    {
        $viewdefs['base']['filter']['operators'][$key]['$empty'] = 'LBL_OPERATOR_EMPTY';
        $viewdefs['base']['filter']['operators'][$key]['$not_empty'] = 'LBL_OPERATOR_NOT_EMPTY';
    }
}

do you know why does not work on Demand??

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';
		}
	}
}

Hi André, under certain conditions the filter allows only empty and not empty with your code. I had that issue in 10.1 and had to check $viewdefs to be not empty (see my answer below).