ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.create_project_with_name_company
Goal: create a new project with Pasta for project name and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Pasta" AND company="ServiceNow"
count: 1
Task: erpnext.create_project_with_name_company
Goal: create a new project with SmashBurger for project name and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="SmashBurger" AND company="ServiceNow"
count: 1
Task: erpnext.create_project_with_name_company
Goal: create a new project with Fresas con Crema for project name and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Fresas con Crema" AND company="ServiceNow"
count: 1
Task: erpnext.create_project_with_name_company_priority_note
Goal: create a new project with Starlord for project name, Low for priority, "take out the trash" for note, and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Starlord" AND company="ServiceNow" AND priority="Low" AND notes LIKE "%take out the trash%"
count: 1
Task: erpnext.create_project_with_name_company_priority_note
Goal: create a new project with Gamora for project name, Medium for priority, "return Blockbuster movie" for note, and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Gamora" AND company="ServiceNow" AND priority="Medium" AND notes LIKE "%return Blockbuster movie%"
count: 1
Task: erpnext.create_project_with_name_company_priority_note
Goal: create a new project with Rocket for project name, High for priority, "this is a note" for note, and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="Rocket" AND company="ServiceNow" AND priority="High" AND notes LIKE "%this is a note%"
count: 1
Task: erpnext.create_project_with_name_company_priority_note_dept_cost
Goal: create a new project with JJK for project name, Low for priority, "hello clarice" for note, Operations for department, 300 for estimated cost, and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="JJK" AND company="ServiceNow" AND priority="Low" AND notes LIKE "%hello clarice%" AND department="Operations" AND estimated_costing="300"
count: 1
Task: erpnext.create_project_with_name_company_priority_note_dept_cost
Goal: create a new project with AOT for project name, Medium for priority, "do you want to play a game" for note, Management for department, 400 for estimated cost, and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="AOT" AND company="ServiceNow" AND priority="Medium" AND notes LIKE "%do you want to play a game%" AND department="Management" AND estimated_costing="400"
count: 1
Task: erpnext.create_project_with_name_company_priority_note_dept_cost
Goal: create a new project with KNY for project name, High for priority, "favorite scary movie" for note, Dispatch for department, 100 for estimated cost, and ServiceNow for company
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabProject WHERE project_name="KNY" AND company="ServiceNow" AND priority="High" AND notes LIKE "%favorite scary movie%" AND department="Dispatch" AND estimated_costing="100"
count: 1
Task: erpnext.create_project_with_type_dept_cost_center_dependencies_HARD
Goal: Create a new project with Tuna Melt for project name, Open for status, Minerals for project type, Low for priority, L Train - SN for department, and Task Progress for % complete method. Under Notes, add a note 'let's sit down' and under Costing and Billing, fill in '123' for estimated cost, 'ServiceNow' for company, and 'Chucky's - SN' for default cost center. If the Minerals project type, L Train - SN department, and Chucky's - SN cost center don't exist, create them. For the Chucky's - SN cost center, set its name to Chucky's and its parent cost center to ServiceNow - SN. For the L Train - SN department, set its name to L Train and its payroll cost center to Chucky's - SN.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name INNER JOIN `tabCost Center` AS cc ON p.cost_center=cc.name WHERE p.project_name="Tuna Melt" AND p.status="Open" AND p.priority="Low" AND p.percent_complete_method="Task Progress" AND p.department="L Train - SN" AND d.payroll_cost_center="Chucky's - SN" AND cc.parent_cost_center="ServiceNow - SN" AND p.project_type="Minerals" AND p.notes LIKE "%let's sit down%" AND p.estimated_costing="123" AND p.company="ServiceNow" AND p.cost_center="Chucky's - SN"
count: 1
Task: erpnext.create_project_with_type_dept_cost_center_dependencies_HARD
Goal: Create a new project with S&P Regular for project name, Open for status, Rocks for project type, Medium for priority, J Train - SN for department, and Manual for % complete method. Under Notes, add a note 'where's our waiter' and under Costing and Billing, fill in '3400' for estimated cost, 'ServiceNow' for company, and 'Freddy's - SN' for default cost center. If the Rocks project type, J Train - SN department, and Freddy's - SN cost center don't exist, create them. For the Freddy's - SN cost center, set its name to Freddy's and its parent cost center to ServiceNow - SN. For the J Train - SN department, set its name to J Train and its payroll cost center to Freddy's - SN.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name INNER JOIN `tabCost Center` AS cc ON p.cost_center=cc.name WHERE p.project_name="S&P Regular" AND p.status="Open" AND p.priority="Medium" AND p.percent_complete_method="Manual" AND p.department="J Train - SN" AND d.payroll_cost_center="Freddy's - SN" AND cc.parent_cost_center="ServiceNow - SN" AND p.project_type="Rocks" AND p.notes LIKE "%where's our waiter%" AND p.estimated_costing="3400" AND p.company="ServiceNow" AND p.cost_center="Freddy's - SN"
count: 1
Task: erpnext.create_project_with_type_dept_cost_center_dependencies_HARD
Goal: Create a new project with BLT for project name, Open for status, Gems for project type, High for priority, S Train - SN for department, and Task Completion for % complete method. Under Notes, add a note 'I'm so hungry' and under Costing and Billing, fill in '500500' for estimated cost, 'ServiceNow' for company, and 'Jason's - SN' for default cost center. If the Gems project type, S Train - SN department, and Jason's - SN cost center don't exist, create them. For the Jason's - SN cost center, set its name to Jason's and its parent cost center to ServiceNow - SN. For the S Train - SN department, set its name to S Train and its payroll cost center to Jason's - SN.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name INNER JOIN `tabCost Center` AS cc ON p.cost_center=cc.name WHERE p.project_name="BLT" AND p.status="Open" AND p.priority="High" AND p.percent_complete_method="Task Completion" AND p.department="S Train - SN" AND d.payroll_cost_center="Jason's - SN" AND cc.parent_cost_center="ServiceNow - SN" AND p.project_type="Gems" AND p.notes LIKE "%I'm so hungry%" AND p.estimated_costing="500500" AND p.company="ServiceNow" AND p.cost_center="Jason's - SN"
count: 1
Task: erpnext.create_project_with_type_dept_customer_cost_center_dependencies_HARD
Goal: Create a new project with Double Down for project name, Open for status, Hard one for project type, Task Progress for % percent complete method, Low for priority, and Washing - SN for department. Add the customer West World to the project, the note 'I think I miss my wife', and an estimated cost of 12000. Set the company to ServiceNow and default cost center to Wells - SN. If the cost center Wells - SN does not exist, create it with name set to Wells and parent cost center set to ServiceNow - SN. If the department Washing - SN does not exist, create it with name set to Washing and payroll cost center set to Wells - SN. If the project type Hard one does not exist, create it with type set to Hard one. If the customer West World does not exist, create them with customer type set to Company and commission rate set to 10.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name INNER JOIN `tabCost Center` AS cc ON p.cost_center=cc.name INNER JOIN `tabCustomer` AS c ON p.customer=c.name WHERE p.project_name="Double Down" AND p.status="Open" AND p.priority="Low" AND p.percent_complete_method="Task Progress" AND p.department="Washing - SN" AND d.payroll_cost_center="Wells - SN" AND cc.parent_cost_center="ServiceNow - SN" AND p.project_type="Hard one" AND p.notes LIKE "%I think I miss my wife%" AND p.estimated_costing="12000" AND p.company="ServiceNow" AND p.cost_center="Wells - SN" AND p.customer="West World" AND c.customer_type="Company" AND c.default_commission_rate="10"
count: 1
Task: erpnext.create_project_with_type_dept_customer_cost_center_dependencies_HARD
Goal: Create a new project with Double Up for project name, Open for status, Easy one for project type, Manual for % percent complete method, Medium for priority, and Drying - SN for department. Add the customer East World to the project, the note 'Think mark think', and an estimated cost of 5000. Set the company to ServiceNow and default cost center to Capitol - SN. If the cost center Capitol - SN does not exist, create it with name set to Capitol and parent cost center set to ServiceNow - SN. If the department Drying - SN does not exist, create it with name set to Drying and payroll cost center set to Capitol - SN. If the project type Easy one does not exist, create it with type set to Easy one. If the customer East World does not exist, create them with customer type set to Partnership and commission rate set to 20.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name INNER JOIN `tabCost Center` AS cc ON p.cost_center=cc.name INNER JOIN `tabCustomer` AS c ON p.customer=c.name WHERE p.project_name="Double Up" AND p.status="Open" AND p.priority="Medium" AND p.percent_complete_method="Manual" AND p.department="Drying - SN" AND d.payroll_cost_center="Capitol - SN" AND cc.parent_cost_center="ServiceNow - SN" AND p.project_type="Easy one" AND p.notes LIKE "%Think mark think%" AND p.estimated_costing="5000" AND p.company="ServiceNow" AND p.cost_center="Capitol - SN" AND p.customer="East World" AND c.customer_type="Partnership" AND c.default_commission_rate="20"
count: 1
Task: erpnext.create_project_with_type_dept_customer_cost_center_dependencies_HARD
Goal: Create a new project with Double or Nothing for project name, Open for status, Medium one for project type, Task Completion for % percent complete method, High for priority, and Folding - SN for department. Add the customer South World to the project, the note 'Invincible is a good show', and an estimated cost of 10000. Set the company to ServiceNow and default cost center to Federal - SN. If the cost center Federal - SN does not exist, create it with name set to Federal and parent cost center set to ServiceNow - SN. If the department Folding - SN does not exist, create it with name set to Folding and payroll cost center set to Federal - SN. If the project type Medium one does not exist, create it with type set to Medium one. If the customer South World does not exist, create them with customer type set to Individual and commission rate set to 30.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name INNER JOIN `tabCost Center` AS cc ON p.cost_center=cc.name INNER JOIN `tabCustomer` AS c ON p.customer=c.name WHERE p.project_name="Double or Nothing" AND p.status="Open" AND p.priority="High" AND p.percent_complete_method="Task Completion" AND p.department="Folding - SN" AND d.payroll_cost_center="Federal - SN" AND cc.parent_cost_center="ServiceNow - SN" AND p.project_type="Medium one" AND p.notes LIKE "%Invincible is a good show%" AND p.estimated_costing="10000" AND p.company="ServiceNow" AND p.cost_center="Federal - SN" AND p.customer="South World" AND c.customer_type="Individual" AND c.default_commission_rate="30"
count: 1
Task: erpnext.create_project_with_type_dept_dependencies_HARD
Goal: Create a new project named Language Arts with Open status and Low priority. Set the project type to Beer and associate it with the The Midnight Gospel - SN department. Set the % complete method as Task Progress and add the note 'trivia tonight'. Finally, under Costing and Billing, set the estimated cost as 100, company as ServiceNow, and default cost center as Main - SN. If the department The Midnight Gospel - SN does not exist, create it with name set to The Midnight Gospel and payroll cost center set to Main - SN. Likewise create the project type Beer if it does not exist.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name WHERE p.project_name="Language Arts" AND p.status="Open" AND p.priority="Low" AND p.percent_complete_method="Task Progress" AND p.department="The Midnight Gospel - SN" AND d.payroll_cost_center="Main - SN" AND p.project_type="Beer" AND p.notes LIKE "%trivia tonight%" AND p.estimated_costing="100" AND p.company="ServiceNow" AND p.cost_center="Main - SN"
count: 1
Task: erpnext.create_project_with_type_dept_dependencies_HARD
Goal: Create a new project named Science with Open status and Medium priority. Set the project type to Wine and associate it with the Invincible - SN department. Set the % complete method as Task Weight and add the note 'so excited'. Finally, under Costing and Billing, set the estimated cost as 3000, company as ServiceNow, and default cost center as Main - SN. If the department Invincible - SN does not exist, create it with name set to Invincible and payroll cost center set to Main - SN. Likewise create the project type Wine if it does not exist.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name WHERE p.project_name="Science" AND p.status="Open" AND p.priority="Medium" AND p.percent_complete_method="Task Weight" AND p.department="Invincible - SN" AND d.payroll_cost_center="Main - SN" AND p.project_type="Wine" AND p.notes LIKE "%so excited%" AND p.estimated_costing="3000" AND p.company="ServiceNow" AND p.cost_center="Main - SN"
count: 1
Task: erpnext.create_project_with_type_dept_dependencies_HARD
Goal: Create a new project named Math with Open status and High priority. Set the project type to Shot and associate it with the Smiling Friends - SN department. Set the % complete method as Manual and add the note 'yay so excited!'. Finally, under Costing and Billing, set the estimated cost as 500, company as ServiceNow, and default cost center as Secondary - SN. If the department Smiling Friends - SN does not exist, create it with name set to Smiling Friends and payroll cost center set to Secondary - SN. Likewise create the project type Shot if it does not exist.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabDepartment` AS d ON p.department=d.name WHERE p.project_name="Math" AND p.status="Open" AND p.priority="High" AND p.percent_complete_method="Manual" AND p.department="Smiling Friends - SN" AND d.payroll_cost_center="Secondary - SN" AND p.project_type="Shot" AND p.notes LIKE "%yay so excited!%" AND p.estimated_costing="500" AND p.company="ServiceNow" AND p.cost_center="Secondary - SN"
count: 1
Task: erpnext.create_task_with_project_type_dept_dependencies_HARD
Goal: Create a task with the subject 'Chicken Meal' for the project 'Listen' with Open status and Low priority. The task type should be Pasta and department should be State Department - SN. Regarding timeline, set the expected start date as 2025-11-14, the expected end date as 2026-05-18, the expected time as 5 hours, and the progress percentage as 4%. Add a comment 'bok bok' to the task. In the event the Listen project, Pasta task type and/or the State Department - SN department don't exist, create them.
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="Chicken Meal" AND t.status="Open" AND t.priority="Low" AND p.project_name="Listen" AND t.type="Pasta" AND t.exp_start_date="2025-11-14" AND t.exp_end_date="2026-05-18" AND t.expected_time="5" AND t.progress="4" AND t.department="State Department - SN" AND t._comments LIKE "%bok bok%"
count: 1
Task: erpnext.create_task_with_project_type_dept_dependencies_HARD
Goal: Create a task with the subject 'Dollar Menu' for the project 'Hear' with Working status and Medium priority. The task type should be Salt and department should be Defense Department - SN. Regarding timeline, set the expected start date as 2025-12-23, the expected end date as 2025-12-20, the expected time as 10 hours, and the progress percentage as 0%. Add a comment 'I love to save money' to the task. In the event the Hear project, Salt task type and/or the Defense Department - SN department don't exist, create them.
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="Dollar Menu" AND t.status="Working" AND t.priority="Medium" AND p.project_name="Hear" AND t.type="Salt" AND t.exp_start_date="2025-12-23" AND t.exp_end_date="2025-12-20" AND t.expected_time="10" AND t.progress="0" AND t.department="Defense Department - SN" AND t._comments LIKE "%I love to save money%"
count: 1
Task: erpnext.create_task_with_project_type_dept_dependencies_HARD
Goal: Create a task with the subject 'Large Drink' for the project 'See' with Pending Review status and High priority. The task type should be Pepper and department should be Treasury Department - SN. Regarding timeline, set the expected start date as 2025-12-18, the expected end date as 2025-12-28, the expected time as 20 hours, and the progress percentage as 40%. Add a comment 'I want a pepsi' to the task. In the event the See project, Pepper task type and/or the Treasury Department - SN department don't exist, create them.
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="Large Drink" AND t.status="Pending Review" AND t.priority="High" AND p.project_name="See" AND t.type="Pepper" AND t.exp_start_date="2025-12-18" AND t.exp_end_date="2025-12-28" AND t.expected_time="20" AND t.progress="40" AND t.department="Treasury Department - SN" AND t._comments LIKE "%I want a pepsi%"
count: 1
Task: erpnext.create_task_with_project_type_parent_dept_dependencies_HARD
Goal: Create a new task called 'Tell Mojito he's a good boy' for the project Jordan's Pet Care Guide. Its status should be Open and priority should be Low. Set its task type to Standard, parent task to Care for a parrot, expected start date to 2025-12-14, expected end date to 2025-12-14, expected time to 0.25 hour(s), progress percentage to 40% and department to the Bird Department. Add a comment to the task record, 'Mojito is happy when I tell him he's a good boy'. In the event the project Jordan's Pet Care Guide, task type Standard, parent task Care for a parrot, and department Bird Department don't exist, create them. Make sure the parent task is also associated with the project Jordan's Pet Care Guide.
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="Tell Mojito he's a good boy" AND t.status="Open" AND p.project_name="Jordan's Pet Care Guide" AND t.priority="Low" AND t.type="Standard" AND t.parent_task=(SELECT name FROM `tabTask` WHERE subject="Care for a parrot") AND t.exp_start_date="2025-12-14" AND t.exp_end_date="2025-12-14" AND t.expected_time="0.25" AND t.progress="40" AND t.department="Bird Department - SN" AND t._comments LIKE "%Mojito is happy when I tell him he's a good boy%"
count: 1
Task: erpnext.create_task_with_project_type_parent_dept_dependencies_HARD
Goal: Create a new task called 'Acclimate Boba to human touch' for the project Jordan's Pet Care Guide. Its status should be Open and priority should be Medium. Set its task type to Milestone, parent task to Care for a snake, expected start date to 2025-12-26, expected end date to 2026-12-26, expected time to 1 hour(s), progress percentage to 12% and department to the Reptile Department. Add a comment to the task record, 'Boba makes for a cute scarf'. In the event the project Jordan's Pet Care Guide, task type Milestone, parent task Care for a snake, and department Reptile Department don't exist, create them. Make sure the parent task is also associated with the project Jordan's Pet Care Guide.
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="Acclimate Boba to human touch" AND t.status="Open" AND p.project_name="Jordan's Pet Care Guide" AND t.priority="Medium" AND t.type="Milestone" AND t.parent_task=(SELECT name FROM `tabTask` WHERE subject="Care for a snake") AND t.exp_start_date="2025-12-26" AND t.exp_end_date="2026-12-26" AND t.expected_time="1" AND t.progress="12" AND t.department="Reptile Department - SN" AND t._comments LIKE "%Boba makes for a cute scarf%"
count: 1
Task: erpnext.create_task_with_project_type_parent_dept_dependencies_HARD
Goal: Create a new task called 'Clean Miso's playpen' for the project Jordan's Pet Care Guide. Its status should be Open and priority should be High. Set its task type to Deliverable, parent task to Care for a rabbit, expected start date to 2025-12-19, expected end date to 2025-12-20, expected time to 1.5 hour(s), progress percentage to 60% and department to the Mammal Department. Add a comment to the task record, 'Miso appreciates a clean playpen'. In the event the project Jordan's Pet Care Guide, task type Deliverable, parent task Care for a rabbit, and department Mammal Department don't exist, create them. Make sure the parent task is also associated with the project Jordan's Pet Care Guide.
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="Clean Miso's playpen" AND t.status="Open" AND p.project_name="Jordan's Pet Care Guide" AND t.priority="High" AND t.type="Deliverable" AND t.parent_task=(SELECT name FROM `tabTask` WHERE subject="Care for a rabbit") AND t.exp_start_date="2025-12-19" AND t.exp_end_date="2025-12-20" AND t.expected_time="1.5" AND t.progress="60" AND t.department="Mammal Department - SN" AND t._comments LIKE "%Miso appreciates a clean playpen%"
count: 1
Task: erpnext.create_task_with_subject_project
Goal: create a new task with start new project for subject and Viper for project
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="start new project" AND p.project_name="Viper"
count: 1
Task: erpnext.create_task_with_subject_project
Goal: create a new task with discuss new deadline for subject and Boa for project
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="discuss new deadline" AND p.project_name="Boa"
count: 1
Task: erpnext.create_task_with_subject_project_priority_dept
Goal: create a new task with lets go for subject, Cricket for project, Low for priority, and Dispatch 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="lets go" AND t.priority="Low" AND p.project_name="Cricket" AND t.department="Dispatch"
count: 1