Q35GetWorkOrderFetchInformation
Cantara Business function which is designed to be used by Cantara Client Applications.
Its purpose is to help speed up the process of retrieving a work order and its relevant data. For when downloading a work order from a Cantara Client Application it is best to know what additional data a work order has so the application can specifically fetch only that data over executing queries which could possible return no results.
The function will check for the following additional data on a work order, if valid data is found a '1' will be return to the relevant item:
- Work Order First Text Attachment (F00165)
- Media Objects (F00165)
- Equipment Route (F1207)
- Parts List (F3111)
- Routing (F3112)
- Failure Analysis (F48165)
- Work Order Parts First Text Attachment (F00165)
- Work Order Routing First Text Attachment (F00165)
Note
Work Order Parts and Routing attachments can be searched for optionally. Providing a value of '2' for either of these will bypass checking for those attachments.
This has been enabled in case searching through all Parts and/or Routing attachments is deemed to be too lengthy a process.
Data Structure
| Name | Type | Inclusion | Direction |
|---|---|---|---|
| mnWorkOrderNumber | INTEGER | REQUIRED | IN |
| cHasFirstTextAttachment | CHARACTER | OPTIONAL | OUT |
| cHasMediaObjectAttachments | CHARACTER | OPTIONAL | OUT |
| cHasEquipmentRoute | CHARACTER | OPTIONAL | OUT |
| cHasPartsList | CHARACTER | OPTIONAL | OUT |
| cHasRouting | CHARACTER | OPTIONAL | OUT |
| cHasFailureAnlysis | CHARACTER | OPTIONAL | OUT |
| cHasTimeCards | CHARACTER | OPTIONAL | OUT |
| cHasPartsAttachments | CHARACTER | OPTIONAL | BOTH |
| cHasRoutingAttachments | CHARACTER | OPTIONAL | BOTH |