Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Sign up

Sign up | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Searching for Cost Management Projects in Work Order Tracking
I've added cost management projects to work orders, but now I can't search for them
May 7, 2019
2:00 pm
Avatar
Tim Pratt
Member
Members
Forum Posts: 7
Member Since:
April 6, 2018
sp_UserOfflineSmall Offline

I have added cost management projects and tasks to my work order tracking application via the process documented here: https://www-01.ibm.com/support/docview.wss?uid=swg21263786

This is great as I have established a number of projects and tasks that I want to tie to work orders. The issue I am having related to then searching for these projects in the work order application. I have followed the same process to add the two fields to the advanced search dialogue in application designer, but when I click the lookup, no values are present to select the project ID, ‘FCPROJECTID’, lookup value ‘PARENTPROJECT’ just as described in the referenced article. Additionally, I tried to write a where clause to get around this and did not return any results. 

((woclass = ‘WORKORDER’ or woclass = ‘ACTIVITY’) and historyflag = 0 and istask = 0 and siteid = ‘X’ and ‘FCPROJECTID’ is not null)

Where X is my siteid.

What am I missing here? Is it because the FCPROJECTID and FCTASK fields are non-persistent? How would one search for work orders related to a specific project if not via this method? How would I write a report? I have been unsuccessful in tracking this information down. Any help would be appreciated.

May 8, 2019
10:52 am
Avatar
Tim Pratt
Member
Members
Forum Posts: 7
Member Since:
April 6, 2018
sp_UserOfflineSmall Offline

Correction: my where clause did not have quote marks around FCPROJECTID. 

October 23, 2019
10:13 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 1, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

October 23, 2019
10:14 am
Avatar
Chon
Stoneham, MA USA
Admin
Forum Posts: 1118
Member Since:
March 1, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

April 24, 2021
6:47 am
Avatar
Craig Kokay
New Member
Members
Forum Posts: 1
Member Since:
April 24, 2021
sp_UserOfflineSmall Offline

My simple solution is to use an automation script to copy the project and task to two (new?) persistent fields that can be then queried.

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

Maximofresher: 45

cgregory: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14318

Moderators: 0

Admins: 3

Forum Stats:

Groups: 1

Forums: 8

Topics: 1578

Posts: 4293

Newest Members:

Marc Bannister, Joseph Tyler, Robert Gonzales, Tarek Marzouk, Tarek Marzouk, Ivan Garza

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0