Maintenance Connection Q&A: Sorting Work Orders Numerically

Our Question this week was from Liam.G who is using the Maintenance Connection for his facilities management operations in Adelaide, Australia.

"How do you sort Work Orders numerically as opposed to alphanumerically using Maintenance Connection?"

The default WO# field presented on reports is a text field and the sorting results can look a little unusual. For example with alphanumeric sorting,  “10”  appears before  “6”.

1

Fix:

Add a new field to the report that has a numeric type to hold the WOPK.

2

 

Sort by this new field.

3

Below is how the sorting looks when sorted numerically.

4

Thanks for the question Liam and we hope this will help you more efficiently navigate your Work Orders!

If you're interested in sending in a question or problem you might have, don't hesitate to shoot us any mail to marketing@mcaus.com.au.

New Call-to-action

Get more news articles like this