ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.create_task_with_subject_project_priority_dept
Goal: create a new task with to the movies for subject, Fly for project, Medium for priority, and Marketing for department
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="to the movies" AND t.priority="Medium" AND p.project_name="Fly" AND t.department="Marketing"
count: 1
Task: erpnext.create_task_with_subject_project_priority_dept
Goal: create a new task with tomorrow for subject, Beetle for project, High for priority, and Operations for department
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="tomorrow" AND t.priority="High" AND p.project_name="Beetle" AND t.department="Operations"
count: 1
Task: erpnext.create_task_with_subject_project_priority_dept_comment
Goal: create a new task with Best of Five for subject, Faker for project, Low for priority, and Dispatch for department. leave a comment "tremendous achievement" after creating the task
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="Best of Five" AND p.project_name="Faker" AND t.priority="Low" AND t.department="Dispatch" AND t._comments LIKE "%tremendous achievement%"
count: 1
Task: erpnext.create_task_with_subject_project_priority_dept_comment
Goal: create a new task with Best of Seven for subject, Keria for project, Medium for priority, and Marketing for department. leave a comment "great team" after creating the task
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="Best of Seven" AND p.project_name="Keria" AND t.priority="Medium" AND t.department="Marketing" AND t._comments LIKE "%great team%"
count: 1
Task: erpnext.create_task_with_subject_project_priority_dept_comment
Goal: create a new task with Winner Winner for subject, Beryl for project, High for priority, and Operations for department. leave a comment "truth and justice" after creating the task
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabTask` AS t INNER JOIN `tabProject` AS p ON t.project=p.name WHERE t.subject="Winner Winner" AND p.project_name="Beryl" AND t.priority="High" AND t.department="Operations" AND t._comments LIKE "%truth and justice%"
count: 1
Task: erpnext.change_project_status
Goal: update project named Asian Water Monitor to Completed status
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Asian Water Monitor" AND status="Completed"
count: 1
Task: erpnext.change_project_status
Goal: update project named Templeton to Cancelled status
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Templeton" AND status="Cancelled"
count: 1
Task: erpnext.delete_project
Goal: delete project Valorant
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Valorant"
count: 0
Task: erpnext.delete_project
Goal: delete project Temporary project
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Temporary project"
count: 0
Task: erpnext.assign_task
Goal: Assign set deadline task to the user Mingi
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="set deadline" AND _assign LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Mingi"), "%")
count: 1
Task: erpnext.assign_task
Goal: Assign adopt a chinchilla task to the user Ashleigh
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="adopt a chinchilla" AND _assign LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Ashleigh"), "%")
count: 1
Task: erpnext.assign_task
Goal: Assign adopt another chinchilla task to the user Willy Wonka
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="adopt another chinchilla" AND _assign LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Willy Wonka"), "%")
count: 1
Task: erpnext.delete_task
Goal: delete task New Deadline
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="New Deadline"
count: 0
Task: erpnext.delete_task
Goal: delete task clean the bathroom
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="clean the bathroom"
count: 0
Task: erpnext.delete_task
Goal: delete task clean aquarium
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="clean aquarium"
count: 0
Task: erpnext.update_task_status
Goal: update task named "Upfront Costs" to Pending Review status
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="Upfront Costs" AND status="Pending Review"
count: 1
Task: erpnext.update_task_status
Goal: update task named "Very difficult task" to Cancelled status
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabTask WHERE subject="Very difficult task" AND status="Cancelled"
count: 1