Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Filter with null condition
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

Attached Files Image(s)
eCRM Web

Messages In This Thread
Filter with null condition - rslemer - 09-18-2019, 05:26 PM
RE: Filter with null condition - joebordes - 04-23-2020, 11:46 PM

Forum Jump:

Users browsing this thread: 1 Guest(s)