Full Version: Filter with null condition
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I need list all tickets without a assigned to with a valid value

I tried

Assigned to equals null

But system list all tickets, instead of only with no valid value

What I did wrong?[]=filter

the inverse works, ie not equal null lists all with assigned relationship

listview debug

SELECT vtiger_troubletickets.title, vtiger_crmentity.smownerid, vtiger_troubletickets.status, vtiger_troubletickets.parent_id, vtiger_crmentity.createdtime, vtiger_troubletickets.from_mailscanner, vtiger_troubletickets.ticketid FROM vtiger_troubletickets INNER JOIN vtiger_crmentity ON vtiger_troubletickets.ticketid = vtiger_crmentity.crmid LEFT JOIN vtiger_users ON vtiger_crmentity.smownerid = LEFT JOIN vtiger_groups ON vtiger_crmentity.smownerid = vtiger_groups.groupid LEFT JOIN vtiger_account ON vtiger_troubletickets.parent_id = vtiger_account.accountid LEFT JOIN vtiger_contactdetails ON vtiger_troubletickets.parent_id = vtiger_contactdetails.contactid WHERE vtiger_crmentity.deleted=0 AND ( (( trim(vtiger_account.accountname) IS NOT NULL OR trim(CONCAT(vtiger_contactdetails.firstname,' ',vtiger_contactdetails.lastname)) IS NOT NULL) )) AND vtiger_troubletickets.ticketid > 0 ORDER BY vtiger_troubletickets.title DESC
this should be fixed now