Skip to content

List Work Orders With Subtasks By Items

Obtains the subtasks of each OT with information from the OT (flattened 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_order_task Optional[int] ❌ OT Task ID. None -
id_work_orders_tasks_form_items Optional[int] ❌ Item ID of the task form. None -
value Optional[str] ❌ Worth. None -
unit_description Optional[str] ❌ Unit description. None -
units_code Optional[str] ❌ Units code. None -
order_number Optional[int] ❌ Order number. None -
is_required Optional[bool] ❌ It is required. None -
meter_description Optional[str] ❌ Description of the meter. None -
last_value Optional[str] ❌ Last value. None -
wo_folio Optional[str] ❌ Folio of OT. None -
creation_date Optional[str] ❌ Creation date. None -
id_status_work_order Optional[int] ❌ OT status ID. None -
id_task_form_item_type Optional[int] ❌ Item type ID of the task form. None -
group Optional[str] ❌ Cluster. None -
id_company Optional[int] ❌ Company ID. None -
work_order_id_work_order Optional[int] ❌ OT ID. None -
work_order_id_work_orders_tasks Optional[int] ❌ OT task ID. None -
work_order_id_task Optional[int] ❌ Task ID. None -
work_order_id_item Optional[int] ❌ Item/asset ID. None -
work_order_id_status_work_order Optional[int] ❌ OT status ID. None -
work_order_wo_folio Optional[str] ❌ Folio of the OT. None -
work_order_creation_date Optional[str] ❌ Creation date. None -
work_order_duration Optional[int] ❌ Estimated duration. None -
work_order_initial_date Optional[str] ❌ Initial date. None -
work_order_id_priorities Optional[int] ❌ Priority ID. None -
work_order_priorities_description Optional[str] ❌ Priority description. None -
work_order_final_date Optional[str] ❌ End date. None -
work_order_completed_percentage Optional[int] ❌ Percentage completed. None -
work_order_created_by Optional[str] ❌ Created by. None -
work_order_signature Optional[str] ❌ Signature. None -
work_order_personnel_description Optional[str] ❌ Staff description. None -
work_order_personnel_path_image Optional[str] ❌ Staff image path. None -
work_order_code Optional[str] ❌ Code. None -
work_order_items_log_description Optional[str] ❌ Description of the item log. None -
work_order_done Optional[bool] ❌ Indicates if it is completed. None -
work_order_description Optional[str] ❌ Description. None -
work_order_id_request Optional[str] ❌ Request ID. None -
work_order_stop_assets Optional[bool] ❌ Asset stoppage. None -
work_order_stop_assets_sec Optional[int] ❌ Stop seconds. None -
work_order_tasks_log_task_type_main Optional[str] ❌ Main type of log task. None -
work_order_parent_description Optional[str] ❌ Description of the father. None -
work_order_trigger_description Optional[str] ❌ Trigger description. None -
work_order_resources_hours Optional[str] ❌ Hour resources. None -
work_order_resources_inventory Optional[str] ❌ Inventory resources. None -
work_order_resources_human_resources Optional[str] ❌ Human resources. None -
work_order_resources_services Optional[str] ❌ Service resources. None -
work_order_cal_date_maintenance Optional[str] ❌ Calculated maintenance date. None -
work_order_real_duration Optional[str] ❌ Actual duration. None -
work_order_date_maintenance Optional[str] ❌ Maintenance date. None -
work_order_user_assigned Optional[str] ❌ Assigned user. None -
work_order_note Optional[str] ❌ Note. None -
work_order_details_signature Optional[str] ❌ Signature details. None -
work_order_responsible_path_signature Optional[str] ❌ Route signature of the person in charge. None -
work_order_validator_path_signature Optional[str] ❌ Validator signature path. None -
work_order_first_date_task Optional[str] ❌ First task date. None -
work_order_costs_center_description Optional[str] ❌ Description of the cost center. None -
work_order_tasks_duration Optional[int] ❌ Duration of tasks. None -
work_order_total_cost_task Optional[str] ❌ Total task cost. None -
work_order_requested_by Optional[str] ❌ Requested by. None -
work_order_groups_description Optional[str] ❌ Group description. None -
work_order_groups_1_description Optional[str] ❌ Group description 1. None -
work_order_groups_2_description Optional[str] ❌ Group description 2. None -
work_order_task_note Optional[str] ❌ Homework note. None -
work_order_id_parent_wo Optional[str] ❌ Parent OT ID. None -
work_order_has_children Optional[bool] ❌ He has children. None -
work_order_real_stop_assets_sec Optional[int] ❌ Actual stop seconds. None -
work_order_wo_final_date Optional[str] ❌ OT end date. None -
work_order_is_offline Optional[str] ❌ It's offline. None -
work_order_tasks_log_types_description Optional[str] ❌ Description of log types. None -
work_order_tasks_log_types_2_description Optional[str] ❌ Description of log types 2. None -
work_order_code_create_by Optional[str] ❌ Creator code. None -
work_order_event_date Optional[str] ❌ Event date. None -
work_order_rating Optional[str] ❌ Qualification. None -
work_order_enable_budget Optional[bool] ❌ Enable budget. None -
work_order_work_orders_status_custom_description Optional[str] ❌ Custom status description. None -
work_order_review_date Optional[str] ❌ Review date. None -
work_order_code_responsible Optional[str] ❌ Responsible code. None -
work_order_id_parent Optional[int] ❌ Father ID. None -
work_order_id_failure_type Optional[str] ❌ Failure type ID. None -
work_order_types_description Optional[str] ❌ Description of types. None -
work_order_id_failure_cause Optional[str] ❌ Failure cause ID. None -
work_order_causes_description Optional[str] ❌ Description of causes. None -
work_order_id_failure_detection_method Optional[str] ❌ ID fault detection method. None -
work_order_detection_method_description Optional[str] ❌ Description of the detection method. None -
work_order_id_failure_severity Optional[str] ❌ Failure severity ID. None -
work_order_severiry_description Optional[str] ❌ Description of severity. None -
work_order_id_damage_type Optional[str] ❌ Damage type ID. None -
work_order_damages_types_description Optional[str] ❌ Description of types of damage. None -
work_order_caused_damage Optional[str] ❌ Damage caused. None -
work_order_id_group_task Optional[int] ❌ Task group ID. None -
work_order_id_items_availability Optional[str] ❌ Item availability ID. None -
work_order_validated_by_description Optional[str] ❌ Description of the validator. None -
work_order_id_personnel_log Optional[int] ❌ Personnel log ID. None -
work_order_id_contacts_log Optional[str] ❌ Contact log ID. None -
work_order_id_personnel Optional[int] ❌ Personnel ID. None -
work_order_id_contact Optional[str] ❌ Contact ID. None -
work_order_id_company Optional[int] ❌ Company ID. None -
work_order_item_id Optional[int] ❌ Item ID. None -
work_order_item_active Optional[bool] ❌ Active state. None -
work_order_item_code Optional[str] ❌ Item code. None -
work_order_item_description Optional[str] ❌ Item description. None -
work_order_item_id_type_item Optional[int] ❌ Item type ID. None -
work_order_item_barcode Optional[str] ❌ Bar-code. None -
work_order_item_field_1 Optional[str] ❌ Custom field 1. None -
work_order_item_field_2 Optional[str] ❌ Custom field 2. None -
work_order_item_field_3 Optional[str] ❌ Custom field 3. None -
work_order_item_field_4 Optional[str] ❌ Custom field 4. None -
work_order_item_field_5 Optional[str] ❌ Custom field 5. None -
work_order_item_field_6 Optional[str] ❌ Custom field 6. None -
work_order_item_notes Optional[str] ❌ Item notes. None -
work_order_item_min_stock_warning Optional[str] ❌ Minimum stock warning. None -
work_order_item_weight Optional[str] ❌ Weight. None -
work_order_item_is_serial_control Optional[bool] ❌ Standard control. None -
work_order_item_lead_time Optional[str] ❌ Delivery time. None -
work_order_item_items_types_description Optional[str] ❌ Description of the item type. None -
work_order_item_groups_description Optional[str] ❌ Group description. None -
work_order_item_groups_1_description Optional[str] ❌ Description of group 1. None -
work_order_item_groups_2_description Optional[str] ❌ Description of group 2. None -
work_order_item_custom_fields_groups_description Optional[str] ❌ Description of the custom field group. None -
work_order_item_units_description Optional[str] ❌ Description of units. None -
work_order_item_priorities_description Optional[str] ❌ Priority description. None -
work_order_item_parent_description Optional[str] ❌ Description of the father. None -
work_order_item_purchase_date Optional[str] ❌ Purchase date. None -
work_order_item_total_cost Optional[int] ❌ Total cost. None -
work_order_item_anual_depreciation Optional[str] ❌ Annual depreciation. None -
work_order_item_startup_date Optional[str] ❌ Startup date. None -
work_order_item_total_replacement_cost Optional[int] ❌ Total replacement cost. None -
work_order_item_salvage_value Optional[int] ❌ Salvage value. None -
work_order_item_costs_center_description Optional[str] ❌ Description of the cost center. None -
work_order_item_budgets_description Optional[str] ❌ Budget description. None -
work_order_item_cost_average Optional[str] ❌ Average cost. None -
work_order_item_latitude Optional[str] ❌ Latitude. None -
work_order_item_longitud Optional[str] ❌ Length. None -
work_order_item_id_group_task Optional[int] ❌ Task group ID. None -
work_order_item_groups_tasks_description Optional[str] ❌ Description of the task group. None -
work_order_item_units_code Optional[str] ❌ Units code. None -
work_order_item_custom_fields_values Optional[str] ❌ Custom field values. None -
work_order_item_third_parties_name Optional[str] ❌ Name of the third party. None -
work_order_item_id_parent Optional[int] ❌ Father ID. None -
work_order_item_visible_to_all Optional[bool] ❌ Visible to everyone. None -
work_order_item_hours_average_daily_use Optional[int] ❌ Average hours of daily use. None -
work_order_item_available Optional[bool] ❌ Available. None -
work_order_item_initial_date_out_of_service Optional[str] ❌ Initial date out of service. None -
work_order_item_last_final_date_available Optional[str] ❌ Last available end date. None -
work_order_item_item_url Optional[str] ❌ Item URL. None -
work_order_item_id_company Optional[int] ❌ Company ID of the item. None -

Notes:

All fields are optional.