Skip to content

List Work Order Info With Id Parent Info By Items

Obtains the complete information of a work order along with the information of its parent work order in a flattened way (by items).

General information:

Module Category
Work Order Read

Molecule details

Input schema:

Field Type Required Description Default value Examples
description Optional[str] ❌ Description. None -
id_work_order Optional[int] ❌ OT ID. None -
id_work_orders_tasks Optional[int] ❌ Task ID. None -
id_task Optional[int] ❌ Task ID. None -
id_item Optional[int] ❌ Item/asset ID. None -
id_status_work_order Optional[int] ❌ Status ID. None -
wo_folio Optional[str] ❌ Folio. None -
creation_date Optional[str] ❌ Creation date. None -
duration Optional[int] ❌ Estimated duration. None -
initial_date Optional[str] ❌ Initial date. None -
id_priorities Optional[int] ❌ Priority ID. None -
priorities_description Optional[str] ❌ Priority description. None -
final_date Optional[str] ❌ End date. None -
completed_percentage Optional[int] ❌ Percentage completed. None -
created_by Optional[str] ❌ Created by. None -
signature Optional[str] ❌ Signature. None -
personnel_description Optional[str] ❌ Staff description. None -
personnel_path_image Optional[str] ❌ Staff image path. None -
code Optional[str] ❌ Code. None -
items_log_description Optional[str] ❌ Log description. None -
done Optional[bool] ❌ Indicates if it is completed. None -
id_request Optional[str] ❌ Request ID. None -
stop_assets Optional[bool] ❌ Asset stoppage. None -
stop_assets_sec Optional[str] ❌ Stop seconds. None -
tasks_log_task_type_main Optional[str] ❌ Main type. None -
parent_description Optional[str] ❌ Description of the father. None -
trigger_description Optional[str] ❌ Trigger description. None -
resources_hours Optional[str] ❌ Hour resources. None -
resources_inventory Optional[str] ❌ Inventory resources. None -
resources_human_resources Optional[str] ❌ Human resources. None -
resources_services Optional[str] ❌ Service resources. None -
cal_date_maintenance Optional[str] ❌ Calculated maintenance date. None -
real_duration Optional[int] ❌ Actual duration. None -
date_maintenance Optional[str] ❌ Maintenance date. None -
user_assigned Optional[str] ❌ Assigned user. None -
note Optional[str] ❌ Note. None -
details_signature Optional[str] ❌ Signature details. None -
responsible_path_signature Optional[str] ❌ Route signature of the person in charge. None -
validator_path_signature Optional[str] ❌ Validator signature path. None -
first_date_task Optional[str] ❌ First task date. None -
costs_center_description Optional[str] ❌ Cost center. None -
tasks_duration Optional[int] ❌ Duration of tasks. None -
total_cost_task Optional[str] ❌ Total cost. None -
requested_by Optional[str] ❌ Requested by. None -
groups_description Optional[str] ❌ Cluster. None -
groups_1_description Optional[str] ❌ Group 1. None -
groups_2_description Optional[str] ❌ Group 2. None -
task_note Optional[str] ❌ Homework note. None -
id_parent_wo Optional[int] ❌ Parent OT ID. None -
has_children Optional[bool] ❌ He has children. None -
real_stop_assets_sec Optional[str] ❌ Actual stop seconds. None -
wo_final_date Optional[str] ❌ End date OT. None -
is_offline Optional[str] ❌ It's offline. None -
tasks_log_types_description Optional[str] ❌ Description of types. None -
tasks_log_types_2_description Optional[str] ❌ Description of types 2. None -
code_create_by Optional[str] ❌ Creator code. None -
event_date Optional[str] ❌ Event date. None -
rating Optional[str] ❌ Qualification. None -
enable_budget Optional[str] ❌ Enable budget. None -
work_orders_status_custom_description Optional[str] ❌ Custom status. None -
review_date Optional[str] ❌ Review date. None -
code_responsible Optional[str] ❌ Responsible code. None -
id_parent Optional[int] ❌ Father ID. None -
id_failure_type Optional[str] ❌ Failure type ID. None -
types_description Optional[str] ❌ Description of types. None -
id_failure_cause Optional[str] ❌ Failure cause ID. None -
causes_description Optional[str] ❌ Description of causes. None -
id_failure_detection_method Optional[str] ❌ ID detection method. None -
detection_method_description Optional[str] ❌ Detection method description. None -
id_failure_severity Optional[str] ❌ Failure severity ID. None -
severiry_description Optional[str] ❌ Description of severity. None -
id_damage_type Optional[str] ❌ Damage type ID. None -
damages_types_description Optional[str] ❌ Description of types of damage. None -
caused_damage Optional[str] ❌ Damage caused. None -
id_group_task Optional[str] ❌ Task group ID. None -
id_items_availability Optional[str] ❌ Item availability ID. None -
validated_by_description Optional[str] ❌ Validated by. None -
id_personnel_log Optional[int] ❌ Personnel log ID. None -
id_contacts_log Optional[str] ❌ Contact log ID. None -
id_personnel Optional[int] ❌ Personnel ID. None -
id_contact Optional[str] ❌ Contact ID. None -
id_company Optional[int] ❌ Company ID. None -
code_wo_related Optional[str] ❌ Related OT code. None -
parent_id_work_order Optional[int] ❌ ID of the parent OT. None -
parent_id_work_orders_tasks Optional[int] ❌ Parent task ID. None -
parent_id_task Optional[int] ❌ Parent task ID. None -
parent_id_item Optional[int] ❌ ID of the parent item/asset. None -
parent_id_status_work_order Optional[int] ❌ Parent state ID. None -
parent_wo_folio Optional[str] ❌ Father folio. None -
parent_creation_date Optional[str] ❌ Parent creation date. None -
parent_duration Optional[int] ❌ Estimated duration father. None -
parent_initial_date Optional[str] ❌ Parent initial date. None -
parent_id_priorities Optional[int] ❌ Parent priority ID. None -
parent_priorities_description Optional[str] ❌ Parent priority description. None -
parent_final_date Optional[str] ❌ Parent end date. None -
parent_completed_percentage Optional[int] ❌ Percent complete parent. None -
parent_created_by Optional[str] ❌ Created by father. None -
parent_signature Optional[str] ❌ Father signature. None -
parent_personnel_description Optional[str] ❌ Description of parent staff. None -
parent_personnel_path_image Optional[str] ❌ Parent staff image path. None -
parent_code Optional[str] ❌ Parent code. None -
parent_items_log_description Optional[str] ❌ Description of the parent log. None -
parent_done Optional[bool] ❌ Indicates if it is completed father. None -
parent_id_request Optional[str] ❌ Parent request ID. None -
parent_stop_assets Optional[bool] ❌ Parent asset stop. None -
parent_stop_assets_sec Optional[str] ❌ Stop seconds father. None -
parent_tasks_log_task_type_main Optional[str] ❌ Parent main type. None -
parent_parent_description Optional[str] ❌ Description of the father's father. None -
parent_trigger_description Optional[str] ❌ Description of the parent trigger. None -
parent_resources_hours Optional[str] ❌ Father Hours Resources. None -
parent_resources_inventory Optional[str] ❌ Parent inventory resources. None -
parent_resources_human_resources Optional[str] ❌ Human resources father. None -
parent_resources_services Optional[str] ❌ Parent Services Resources. None -
parent_cal_date_maintenance Optional[str] ❌ Calculated maintenance date parent. None -
parent_real_duration Optional[int] ❌ Actual duration father. None -
parent_date_maintenance Optional[str] ❌ Parent maintenance date. None -
parent_user_assigned Optional[str] ❌ Parent assigned user. None -
parent_note Optional[str] ❌ Father note. None -
parent_details_signature Optional[str] ❌ Father details signature. None -
parent_responsible_path_signature Optional[str] ❌ Signature route of the responsible father. None -
parent_validator_path_signature Optional[str] ❌ Signature path of the parent validator. None -
parent_first_date_task Optional[str] ❌ First task date parent. None -
parent_costs_center_description Optional[str] ❌ Parent cost center. None -
parent_tasks_duration Optional[int] ❌ Parent task duration. None -
parent_total_cost_task Optional[str] ❌ Total cost father. None -
parent_requested_by Optional[str] ❌ Requested by father. None -
parent_groups_description Optional[str] ❌ Parent group. None -
parent_groups_1_description Optional[str] ❌ Group 1 father. None -
parent_groups_2_description Optional[str] ❌ Group 2 father. None -
parent_task_note Optional[str] ❌ Parent homework note. None -
parent_id_parent_wo Optional[str] ❌ Parent OT ID of the parent. None -
parent_has_children Optional[bool] ❌ Father has children. None -
parent_real_stop_assets_sec Optional[str] ❌ Real stop seconds father. None -
parent_wo_final_date Optional[str] ❌ Parent OT end date. None -
parent_is_offline Optional[str] ❌ It's offline father. None -
parent_tasks_log_types_description Optional[str] ❌ Description of parent types. None -
parent_tasks_log_types_2_description Optional[str] ❌ Description of types 2 parent. None -
parent_code_create_by Optional[str] ❌ Parent creator code. None -
parent_event_date Optional[str] ❌ Parent event date. None -
parent_rating Optional[str] ❌ Parent rating. None -
parent_enable_budget Optional[str] ❌ Enable parent budget. None -
parent_work_orders_status_custom_description Optional[str] ❌ Parent custom state. None -
parent_review_date Optional[str] ❌ Parent revision date. None -
parent_code_responsible Optional[str] ❌ Responsible parent code. None -
parent_id_parent Optional[int] ❌ Parent ID of the parent. None -
parent_id_failure_type Optional[str] ❌ Parent fault type ID. None -
parent_types_description Optional[str] ❌ Description of parent types. None -
parent_id_failure_cause Optional[str] ❌ Parent failure cause ID. None -
parent_causes_description Optional[str] ❌ Description of parent causes. None -
parent_id_failure_detection_method Optional[str] ❌ ID parent detection method. None -
parent_detection_method_description Optional[str] ❌ Description parent detection method. None -
parent_id_failure_severity Optional[str] ❌ Parent fault severity ID. None -
parent_severiry_description Optional[str] ❌ Father severity description. None -
parent_id_damage_type Optional[str] ❌ ID parent damage type. None -
parent_damages_types_description Optional[str] ❌ Description of types of parent damage. None -
parent_caused_damage Optional[str] ❌ Damage caused father. None -
parent_id_group_task Optional[str] ❌ Parent task group ID. None -
parent_id_items_availability Optional[str] ❌ ID availability of parent items. None -
parent_validated_by_description Optional[str] ❌ Validated by parent. None -
parent_id_personnel_log Optional[int] ❌ Parent personnel log ID. None -
parent_id_contacts_log Optional[str] ❌ Parent contact log ID. None -
parent_id_personnel Optional[int] ❌ Parent staff ID. None -
parent_id_contact Optional[str] ❌ Parent contact ID. None -
parent_id_company Optional[int] ❌ Parent company ID. None -
parent_code_wo_related Optional[str] ❌ Parent related OT code. None -

Notes:

All fields are optional.