List Tasks Todo By Items

View pending tasks and related work request information, flattening the data.

---

General information:

Module	Category
Task	query

---

Molecule details

Input schema:

Field	Type	Required	Description	Default value	Examples
description	Optional[str]	❌	Description of the task.	None	-
cal_date_maintenance	Optional[str]	❌	Calculated maintenance date.	None	-
code	Optional[str]	❌	Task code.	None	-
date_maintenance	Optional[str]	❌	Maintenance date.	None	-
delay	Optional[int]	❌	Days late.	None	-
duration	Optional[int]	❌	Estimated duration (minutes).	None	-
event_date	Optional[str]	❌	Date of the associated event.	None	-
group_task_description	Optional[str]	❌	Description of the task group.	None	-
id	Optional[int]	❌	Task ID.	None	-
id_company	Optional[int]	❌	Company ID.	None	-
id_group_task	Optional[int]	❌	Task group ID.	None	-
id_item	Optional[int]	❌	ID of the associated item.	None	-
id_request	Optional[int]	❌	ID of the associated request.	None	-
id_task	Optional[int]	❌	Task ID.	None	-
is_active	Optional[bool]	❌	Indicates whether the task is active.	None	-
item_description	Optional[str]	❌	Item description.	None	-
last_date_maintenance	Optional[str]	❌	Last maintenance date.	None	-
notes	Optional[str]	❌	Additional notes.	None	-
num_resources	Optional[int]	❌	Number of assigned resources.	None	-
parent_description	Optional[str]	❌	Description of the father.	None	-
id_priorities	Optional[int]	❌	Priority ID.	None	-
priorities_description	Optional[str]	❌	Description of priority.	None	-
replay_counter	Optional[int]	❌	Repetition counter.	None	-
replay_counter_cycles	Optional[str]	❌	Repetition cycles.	None	-
requested_by	Optional[str]	❌	Requested by.	None	-
task_failure	Optional[str]	❌	Failure associated with the task.	None	-
task_note	Optional[str]	❌	Homework note.	None	-
tasks_types_2_description	Optional[str]	❌	Type 2 description of the task.	None	-
tasks_types_description	Optional[str]	❌	Description of the type of task.	None	-
tasks_types_main_description	Optional[str]	❌	Main description of the type of task.	None	-
trigger_description	Optional[str]	❌	Trigger description.	None	-
visible_to_all	Optional[bool]	❌	Visible to everyone.	None	-
work_request_accounts_email	Optional[str]	❌	Email of the requesting account.	None	-
work_request_accounts_name	Optional[str]	❌	Name of the requesting account.	None	-
work_request_code_item	Optional[str]	❌	Item code in the request.	None	-
work_request_date	Optional[str]	❌	Application date.	None	-
work_request_date_incident	Optional[str]	❌	Date of incident on application.	None	-
work_request_date_maintenance	Optional[str]	❌	Maintenance date on the application.	None	-
work_request_date_solution	Optional[str]	❌	Solution date in the request.	None	-
work_request_date_status	Optional[str]	❌	Date of status change in the application.	None	-
work_request_description	Optional[str]	❌	Description of the request.	None	-
work_request_email_requested_by	Optional[str]	❌	Applicant email.	None	-
work_request_geolocation	Optional[str]	❌	Geolocation of the request.	None	-
work_request_id_account	Optional[int]	❌	ID of the account associated with the request.	None	-
work_request_id_code	Optional[int]	❌	Request code ID.	None	-
work_request_id_company	Optional[int]	❌	Company ID on the application.	None	-
work_request_id_contacts_log	Optional[int]	❌	Contact log ID in the request.	None	-
work_request_id_group_task	Optional[int]	❌	Task group ID in the request.	None	-
work_request_id_item	Optional[int]	❌	ID of the item in the request.	None	-
work_request_id_item_log	Optional[int]	❌	Item log ID in the request.	None	-
work_request_id_personnel_log	Optional[int]	❌	Personnel log ID in the request.	None	-
work_request_id_priority	Optional[int]	❌	Priority ID in the request.	None	-
work_request_id_requests_x_status	Optional[int]	❌	Cross status ID in the request.	None	-
work_request_id_status	Optional[int]	❌	Status ID in the request.	None	-
work_request_id_type	Optional[int]	❌	Type ID in the request.	None	-
work_request_id_type_1	Optional[int]	❌	Type 1 ID in the request.	None	-
work_request_id_type_2	Optional[int]	❌	Type 2 ID in the request.	None	-
work_request_id_user	Optional[int]	❌	User ID in the request.	None	-
work_request_id_work_order	Optional[int]	❌	OT ID in the request.	None	-
work_request_identifier	Optional[str]	❌	Request identifier.	None	-
work_request_is_urgent	Optional[bool]	❌	Indicates if the request is urgent.	None	-
work_request_items_description	Optional[str]	❌	Description of items in the application.	None	-
work_request_observation	Optional[str]	❌	Observations of the application.	None	-
work_request_parent_description	Optional[str]	❌	Father's description on the application.	None	-
work_request_priorities_description	Optional[str]	❌	Description of priority in the application.	None	-
work_request_rating	Optional[str]	❌	Application qualification.	None	-
work_request_rating_notes	Optional[str]	❌	Application qualification notes.	None	-
work_request_requested_by	Optional[str]	❌	Requested by in the application.	None	-
work_request_requests_x_key_words_descriptions	Optional[str]	❌	Keyword descriptions in the application.	None	-
work_request_requests_x_key_words_id_key_words	Optional[str]	❌	Keyword IDs in the request.	None	-
work_request_requests_x_status_accounts_name	Optional[str]	❌	Cross status account name in the request.	None	-
work_request_requests_x_status_description	Optional[str]	❌	Description of cross status in the request.	None	-
work_request_requests_x_status_notes	Optional[str]	❌	Cross status notes on the application.	None	-
work_request_status_path_image	Optional[str]	❌	State image path in the request.	None	-
work_request_types_1_description	Optional[str]	❌	Description type 1 of the request.	None	-
work_request_types_2_description	Optional[str]	❌	Type 2 description of the request.	None	-
work_request_types_color	Optional[str]	❌	Request type color.	None	-
work_request_types_description	Optional[str]	❌	Description of the type of request.	None	-
work_request_visible_to_all	Optional[bool]	❌	Application visible to everyone.	None	-
work_request_wo_folio	Optional[str]	❌	OT folio in the application.	None	-

Notes:

All fields are optional and reflect the output schema.

Related: