Where clause invalid constraint on stored query

book

Article ID: 220370

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Service Desk Manager

Issue/Introduction

Creating a filter on task and receiving a strange error on the following where clause.

status != \'WAIT\' and status != \'REOPWAIT\' and status.allow_task_update = 1 and group = U\'14554DA192937D4FB2AE27029D5FE50E\' and assignee is null and cr.category = \'pcat:504298\'

Error: Impossible to resolve status.allow_task_update 

Environment

Release : 17.2

Component : Svc Desk Database

Resolution

Stored queries are applied to a specific table, the "Type" field in the screencaps displayed.  The original stored query runs the given where clause on the "Request Workflow Task" table.  However, the new stored query being used is trying to apply to the "Request" table.  The "Request" table's status field has no link to the "allow_task_update" attribute, but the "Request Workflow Task" Table's status field does have a link to the "allow_task_update" attribute.