+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Filter with null condition (/showthread.php?tid=1592)
Filter with null condition - rslemer - 09-18-2019
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?
http://corebos.com/documentation/doku.php?id=en:using_filters&s[]=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 = vtiger_users.id 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
RE: Filter with null condition - joebordes - 04-23-2020
this should be fixed now