Issue/Symptom/Question

If I know the last 4 digits of the Job Id field, how can I run a query in the Job Information window to retrieve all jobs that have have those last 4 digits?

Environment

• PENTA for Windows
• Job Information window (Project Management>Jobs>Job Information)

Resolution/Fix/Answer

Option 1 (if the Job Id is a numeric domain):

1. Navigate to the Job Information window
2. Click on the Query button on the PENTA toolbar to put the window in query mode
3. Click on the Job Information List of Values button
4. Make sure the List of Values is showing all jobs, if it isn't click Query from the popups toolbar, and select Query Mode
5. After you see the list of Jobs in the List of Values window, click on Edit>Find
6. Enter the part of the Job Id you know, followed by clicking Find Next
7. Click Find Next to cycle through the matches until you find the Job Id you are looking for

Option 2 (if Job Id is alphanumeric):

1. Navigate to the Job Information window
2. Click on the Query button on the PENTA toolbar to put the window in query mode
3. Enter like %xxxx (to search on values ending with xxxx) or like %xxxx% (to search values with xxxx) in the Job Id field
4. Execute the query by clicking the Q again or using ctrl+q on the keyboard

The ability to use the like %xxxx feature in a numeric domain Job # is a known issue and Penta is working with the technology vendor to resolve in a future version.