-
1. Re: How to make a query for both change and incident?
woodzmeister Apr 13, 2010 1:51 AM (in response to crispvx)You could create a new query on the Process Management/Process BO - and then put a condition something like:-
(Lifecycle.Title = <Change lifecycle name> OR Lifecycle.Title = <Incident Lifecycle Name) AND Current Assignee.User = User.
Kind regards,
Stephen
-
2. Re: How to make a query for both change and incident?
woodzmeister Apr 13, 2010 1:52 AM (in response to woodzmeister)Addendum. Line should be:-
(Lifecycle.Title = <Change lifecycle name> OR Lifecycle.Title = <Incident Lifecycle Name>) AND Current Assignee.User = Current User
-
3. Re: How to make a query for both change and incident?
crispvx Apr 13, 2010 3:51 PM (in response to woodzmeister)Trying to build this query now and I not able to verify the "Change" life cycle. Do I need to enter anything else for the value besides "Change"?
-
4. Re: How to make a query for both change and incident?
woodzmeister Apr 14, 2010 2:05 AM (in response to crispvx)It should be title of the Lifecycle being used. For instance if your Change Lifecycle is called "Change v1.0" then put in a value "Change v1.0" (without the speech marks). If you've typed it correctly then verify should work. Lifecycles being used can be found from Process Designer.
See attached criteria example.
-
Criteria.PNG 21.6 K
-
-
5. Re: How to make a query for both change and incident?
jilufe Apr 14, 2010 2:58 AM (in response to crispvx)The name you are trying to be verified should be the name of the process. You can see this name of the process in Process Designer | Change Management or Incident Management.
Thanks.
-
6. Re: How to make a query for both change and incident?
crispvx Apr 14, 2010 11:39 AM (in response to jilufe)Ok that was easy after you guys explained it, thank you. Is there a way to capture evry process, perhaps a wild card?
-
7. Re: How to make a query for both change and incident?
crispvx Apr 14, 2010 12:14 PM (in response to crispvx)Attached is an image of the query criteria, for some reason I am not getting the results I ecpect.
-
query.jpeg 37.9 K
-
-
8. Re: How to make a query for both change and incident?
jilufe Apr 14, 2010 9:24 PM (in response to crispvx)what version do you have?
In version 7.3, there is a new feature (advanced option) for criteria condition. At there, you can make () for conditions.
Please refer to the attachment.
Thanks.
-
criteria.jpg 41.3 K
-
-
9. Re: How to make a query for both change and incident?
crispvx Apr 15, 2010 11:30 AM (in response to jilufe)Version is 7.3.2
I didnt even notice the advanced button to the right. Thanks for the suggestion, I will give it a try.