[Vtigercrm-developers] Assigned To criteria for scheduled workflows for tickets not working

[Steve Kenow]

I activated debug and this is the query being executed :

SELECT 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
WHERE vtiger_crmentity.deleted=0
    AND   (( vtiger_crmentity.createdtime < '2015-04-29 14:04:01')
    and ( vtiger_troubletickets.status <> 'Closed')
    and ( vtiger_troubletickets.status <> 'Cancelled')
    and ( vtiger_crmentity.modifiedtime < '2015-04-30 14:04:01')
    and ( vtiger_troubletickets.title = '')
    and ( (trim(CONCAT(vtiger_users.first_name,' ',vtiger_users.last_name))
<> '36' or vtiger_groups.groupname <> '36')) )
    AND vtiger_troubletickets.ticketid > 0

No where in my criteria do I have title and it appears the assigned_user_id
is being treated as the text value, not as numeric - can anyone get me
closer to what needs to change?

On Tue, Apr 28, 2015 at 3:32 PM, Steve Kenow <skenow at rdspos.com> wrote:

> When creating a scheduled workflow for Tickets, the 'Assigned To' criteria
> are not working, at least for 'is' and 'is not'. I'm trying to create
> escalation emails after a period of time (which works), but I need to
> exclude tickets assigned to certain users and groups. If I use the
> condition 'is not' all records are returned without any filtering. If I use
> the condition 'is' no records are returned.
>
> See:
> https://discussions.vtiger.com/index.php?p=/discussion/177368/scheduled-workflow-for-ticket-escalation-not-following-all-criteria
>
> Steve
>
>


-- 
*Steve Kenow*
Retail Data Systems of Minnesota
Manager, Service Desk and End User Support
Direct: 952.392.2686
Office: 952.934.4002
skenow at rdspos.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150502/ee107ea6/attachment.html>