Skip to content

List Work Orders By Items

Shows work orders with asset information and flattened json (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 -
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[str] ❌ 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[str] ❌ 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[bool] ❌ 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[bool] ❌ 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[str] ❌ 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_company Optional[int] ❌ Company ID. None -
item_id Optional[int] ❌ Item ID. None -
item_active Optional[bool] ❌ Asset. None -
item_code Optional[str] ❌ Item code. None -
item_description Optional[str] ❌ Item description. None -
item_id_type_item Optional[int] ❌ Item type ID. None -
item_barcode Optional[str] ❌ Bar-code. None -
item_field_1 Optional[str] ❌ Custom field 1. None -
item_field_2 Optional[str] ❌ Custom field 2. None -
item_field_3 Optional[str] ❌ Custom field 3. None -
item_field_4 Optional[str] ❌ Custom field 4. None -
item_field_5 Optional[str] ❌ Custom field 5. None -
item_field_6 Optional[str] ❌ Custom field 6. None -
item_notes Optional[str] ❌ Item notes. None -
item_min_stock_warning Optional[str] ❌ Minimum stock warning. None -
item_weight Optional[str] ❌ Weight. None -
item_is_serial_control Optional[bool] ❌ Standard control. None -
item_lead_time Optional[str] ❌ Delivery time. None -
item_items_types_description Optional[str] ❌ Type description. None -
item_groups_description Optional[str] ❌ Group description. None -
item_groups_1_description Optional[str] ❌ Description of group 1. None -
item_groups_2_description Optional[str] ❌ Description of group 2. None -
item_custom_fields_groups_description Optional[str] ❌ Custom field group description. None -
item_units_description Optional[str] ❌ Description of units. None -
item_priorities_description Optional[str] ❌ Priority description. None -
item_parent_description Optional[str] ❌ Description of the father. None -
item_purchase_date Optional[str] ❌ Purchase date. None -
item_total_cost Optional[str] ❌ Total cost. None -
item_anual_depreciation Optional[str] ❌ Annual depreciation. None -
item_startup_date Optional[str] ❌ Startup date. None -
item_total_replacement_cost Optional[str] ❌ Total replacement cost. None -
item_salvage_value Optional[str] ❌ Salvage value. None -
item_costs_center_description Optional[str] ❌ Description of the cost center. None -
item_budgets_description Optional[str] ❌ Budget description. None -
item_cost_average Optional[str] ❌ Average cost. None -
item_latitude Optional[str] ❌ Latitude. None -
item_longitud Optional[str] ❌ Length. None -
item_id_group_task Optional[int] ❌ Task group ID. None -
item_groups_tasks_description Optional[str] ❌ Description of the task group. None -
item_units_code Optional[str] ❌ Units code. None -
item_custom_fields_values Optional[str] ❌ Custom field values. None -
item_third_parties_name Optional[str] ❌ Name of the third party. None -
item_id_parent Optional[str] ❌ Father ID. None -
item_visible_to_all Optional[bool] ❌ Visible to everyone. None -
item_hours_average_daily_use Optional[str] ❌ Average hours of daily use. None -
item_available Optional[bool] ❌ Available. None -
item_initial_date_out_of_service Optional[str] ❌ Initial date out of service. None -
item_last_final_date_available Optional[str] ❌ Last available end date. None -
item_item_url Optional[str] ❌ Item URL. None -
item_id_company Optional[int] ❌ Company ID of the item. None -
id_wo_related Optional[str] ❌ Related OT ID. None -
code_wo_related Optional[str] ❌ Related OT code. None -
work_request_id_code Optional[int] ❌ ID request code. None -
work_request_id_company Optional[int] ❌ Request company ID. None -
work_request_id_work_order Optional[int] ❌ Request OT ID. None -
work_request_date Optional[str] ❌ Application date. None -
work_request_id_type Optional[int] ❌ Request type ID. None -
work_request_id_item Optional[int] ❌ Request item ID. None -
work_request_is_urgent Optional[bool] ❌ It's urgent. None -
work_request_description Optional[str] ❌ Request description. None -
work_request_rating Optional[str] ❌ Application qualification. None -
work_request_rating_notes Optional[str] ❌ Qualification notes. None -
work_request_observation Optional[str] ❌ Observation. None -
work_request_date_solution Optional[str] ❌ Solution date. None -
work_request_types_description Optional[str] ❌ Type description. None -
work_request_items_description Optional[str] ❌ Item description. None -
work_request_id_requests_x_status Optional[int] ❌ Request IDs by status. None -
work_request_id_status Optional[int] ❌ Status ID. None -
work_request_date_status Optional[str] ❌ Status date. None -
work_request_requests_x_status_notes Optional[str] ❌ Status notes. None -
work_request_requests_x_status_description Optional[str] ❌ State description. None -
work_request_status_path_image Optional[str] ❌ State image path. None -
work_request_accounts_name Optional[str] ❌ Account name. None -
work_request_accounts_email Optional[str] ❌ Account email. None -
work_request_requests_x_key_words_descriptions Optional[str] ❌ Keyword descriptions. None -
work_request_requests_x_key_words_id_key_words Optional[int] ❌ Keyword IDs. None -
work_request_wo_folio Optional[str] ❌ Folio of OT. None -
work_request_date_incident Optional[str] ❌ Date of the incident. None -
work_request_parent_description Optional[str] ❌ Description of the father. None -
work_request_requests_x_status_accounts_name Optional[str] ❌ State account name. None -
work_request_requested_by Optional[str] ❌ Requested by. None -
work_request_id_type_1 Optional[int] ❌ ID type 1. None -
work_request_id_type_2 Optional[int] ❌ ID type 2. None -
work_request_types_1_description Optional[str] ❌ Description type 1. None -
work_request_types_2_description Optional[str] ❌ Description type 2. None -
work_request_identifier Optional[str] ❌ Identifier. None -
work_request_id_personnel_log Optional[int] ❌ Personnel log ID. None -
work_request_id_contacts_log Optional[int] ❌ Contact log ID. None -
work_request_id_account Optional[int] ❌ Account ID. None -
work_request_geolocation Optional[str] ❌ Geolocation. None -
work_request_id_user Optional[int] ❌ User ID. None -
work_request_date_maintenance Optional[str] ❌ Maintenance date. None -
work_request_types_color Optional[str] ❌ Type color. None -
work_request_id_group_task Optional[int] ❌ Task group ID. None -
work_request_id_item_log Optional[int] ❌ Item log ID. None -
work_request_visible_to_all Optional[bool] ❌ Visible to everyone. None -
work_request_id_priority Optional[int] ❌ Priority ID. None -
work_request_priorities_description Optional[str] ❌ Priority description. None -
work_request_email_requested_by Optional[str] ❌ Applicant email. None -
work_request_code_item Optional[str] ❌ Item code. None -
work_request_annotations_id_related Optional[str] ❌ Annotation related ID. None -
work_request_annotations_code_related Optional[str] ❌ Related annotation code. None -
task_todo_id Optional[int] ❌ Pending task ID. None -
task_todo_code Optional[str] ❌ Task code. None -
task_todo_delay Optional[int] ❌ Delay. None -
task_todo_notes Optional[str] ❌ Grades. None -
task_todo_id_item Optional[int] ❌ Item ID. None -
task_todo_id_task Optional[int] ❌ Task ID. None -
task_todo_duration Optional[int] ❌ Duration. None -
task_todo_id_group Optional[int] ❌ Group ID. None -
task_todo_wo_folio Optional[str] ❌ Folio of OT. None -
task_todo_is_active Optional[bool] ❌ It is active. None -
task_todo_show_todo Optional[bool] ❌ Show pending. None -
task_todo_task_note Optional[str] ❌ Homework note. None -
task_todo_event_date Optional[str] ❌ Event date. None -
task_todo_id_company Optional[int] ❌ Company ID. None -
task_todo_id_group_1 Optional[int] ❌ Group ID 1. None -
task_todo_id_group_2 Optional[int] ❌ Group ID 2. None -
task_todo_id_request Optional[int] ❌ Request ID. None -
task_todo_description Optional[str] ❌ Description. None -
task_todo_is_cyclical Optional[bool] ❌ It is cyclical. None -
task_todo_stop_assets Optional[bool] ❌ Asset stoppage. None -
task_todo_id_task_type Optional[int] ❌ Task type ID. None -
task_todo_id_type_item Optional[int] ❌ Item type ID. None -
task_todo_requested_by Optional[str] ❌ Requested by. None -
task_todo_id_group_task Optional[int] ❌ Task group ID. None -
task_todo_id_priorities Optional[int] ❌ Priority ID. None -
task_todo_num_resources Optional[int] ❌ Number of resources. None -
task_todo_cc_description Optional[str] ❌ Cost center description. None -
task_todo_id_cost_center Optional[int] ❌ Cost center ID. None -
task_todo_id_task_type_2 Optional[int] ❌ Task type ID 2. None -
task_todo_num_iterations Optional[str] ❌ Number of iterations. None -
task_todo_replay_counter Optional[int] ❌ Repetition counter. None -
task_todo_visible_to_all Optional[bool] ❌ Visible to everyone. None -
task_todo_cfg_description Optional[str] ❌ Configuration description. None -
task_todo_id_task_trigger Optional[int] ❌ Task trigger ID. None -
task_todo_stop_assets_sec Optional[str] ❌ Asset stop seconds. None -
task_todo_date_maintenance Optional[str] ❌ Maintenance date. None -
task_todo_item_description Optional[str] ❌ Item description. None -
task_todo_item_id_priority Optional[int] ❌ Item priority ID. None -
task_todo_id_task_type_main Optional[int] ❌ Main task type ID. None -
task_todo_groups_description Optional[str] ❌ Group description. None -
task_todo_id_work_order_task Optional[int] ❌ OT task ID. None -
task_todo_parent_description Optional[str] ❌ Description of the father. None -
task_todo_trigger_description Optional[str] ❌ Trigger description. None -
task_todo_cal_date_maintenance Optional[str] ❌ Calculated maintenance date. None -
task_todo_custom_fields_values Optional[str] ❌ Custom field values. None -
task_todo_groups_1_description Optional[str] ❌ Group description 1. None -
task_todo_groups_2_description Optional[str] ❌ Group description 2. None -
task_todo_id_status_work_order Optional[int] ❌ OT status ID. None -
task_todo_id_custom_field_group Optional[int] ❌ Custom field group ID. None -
task_todo_id_items_availability Optional[int] ❌ Item availability ID. None -
task_todo_items_log_description Optional[str] ❌ Description of the item log. None -
task_todo_items_log_id_priority Optional[int] ❌ Item log priority ID. None -
task_todo_last_date_maintenance Optional[str] ❌ Last maintenance date. None -
task_todo_replay_counter_cycles Optional[str] ❌ Repetition counter cycles. None -
task_todo_first_date_maintenance Optional[str] ❌ First maintenance date. None -
task_todo_group_task_description Optional[str] ❌ Description of the task group. None -
task_todo_priorities_description Optional[str] ❌ Priority description. None -
task_todo_tasks_types_description Optional[str] ❌ Description of task types. None -
task_todo_tasks_log_task_type_main Optional[str] ❌ Main type of log task. None -
task_todo_tasks_types_2_description Optional[str] ❌ Description of task types 2. None -
task_todo_tasks_log_types_description Optional[str] ❌ Description of log types. None -
task_todo_tasks_types_main_description Optional[str] ❌ Description of main types. None -
task_todo_tasks_log_types_2_description Optional[str] ❌ Description of log types 2. None -
task_todo_id_task_todo_related Optional[str] ❌ Related to-do ID. None -

Notes:

All fields are optional.