| Author |
Message
|
| MQRR |
 Posted: Thu Feb 22, 2007 11:41 am Post subject: (solved)filter for NOOP |
 |
|
Centurion
Joined: 10 Aug 2003
Posts: 110
|
Do anyone know how to create a filter that displays NOOP activities stuck in running state?
I tried creating worklist using attributes NAME LIKE etc.. but did not work.
Last edited by MQRR on Thu Feb 22, 2007 5:03 pm; edited 1 time in total |
|
| Back to top |
|
 |
| jmac |
| Posted: Thu Feb 22, 2007 12:11 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
You need to do a queryActivityInstances, because there are no workitems created if you have the NOOP defined properly.
Once you use the correct query, you may be able to do some filtering to cut down on the number of items returned.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MQRR |
| Posted: Thu Feb 22, 2007 3:07 pm Post subject: |
|
|
Centurion
Joined: 10 Aug 2003
Posts: 110
|
Thanks jmac.
But does activity list give the NOOP list? I tried that seems to be not listing them. I tried to use the name of my NOOP acitivty, for example, if I created the NOOP in my build time with name MYNOOP then my activty list filter is,
NAME = 'MYNOOP'
and also tried
NAME LIKE '%NOOP%'
just in case.
Is there any specific table in the runtime database that I can query? i tried work_item table looks like it is not in there, ofcourse as you said it should not be work item if defined properly.
Is there activity table?
Again thanks for the inputs.
MQRR |
|
| Back to top |
|
|
| jmac |
| Posted: Thu Feb 22, 2007 3:20 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I don't see why what you indicate you are doing should not work. Perhaps you need to open a PMR.
I don't have time at the moment to test this, send me your query and I will have a look and see if I see any problems, but I really think this should work.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MQRR |
| Posted: Thu Feb 22, 2007 3:52 pm Post subject: |
|
|
Centurion
Joined: 10 Aug 2003
Posts: 110
|
I will send you the query for the filter.
In the case of querying the tables directly, I would think atleast there should be some table in the database that would contain the information for NOOP.
Thank you.
MQRR |
|
| Back to top |
|
|
| MQRR |
| Posted: Thu Feb 22, 2007 5:02 pm Post subject: |
|
|
Centurion
Joined: 10 Aug 2003
Posts: 110
|
silly mistake on my part. Thanks for pointing out that Jmac.
I was using % instead of * . Changing that fixed it. so the solution is
create a Activity List to view the NOOP activities.
And if anyone knows which table corresponds to activities, just like work_item table, update this bug.
Thanks,
MQRR |
|
| Back to top |
|
|
|
|
