CA Service Management

  • 1.  Invalid constraint in stored query

    Posted 03-15-2016 09:40 AM

    Hi!

     

    In the query below I get an error message I don't quite understand. The query should return every incident which is assigned to you or any of your groups and which was not last modified by the assignee of the ticket. When saving, SDM throws the error below.

    "AHD05800:Bad where clause. invalid constraint. Check data types of referenced attributes"

    (assignee = @cnt.id OR group.[group]group_list.member IN (@cnt.id))

    AND active = 1

    AND last_mod_by != assignee

    AND type = \'I\'

    AND last_mod_by IS NOT NULL

    If I change "assignee" to "@cnt.id", I am able to save as usual.

    I have checked the technical reference which specify both as byte(16).

     

    Thankful for any responses!



  • 2.  Re: Invalid constraint in stored query
    Best Answer

    Posted 03-16-2016 03:40 AM

    Stored Queries do not let you compare two attributes of an object (in this case last_mod_by and assignee).



  • 3.  Re: Invalid constraint in stored query

    Posted 03-16-2016 05:10 AM

    But as of my understanding it is okay to change it to @cnt.id because it is an "and" query and as long the @cnt.id is the assignee then the @cnt.id should not the the last_mod_by contact.