Question for a query in HPSM

Hello,

I would like to merge 2 views in HPSM: I basically want to add the "Incidents assigned to me" view to my other query. Is there any option for an existing view to add to a syntax?

If I was not clear: 

(assignment#"MY_QUEUE") and flag#true and ((problem.status isin {"Open", "Pending customer", "Owner assigned"} and ((assignee.name = {})")))

This is basically a dispatch query, to that I want to add my tickets. All of them, but only the incidents.

What do you suggest?

Thank you very much in advance!

Tags:

Parents
  • Remember that 'or' queries could potentially do full table searches.  Start your new query like this:

    flag=true and (condition1 or condition2)

    Then you at least limit the or query to active tickets.

    You should also avoid # (starts with) and use = (equal).

    flag=true and (assignee.name=$lo.user.name or (assignment="MY_QUEUE" and (not (problem.status isin {"Pending customer"}))))

Reply
  • Remember that 'or' queries could potentially do full table searches.  Start your new query like this:

    flag=true and (condition1 or condition2)

    Then you at least limit the or query to active tickets.

    You should also avoid # (starts with) and use = (equal).

    flag=true and (assignee.name=$lo.user.name or (assignment="MY_QUEUE" and (not (problem.status isin {"Pending customer"}))))

Children
No Data