Skip to main content
S
Saravanan10-Marble
10-Marble
November 15, 2011
Question

Query - ECN list based on user

  • November 15, 2011
  • 7 replies
  • 2504 views
Hello All,

ECN users took the leave with out delegating their task to others. For that I need query to find out the ECN list based on the user assigned for their roles.

Is there any one having query handy / inputs on this highly appreciated.

Thanks,
Saravanan

7 replies

A
AL_ANDERSON12-Amethyst
12-Amethyst
November 15, 2011
The easiest way is to do this an advanced search on Workitem where you add
"Role" to the search criteria. If you then add "Name" (where the name is
the name of the task you are looking for) and/or "Owner" and "Status"
where Status is not equal to Complete, then you can just use Search and
then as an administrator you can even reassign search results as long as
they are in the same context. You cannot reassign items from different
contexts in one step - you need one step per context, but as many
workitems in the same context as you want.

If you ECN tasks are named differently than other workflow tasks, then
this is easy and you don't have to worry about tasks that are not for
ECNs. We were very careful not to have any two tasks in any workflow with
exactly the same name so that searching and reporting will not incorrectly
merge different types of primary business objects when we look for a
particular task name.

You can use query builder, but this is better since you can reassign from
the search results. You might have to resort to Query Builder if you have
many different workflows for different objects all using tasks with the
same task name.

Al






"Ganapathy Saravanan (Consultant)"
<->
11/15/2011 01:46 PM
Please respond to
"Ganapathy Saravanan (Consultant)"
<->


To
"-" <->
cc

Subject
[solutions] - Query - ECN list based on user




Caterpillar: Confidential Green Retain Until: 12/15/2011



Hello All,

ECN users took the leave with out delegating their task to others. For
that I need query to find out the ECN list based on the user assigned for
their roles.

Is there any one having query handy / inputs on this highly appreciated.

Thanks,
Saravanan


Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription

Use of this email content is governed by the terms of service at:
A
achukwuka1-Visitor
1-Visitor
November 15, 2011
Agreed. This is much better than using query builder.

Alexius C. Chukwuka
IT Analyst, Global SAP Basis
Technical Change Management (TCM)
Deere & Company World Headquarters
400 19th St, Moline, IL 61265
Office: (309) 765-3133
Mobile: (319) 429-5336
S
Saravanan10-MarbleAuthor
10-Marble
November 16, 2011
Hello Al and Alexius,

Thanks for your pointers.

I couldn't pick the workitem from object type in advanced search even though i set the workitem class in "All Applicable Object Types Search" under "Search" in preference manager.

Is there any recommendations for resolving this issue?

Thanks in Advance,
Saravanan
S
Saravanan10-MarbleAuthor
10-Marble
November 16, 2011
We are using the Windchill 9.1 M040.
M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
November 16, 2011
9.1 M040

Preference
[cid:image001.png@01CCA432.6E776420]
Needs to include: WCTYPE|wt.workflow.work.WorkItem

[cid:image002.png@01CCA432.6E776420] [cid:image003.png@01CCA432.6E776420]

[cid:image004.png@01CCA432.6E776420]


A
achukwuka1-Visitor
1-Visitor
November 16, 2011
Saravan,

Mike's instructuion is accurate and should resolve the issue if you follow it.


Thanks

Alexius C. Chukwuka
IT Analyst, Global SAP Basis
Technical Change Management (TCM)
Deere & Company World Headquarters
400 19th St, Moline, IL 61265
Office: (309) 765-3133
Mobile: (319) 429-5336
S
Saravanan10-MarbleAuthor
10-Marble
November 17, 2011
Resolved the issue. Thanks for the pointers.

Saravanan
Terms & ConditionsAccessibility statement