AnsweredAssumed Answered

Scoreboard query - result of two integers added

Question asked by laura.hamersly on Jun 26, 2017
Latest reply on Jun 26, 2017 by Chi_Chen

I am attempting to create a scoreboard query that will display tickets based off of two custom integer fields that are added together. When I attempt to add the two integers within the scoreboard, I receive the error: "Bad where clause. invalid constraint. Could not recognize int1+int2."

 

This is an example of a query that I am attempting to create:

active=1 AND (int1 + int2 > 2)

 

Is this type of query possible to be added as a Scoreboard query within Service Desk?

Outcomes