Maximo 7.6.1.1/Oracle 12c: Is there a way to select the latest n workorders using the List View in Work Order Tracking? Example: the workorders with the 10 latest reportdates . It would be preferable if there was a way for non-technical users to do this using OOB functionality.

Reputation: 396

Select latest n workorders using OOB functionality?

Maximo 7.6.1.1/Oracle 12c:

Is there a way to select the latest n workorders using the List View in Work Order Tracking?

It would be preferable if there was a way for non-technical users to do this using OOB functionality.

Upvotes: 2

Reputation: 396

One way to do this would be to save a WHERE CLAUSE query:

and wonum in(select wonum from workorder where siteid = 'SERVICES' order by reportdate desc fetch first 10 row only)

However, I wouldn't call this out-of-box functionality.

More information about the Oracle SQL here: Get last record of result set

Upvotes: 1