Reports filter for "does not contain"

[URtech]

I'm curious if anyone has a solution or workaround for creating a filter value of "does not contain" instead of only having "contains" within the Reports module filter options? Any tips or tricks on how you did this would be greatly appreciated!

Cheers, Sean

[jenny]

In order to do this, you would have to do the following:

1. In modules/Reports/templates/templates_modules_defs_js.php, search for "contains". You would add your qualifier construct here:

e.g.
qualifiers[qualifiers.length] = {name:'contains',value:'<?php echo $mod_strings['LBL_CONTAINS']; ?>'};
qualifiers[qualifiers.length] = {name:'not_contains',value:'<?php echo $mod_strings['LBL_NOT_CONTAINS']; ?>'}

This step will make sure that the filter qualifier drop down will contain the "Not Contains" value.

2. In include/generic/SugarWidgets/SugarWidgetFieldvarchar, add a new function similar to this one:

function queryFilterNot_Contains(&$layout_def)
{

return $this->_get_column_select($layout_def)." NOT LIKE '%".$GLOBALS['db']->quote($layout_def['input_name0'])."%'\n";

}

Delete any files named modules_def_% from \cache\modules\ and be sure to clear the browser cache before trying it out.