Work orders

Work order reports

Work order progress report

The work order progress report is a report that generates information about the progress of individual work order components/tasks. The report includes sub-reports: service event execution, inspection execution, supervision execution, data flow objects.

  • Original filename: WorkOrderProgress.jasper

  • Report UUID: 16aeb293-d58a-4785-b65c-7f76b8e00495

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String workOrderUuid - UUID of the work order

  • boolean hideServiceEvents - whether to hide the service events subreport

  • boolean hideInspectionExecutions - whether to hide the inspection execution subreport

  • boolean hideFlowOrders - whether to hide the dataflow subreport

  • boolean hideSupervisionExecutions - whether to hide the supervision execution report

Flap

name description type

objects

Work order object

objects

workorder_name

Work order name

string

workorder_contract

Contract name

string

workorder_contractscope

Contract scope name

string

workorder_customer

Customer name

string

contract_customer

customer name in the contract

string

workorder_description

work order description

string

workorder_type

work order types (combined string)

string

workorder_state

work order status

string

workorder_proity

work order priority

string

workorder_begindate

work order start date

date

workorder_enddate

work order completion date

date

workorder_assigned_department

the name of the assigned department

string

workorder_assigned_to

name of the assigned person

string

workorder_verified_by

name of the verifying person

string

workorder_account

accounting account

string

workorder_location

work order location

string

workorder_location_description

a description of the work order location

string

workorder_place_of_work

workplace of the work order

string

workorder_placeofwork_description

job description for the work order

string

workorder_notes

work order note

string

Variables

  • lack

Parameters

  • SUBREPORT_INSPECTIONS - appearance of the inspection subreport

  • SUBREPORT_SERVICEEVENTS - appearance of the service events subreport

  • SUBREPORT_SUPERVISIONS - appearance of the supervision subreport

  • SUBREPORT_FLOWORDERS - appearance of the object flow subreport

  • HIDE_INSPECTIONS - whether to hide the inspection section

  • HIDE_FLOWORDERS - whether to hide the section on the flow of objects

  • HIDE_SUPERVISIONS - whether to hide the supervision section

  • HIDE_SERVICEEVENTS - whether to hide the service events section

Data source

name description type

ds_inspections

Audit data source

objects

ds_supervisions

Source of data for supervision

objects

ds_serviceevents

Data source for execution of service events

objects

ds_workorders

Data source for FlowOrder objects

objects

ds_main

Main report data source with push to subreports

objects

Subreport

Inspection progress
name description type

objects

inspection object

objects

inspection_id

inspection ID

long

concerns

what the inspection is about (product, group, element)

string

protocol_number

protocol number

string

template

audit template name

string

note

inspection note

string

type

inspection type

string

date

expected completion date acc. work orders

date

assigned

assigned person (name, surname)

string

executed_by

person performing (name, surname)

string

execution_date

execution date

date

finished

completed - OK/NOK icon

java.awt.Image

checked

checked - OK/NOK icon

java.awt.Image

report_generated

report generated - OK/NOK icon

java.awt.Image

is_finished

is it finished

boolean

is_checked

checked

boolean

is_report_generated

whether the report has been generated

boolean

execution_state

CORRECT, NEEDS_ATTENTION, NEEDS_SERVICE, or null

string
Supervision progress
name description type

objects

supervision object

objects

concerns

what the supervision is about

string

executed_by

made by (first name)

string

executed_on

when done

date

finished

completed - OK/NOK icon

java.awt.Image

is_finished

or completed supervision

boolean
Service event progress
name description type

objects

service event execution object

objects

number

event number

long

concerns

what the event is about

string

expected_state

The expected state of the event

string

current_state

The current state of the event

string

executed_on

date change has been made

date

executed_by

the change was made by the person (name, surname)

string

finished

whether the status is fulfilled - OK/NOK icon

java.awt.Image

is_finished

whether the condition is fulfilled

boolean
Object flow progress
name description type

type

the name of the type specified in the flow

string

id

object identifier

long

items_size

number of saved items

integer

expected_count

expected amount to flow

BigDecimal

Work Order History Report

The work order history report displays all information about the history logged to the work order. Information about hours worked, status changes, and the team involved in tasks is available.

  • Original file name: ReportWorkOrdersHistory.jasper

  • Report UUID: 42a76295-aa93-493e-908e-2a972b004aa0

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • WorkOrderState state - work order status

  • WorkOrderPriority priority - work order priority

  • String typeUuid - tp of the work order

  • boolean onlyRootWorkOrders - only root work orders

  • boolean archived - only archived orders

  • String contractUuid - the contract to which the order is assigned

  • String contractScopeUuid - contract scope assigned to the order

  • String accountUuid - billing account

  • String workOrderUuid - identifier of a specific work order

  • boolean includeChildWorkOrders - include child orders in the data

  • String assignedUserUuid - assigned user

  • String assignedUserEmployerUuid - users assigned as employees of a given contractor

  • String assignedContractorUuid - assigned contractor

  • String assignedDepartmentUuid - assigned department

  • boolean dateFromPlans - whether dates refer to planned dates

  • DateFields dates - date field (enum)

  • boolean specificDate - whether to include a specific date range

  • LocalDate dateFrom - date from

  • LocalDate dateTo - date to

  • String reportByUserUuid - report saved by the user

  • String userInTeamUuid - in the history a given user in the indicated team

Flap

name description type

objects

The work order history object

objects

type

work order type

String

state

the current status of the work order

String

priority

work order priority

String

archived

whether the order is archived

Boolean

contract_name

Contract name

String

contract_scope_name

Contract scope name

String

account_name

billing account name

String

name

job name

String

description

job description

String

protocol_number

order number

String

assigned_user_login

assigned person’s login

String

assigned_user_fullname

full name of the assigned person

String

assigned_user_employer_name

name of the assigned user’s employer

String

assigned_contractor_name

name of the assigned counterparty

String

assigned_department_name

department name

String

begin_date

scheduled start date

date

deadline_date

expected end date

l.Date

start_date

start date

date

finish_date

end date

date

reported_on

reported on the date

date

reported_by_login

login of the reporting person

String

reported_by_fullname

the name of the reporting person

String

stamp

record creation timestamp

date

reported_state

status reported

String

reported_message

report message

String

reported_hours

reported hours

BigDecimal

reported_participants_logins

logins of people participating in the task

String

reported_participants_fullnames

full names of persons participating in the task

String

reported_hours_all

total number of hours reported (number of hours * number of participants)

BigDecimal

Variables

  • logo - InputStream - logo currently set in configuration

  • sum_worked_hours - BigDecimal - sum of hours worked for a given group

  • sum_worked_hours_total - BigDecimal - sum of all worked hours

  • sum_all_hours - BigDecimal - sum of hours

  • sum_all_hours_total - BigDecimal - sum of all hours

Parameters

  • CURRENCY_SYMBOL - currently selected currency (code)

Data source

name description type

ds_main

The main object of the data source - to be used, for example, in subreports

objects

Subreport

  • lack

Work order summary report

The work order progress report is a report that generates information about the progress of individual work order components/tasks. The report includes sub-reports: service event execution, inspection execution, supervision execution, data flow objects.

  • Original file name: ReportWorkOrderSummary.jasper

  • Report UUID: 16aeb293-d58a-4785-b65c-7f76b8e00495

  • The input file for the application is a file with the extension jasper.

Report input configuration

  • String workOrderUuid - UUID of the work order

  • boolean hideServiceEvents - hide the work order subreport

  • boolean hideInspectionExecutions - whether to hide the inspection execution subreport

  • boolean hideSupervisionExecutions - whether to hide the supervision subreport

Flap

name description type

objects

Work order object

object

workorder_name

Work order name

String

workorder_contract

name of the assigned contract

String

workorder_contractscope

String

workorder_customer

name of the client assigned to the order

String

contract_customer

the name of the client assigned to the contract

String

workorder_description

job description

String

workorder_type

order type

String

workorder_state

job status

String

workorder_proity

job priority

String

workorder_begindate

waiting start date

String

workorder_enddate

expected end date

String

workorder_assigned_department

assigned department

String

workorder_assigned_to

assigned person (name and surname)

String

workorder_verified_by

verifying person

String

workorder_account

billing account

String

workorder_location

Location name

String

workorder_location_description

description of the location

String

workorder_place_of_work

workplace

String

workorder_placeofwork_description

job description

String

workorder_notes

notes

String

Variables

  • InputStream logo - logo used in the report

Parameters

  • CURRENCY_SYMBOL - currently selected currency (code)

  • SUBREPORT_INSPECTIONS - appearance of the inspection subreport

  • SUBREPORT_SERVICEEVENTS - appearance of the service events subreport

  • SUBREPORT_SUPERVISIONS - appearance of the supervision subreport

  • HIDE_INSPECTIONS - whether to hide the inspection subreport

  • HIDE_SERVICEEVENTS - whether to hide the service events subreport

  • HIDE_SUPERVISIONS - whether to hide the supervision subreport

Data source

name description type

ds_main

The main object of the data source - to be used, for example, in subreports

objects

Subreport

Data source

name description type

ds_inspections

Audit data source

objects

ds_supervisions

Source of data for supervision

objects

ds_serviceevents

Data source for execution of service events

objects

ds_workorders

Data source for FlowOrder objects

objects

ds_main

Main report data source with push to subreports

objects

Subreport

Inspection progress
name description type

objects

inspection object

objects

inspection_id

inspection ID

long

concerns

what the inspection is about (product, group, element)

string

protocol_number

protocol number

string

template

audit template name

string

note

inspection note

string

type

inspection type

string

date

expected completion date acc. work orders

date

assigned

assigned person (name, surname)

string

executed_by

person performing (name, surname)

string

execution_date

execution date

date

finished

completed - OK/NOK icon

java.awt.Image

checked

checked - OK/NOK icon

java.awt.Image

report_generated

report generated - OK/NOK icon

java.awt.Image

is_finished

is it finished

boolean

is_checked

checked

boolean

is_report_generated

whether the report has been generated

boolean

execution_state

CORRECT, NEEDS_ATTENTION, NEEDS_SERVICE, or null

string
Supervision progress
name description type

objects

supervision object

objects

concerns

what the supervision is about

string

executed_by

made by (first name)

string

executed_on

when done

date

finished

completed - OK/NOK icon

java.awt.Image

is_finished

or completed supervision

boolean
Service event progress
name description type

objects

service event execution object

objects

number

event number

long

concerns

what the event is about

string

expected_state

The expected state of the event

string

current_state

The current state of the event

string

executed_on

date change has been made

date

executed_by

the change was made by the person (name, surname)

string

finished

whether the status is fulfilled - OK/NOK icon

java.awt.Image

is_finished

whether the condition is fulfilled

boolean