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.

Related: