After creating a scoreboard query that allows multiple ticket types, sorting the cases changes the results


Article ID: 6193


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


In Service Desk Manager, when creating a scoreboard query that either includes multiple ticket types or does not filter the ticket type, initial search results are correct, but if an attempt to sort the result is made, the number of returned tickets is reduced.  It appears a filter is automatically applied.

Examples of this type of query may be:

assignee = AND active = 1 AND type = \'I\' OR type = \'R\'


assignee = AND active = 1



By design, Service Desk Manager only supports adding a single ticket type to a scoreboard query. When the results are returned, a form (likely list_cr.htmpl), is used to display the list of cases. Once a sort is performed, all other ticket types are removed and only Requests will be present. This is an expected result.


CA Service Desk Manager 12.9 and 14.1All Supported Operating Systems


It is recommended to alter any scoreboard queries that include multiple ticket types to separate each ticket type into its own scoreboard query. This will prevent the behavior.

Additional Information

Further information on creating Scoreboard Queries: