List Work Requests By Items
Displays work requests with asset information.
General information:
| Module | Category |
|---|---|
Work Request |
Read |
Molecule details
Input schema:
| Field | Type | Required | Description | Default value | Examples |
|---|---|---|---|---|---|
description |
Optional[str] | ❌ | Description of the job application. | None |
- |
accounts_email |
Optional[str] | ❌ | Email of the account associated with the request. | None |
- |
accounts_name |
Optional[str] | ❌ | Name of the account associated with the request. | None |
- |
code_item |
Optional[str] | ❌ | Related item code. | None |
- |
date |
Optional[str] | ❌ | Request creation date. | None |
- |
date_incident |
Optional[str] | ❌ | Date of the reported incident. | None |
- |
date_maintenance |
Optional[str] | ❌ | Scheduled maintenance date. | None |
- |
date_solution |
Optional[str] | ❌ | Application resolution date. | None |
- |
date_status |
Optional[str] | ❌ | Date of last status change. | None |
- |
email_requested_by |
Optional[str] | ❌ | Email of the person requesting the order. | None |
- |
geolocation |
Optional[str] | ❌ | Geolocation associated with the request. | None |
- |
id_account |
Optional[int] | ❌ | Associated account ID. | None |
- |
id_code |
Optional[int] | ❌ | Related code ID. | None |
- |
id_company |
Optional[int] | ❌ | Company ID. | None |
- |
id_contacts_log |
Optional[str] | ❌ | Contact ID in the log. | None |
- |
id_group_task |
Optional[int] | ❌ | Task group ID. | None |
- |
id_item |
Optional[int] | ❌ | ID of the related item. | None |
- |
id_item_log |
Optional[int] | ❌ | ID of the item in the log. | None |
- |
id_personnel_log |
Optional[int] | ❌ | Personnel ID in the log. | None |
- |
id_priority |
Optional[str] | ❌ | ID of the assigned priority. | None |
- |
id_requests_x_status |
Optional[int] | ❌ | ID of the request-state relationship. | None |
- |
id_status |
Optional[int] | ❌ | ID of the current state. | None |
- |
id_type |
Optional[int] | ❌ | ID of the request type. | None |
- |
id_type_1 |
Optional[int] | ❌ | Type 1 ID. | None |
- |
id_type_2 |
Optional[int] | ❌ | Type 2 ID. | None |
- |
id_user |
Optional[int] | ❌ | ID of the associated user. | None |
- |
id_work_order |
Optional[int] | ❌ | ID of the generated work order. | None |
- |
identifier |
Optional[str] | ❌ | Unique identifier of the request. | None |
- |
is_urgent |
Optional[bool] | ❌ | Indicates if the request is urgent. | None |
- |
items_description |
Optional[str] | ❌ | Description of the associated items. | None |
- |
observation |
Optional[str] | ❌ | Additional observations. | None |
- |
parent_description |
Optional[str] | ❌ | Description of the parent element. | None |
- |
priorities_description |
Optional[str] | ❌ | Description of priority. | None |
- |
rating |
Optional[int] | ❌ | Rating assigned to the request. | None |
- |
rating_notes |
Optional[str] | ❌ | Notes on grading. | None |
- |
requested_by |
Optional[str] | ❌ | Name of the person requesting the order. | None |
- |
requests_x_key_words_descriptions |
Optional[str] | ❌ | Associated keyword descriptions. | None |
- |
requests_x_key_words_id_key_words |
Optional[str] | ❌ | Associated keyword IDs. | None |
- |
requests_x_status_accounts_name |
Optional[str] | ❌ | Account name in the application status. | None |
- |
requests_x_status_description |
Optional[str] | ❌ | Description of the request status. | None |
- |
requests_x_status_notes |
Optional[str] | ❌ | Application status notes. | None |
- |
status_path_image |
Optional[str] | ❌ | State image path. | None |
- |
types_1_description |
Optional[str] | ❌ | Description of type 1. | None |
- |
types_2_description |
Optional[str] | ❌ | Description of type 2. | None |
- |
types_color |
Optional[str] | ❌ | Color associated with the type. | None |
- |
types_description |
Optional[str] | ❌ | General description of the type. | None |
- |
visible_to_all |
Optional[bool] | ❌ | Indicates whether the request is visible to everyone. | None |
- |
item_id |
Optional[int] | ❌ | Item ID. | None |
- |
item_active |
Optional[bool] | ❌ | Indicates if the item is active. | None |
- |
item_code |
Optional[str] | ❌ | Item code. | None |
- |
item_description |
Optional[str] | ❌ | Item description. | None |
- |
item_id_type_item |
Optional[int] | ❌ | ID of the item type. | None |
- |
item_barcode |
Optional[str] | ❌ | Item barcode. | None |
- |
item_field_1 |
Optional[str] | ❌ | Custom field 1 of the item. | None |
- |
item_field_2 |
Optional[str] | ❌ | Item custom field 2. | None |
- |
item_field_3 |
Optional[str] | ❌ | Item custom field 3. | None |
- |
item_field_4 |
Optional[str] | ❌ | Item custom field 4. | None |
- |
item_field_5 |
Optional[str] | ❌ | Item custom field 5. | None |
- |
item_field_6 |
Optional[str] | ❌ | Custom field 6 of the item. | None |
- |
item_notes |
Optional[str] | ❌ | Item notes. | None |
- |
item_min_stock_warning |
Optional[str] | ❌ | Minimum warning stock. | None |
- |
item_weight |
Optional[str] | ❌ | Item weight. | None |
- |
item_is_serial_control |
Optional[bool] | ❌ | Indicates whether the item has serial control. | None |
- |
item_lead_time |
Optional[str] | ❌ | Item delivery time. | None |
- |
item_items_types_description |
Optional[str] | ❌ | Description of the item type. | None |
- |
item_groups_description |
Optional[str] | ❌ | Description of the item group. | None |
- |
item_groups_1_description |
Optional[str] | ❌ | Description of item group 1. | None |
- |
item_groups_2_description |
Optional[str] | ❌ | Description of item group 2. | None |
- |
item_custom_fields_groups_description |
Optional[str] | ❌ | Description of custom field groups. | None |
- |
item_units_description |
Optional[str] | ❌ | Description of the unit of measurement. | None |
- |
item_priorities_description |
Optional[str] | ❌ | Description of the item's priority. | None |
- |
item_parent_description |
Optional[str] | ❌ | Description of the parent item. | None |
- |
item_purchase_date |
Optional[str] | ❌ | Purchase date of the item. | None |
- |
item_total_cost |
Optional[str] | ❌ | Total cost of the item. | None |
- |
item_anual_depreciation |
Optional[str] | ❌ | Annual depreciation of the item. | 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 of the item. | None |
- |
item_latitude |
Optional[str] | ❌ | Item location latitude. | None |
- |
item_longitud |
Optional[str] | ❌ | Item location length. | None |
- |
item_id_group_task |
Optional[int] | ❌ | Item task group ID. | None |
- |
item_groups_tasks_description |
Optional[str] | ❌ | Description of the task group. | None |
- |
item_units_code |
Optional[str] | ❌ | Measurement unit code. | None |
- |
item_custom_fields_values |
Optional[str] | ❌ | Custom field values. | None |
- |
item_third_parties_name |
Optional[str] | ❌ | Name of associated third parties. | None |
- |
item_id_parent |
Optional[str] | ❌ | ID of the parent item. | None |
- |
item_visible_to_all |
Optional[bool] | ❌ | Indicates whether the item is visible to everyone. | None |
- |
item_hours_average_daily_use |
Optional[str] | ❌ | Average hours of daily use. | None |
- |
item_available |
Optional[bool] | ❌ | Indicates if the item is available. | None |
- |
item_initial_date_out_of_service |
Optional[str] | ❌ | Initial date out of service. | None |
- |
item_last_final_date_available |
Optional[str] | ❌ | Last date available. | None |
- |
item_item_url |
Optional[str] | ❌ | Item URL. | None |
- |
item_id_company |
Optional[int] | ❌ | Company ID of the item. | None |
- |
wo_folio |
Optional[str] | ❌ | Work order folio. | None |
- |
work_order_cal_date_maintenance |
Optional[str] | ❌ | Calculated maintenance date. | None |
- |
work_order_caused_damage |
Optional[str] | ❌ | Damage caused. | None |
- |
work_order_causes_description |
Optional[str] | ❌ | Description of the causes. | None |
- |
work_order_code |
Optional[str] | ❌ | Work order code. | None |
- |
work_order_code_create_by |
Optional[str] | ❌ | Code of who created the order. | None |
- |
work_order_code_responsible |
Optional[str] | ❌ | Responsible code. | None |
- |
work_order_completed_percentage |
Optional[int] | ❌ | Percentage completed. | None |
- |
work_order_costs_center_description |
Optional[str] | ❌ | Description of the cost center. | None |
- |
work_order_created_by |
Optional[str] | ❌ | Created by. | None |
- |
work_order_creation_date |
Optional[str] | ❌ | Creation date. | None |
- |
work_order_damages_types_description |
Optional[str] | ❌ | Description of the type of damage. | None |
- |
work_order_date_maintenance |
Optional[str] | ❌ | Maintenance date. | None |
- |
work_order_description |
Optional[str] | ❌ | Description of the work order. | None |
- |
work_order_details_signature |
Optional[str] | ❌ | Signature details. | None |
- |
work_order_detection_method_description |
Optional[str] | ❌ | Description of the detection method. | None |
- |
work_order_done |
Optional[bool] | ❌ | Indicates whether the order is completed. | None |
- |
work_order_duration |
Optional[int] | ❌ | Estimated duration in minutes. | None |
- |
work_order_enable_budget |
Optional[str] | ❌ | Enable budget. | None |
- |
work_order_event_date |
Optional[str] | ❌ | Event date. | None |
- |
work_order_final_date |
Optional[str] | ❌ | End date. | None |
- |
work_order_first_date_task |
Optional[str] | ❌ | First task date. | None |
- |
work_order_groups_1_description |
Optional[str] | ❌ | Description of group 1. | None |
- |
work_order_groups_2_description |
Optional[str] | ❌ | Description of group 2. | None |
- |
work_order_groups_description |
Optional[str] | ❌ | Group description. | None |
- |
work_order_has_children |
Optional[bool] | ❌ | Indicates if it has child orders. | None |
- |
work_order_id_company |
Optional[int] | ❌ | Company ID. | None |
- |
work_order_id_contacts_log |
Optional[int] | ❌ | Contact ID in the log. | None |
- |
work_order_id_damage_type |
Optional[str] | ❌ | ID of the damage type. | None |
- |
work_order_id_failure_cause |
Optional[str] | ❌ | Failure cause ID. | None |
- |
work_order_id_failure_detection_method |
Optional[str] | ❌ | Failure detection method ID. | None |
- |
work_order_id_failure_severity |
Optional[str] | ❌ | Fault severity ID. | None |
- |
work_order_id_failure_type |
Optional[str] | ❌ | Failure type ID. | None |
- |
work_order_id_group_task |
Optional[str] | ❌ | Task group ID. | None |
- |
work_order_id_item |
Optional[int] | ❌ | ID of the associated item. | None |
- |
work_order_id_items_availability |
Optional[str] | ❌ | Item availability ID. | None |
- |
work_order_id_parent |
Optional[int] | ❌ | ID of the parent order. | None |
- |
work_order_id_parent_wo |
Optional[str] | ❌ | ID of the parent work order. | None |
- |
work_order_id_personnel_log |
Optional[str] | ❌ | Personnel ID in the log. | None |
- |
work_order_id_priorities |
Optional[int] | ❌ | Priority ID. | None |
- |
work_order_id_request |
Optional[int] | ❌ | ID of the associated request. | None |
- |
work_order_id_status_work_order |
Optional[int] | ❌ | Order status ID. | None |
- |
work_order_id_task |
Optional[int] | ❌ | Task ID. | None |
- |
work_order_id_work_order |
Optional[int] | ❌ | Work order ID. | None |
- |
work_order_id_work_orders_tasks |
Optional[int] | ❌ | ID of the order-task relationship. | None |
- |
work_order_initial_date |
Optional[str] | ❌ | Initial date. | None |
- |
work_order_is_offline |
Optional[bool] | ❌ | Indicates if it is offline. | None |
- |
work_order_items_log_description |
Optional[str] | ❌ | Description of the item in the log. | None |
- |
work_order_note |
Optional[str] | ❌ | Order note. | None |
- |
work_order_parent_description |
Optional[str] | ❌ | Description of the father. | None |
- |
work_order_personnel_description |
Optional[str] | ❌ | Staff description. | None |
- |
work_order_personnel_path_image |
Optional[str] | ❌ | Staff image path. | None |
- |
work_order_priorities_description |
Optional[str] | ❌ | Description of priority. | None |
- |
work_order_rating |
Optional[int] | ❌ | Order qualification. | None |
- |
work_order_real_duration |
Optional[int] | ❌ | Actual duration in minutes. | None |
- |
work_order_real_stop_assets_sec |
Optional[str] | ❌ | Real seconds of asset stoppage. | None |
- |
work_order_requested_by |
Optional[str] | ❌ | Requested by. | None |
- |
work_order_resources_hours |
Optional[str] | ❌ | Resource hours. | None |
- |
work_order_resources_human_resources |
Optional[str] | ❌ | Human resources. | None |
- |
work_order_resources_inventory |
Optional[str] | ❌ | Inventory resources. | None |
- |
work_order_resources_services |
Optional[str] | ❌ | Service resources. | None |
- |
work_order_responsible_path_signature |
Optional[str] | ❌ | Signature path of the person in charge. | None |
- |
work_order_review_date |
Optional[str] | ❌ | Review date. | None |
- |
work_order_severiry_description |
Optional[str] | ❌ | Description of severity. | None |
- |
work_order_signature |
Optional[str] | ❌ | Digital signature. | None |
- |
work_order_stop_assets |
Optional[bool] | ❌ | Indicates whether it stops assets. | None |
- |
work_order_stop_assets_sec |
Optional[str] | ❌ | Asset stop seconds. | None |
- |
work_order_task_note |
Optional[str] | ❌ | Homework note. | None |
- |
work_order_tasks_duration |
Optional[int] | ❌ | Duration of tasks in minutes. | None |
- |
work_order_tasks_log_task_type_main |
Optional[str] | ❌ | Main type of task in the log. | None |
- |
work_order_tasks_log_types_2_description |
Optional[str] | ❌ | Description of type 2 of task. | None |
- |
work_order_tasks_log_types_description |
Optional[str] | ❌ | Description of the type of task. | None |
- |
work_order_total_cost_task |
Optional[int] | ❌ | Total cost of the task. | None |
- |
work_order_trigger_description |
Optional[str] | ❌ | Trigger description. | None |
- |
work_order_types_description |
Optional[str] | ❌ | Description of the order type. | None |
- |
work_order_user_assigned |
Optional[str] | ❌ | Assigned user. | None |
- |
work_order_validated_by_description |
Optional[str] | ❌ | Validated by. | None |
- |
work_order_validator_path_signature |
Optional[str] | ❌ | Validator signing path. | None |
- |
work_order_wo_final_date |
Optional[str] | ❌ | End date of the order. | None |
- |
work_order_wo_folio |
Optional[str] | ❌ | Work order folio. | None |
- |
work_order_work_orders_status_custom_description |
Optional[str] | ❌ | Custom status description. | None |
- |
work_order_id_wo_related |
Optional[str] | ❌ | Related order ID. | None |
- |
work_order_code_wo_related |
Optional[str] | ❌ | Related order code. | None |
- |
Notes:
This model has a flattened structure where the item and work order fields use prefixes instead of nested objects.