How Do I... Manage Job Versioning in Views?

You can use Oneserve's search views to surface information about each job's version, such as: its current status; who approved/rejected the version; when the version was last approved/rejected.

Note: Using filters requires a user type to have the MANAGE_SEARCH_CRITERIA user type right assigned to them

Filtering by Version Status

The job search has a built-in filter to allow you to filter jobs by the status of the current version. To do this:

1. Click on the "More Filters" menu and search for "Version Status".

                         

In the field that appears, pick one or more of the following options depending on your needs:

• "New" - Returns any jobs with a new (not yet submitted) version status
• "Version Awaiting Approval" - Returns any jobs for which the current version has not yet been approved
• "Version Approved" - Returns any jobs for which the current version has been approved
• "Version Rejected" - Returns any jobs for which the current version has been rejected

Showing Event Information in Search Columns

In order to get more information about job versions, you can add OQL columns to surface information about when changes were made to the job version. When a version is changed in some way, an event is recorded in the job history. These events can then be queried using these columns.

The following events are used for versions:

• VERCR - Version Created
• VERRE - Version Rejected
• VERAP - Version Approved

To add the OQL columns to the search view:

1. Click on the cog icon at the top right of the search view to show the column config page.

2. Select "*OQL Function Column" from the menu.

3. Give the new columns a name and in the OQL section, use the following syntax to surface information about events relating to the most recent version:

• EventLastCreator({"eventCode":"<Select Code from Above>"}) - Shows the user who last added the event
• EventLastDate({"eventCode": "<Select Code from Above>"}) - Shows the date when this event was most recently added

4. Click "Save" to commit your changes. The results should now show in the search view