ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.create_sales_order_put_on_hold
Goal: create a sales order for the customer Reina Ltd. with SKU0015 for item code, 1.0 for quantity, Goods In Transit - SN for set source warehouse, 20.0 for rate, 2060-11-11 for delivery date. Put the sales order to status Hold and enter "need to check with PM first" as the reason for the hold
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="Reina Ltd." AND soi.item_code="SKU0015" AND soi.qty="1.0" AND soi.rate="20.0" AND so.delivery_date="2060-11-11" AND so.set_warehouse="Goods In Transit - SN" AND so.status LIKE "%Hold%" AND so._comments LIKE "%need to check with PM first%"
count: 1
Task: erpnext.create_sales_order_put_on_hold
Goal: create a sales order for the customer Gwennie Ltd. with SKU0016 for item code, 2.0 for quantity, Stores - SN for set source warehouse, 45.5 for rate, 2060-09-13 for delivery date. Put the sales order to status Hold and enter "overdue" as the reason for the hold
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="Gwennie Ltd." AND soi.item_code="SKU0016" AND soi.qty="2.0" AND soi.rate="45.5" AND so.delivery_date="2060-09-13" AND so.set_warehouse="Stores - SN" AND so.status LIKE "%Hold%" AND so._comments LIKE "%overdue%"
count: 1
Task: erpnext.create_sales_order_put_on_hold
Goal: create a sales order for the customer Horchata Ltd. with SKU0017 for item code, 10.0 for quantity, Work In Progress - SN for set source warehouse, 3.0 for rate, 2060-06-16 for delivery date. Put the sales order to status Hold and enter "need to discuss" as the reason for the hold
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Order` AS so INNER JOIN `tabSales Order Item` AS soi ON so.name=soi.parent WHERE so.customer="Horchata Ltd." AND soi.item_code="SKU0017" AND soi.qty="10.0" AND soi.rate="3.0" AND so.delivery_date="2060-06-16" AND so.set_warehouse="Work In Progress - SN" AND so.status LIKE "%Hold%" AND so._comments LIKE "%need to discuss%"
count: 1
Task: erpnext.assign_sales_invoice
Goal: find all sales invoices with the status Cancelled and assign to the user Jessica
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` WHERE status="Cancelled" AND (_assign IS NULL OR _assign NOT LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Jessica"), "%"))
count: 0
Task: erpnext.assign_sales_invoice
Goal: find all sales invoices with the status Paid and assign to the user Beyonce
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` WHERE status="Paid" AND (_assign IS NULL OR _assign NOT LIKE CONCAT("%", (SELECT email FROM tabUser WHERE full_name="Beyonce"), "%"))
count: 0
Task: erpnext.favorite_sales_invoice
Goal: find and favorite sales invoices with grand total above 100000
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` WHERE grand_total > "100000" AND LOCATE("Administrator", _liked_by) > 0
count: 3
Task: erpnext.tag_sales_invoice
Goal: Find a sales invoice ACC-SINV-2025-00011 and add the following tags to it: asap, priority
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` WHERE name="ACC-SINV-2025-00011" and _user_tags LIKE "%,asap%,priority%"
count: 1
Task: erpnext.tag_sales_invoice
Goal: Find a sales invoice ACC-SINV-2025-00005 and add the following tags to it: urgent, quick
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabSales Invoice` WHERE name="ACC-SINV-2025-00005" and _user_tags LIKE "%,urgent%,quick%"
count: 1
Task: erpnext.create_stock_entry
Goal: create stock entry with ServiceNow for company, Manufacture for stock entry type, SKU0015 for item code, 20 for quantity, and Guardians - SN for source warehouse
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabStock Entry` AS se INNER JOIN `tabStock Entry Detail` AS sed ON se.name=sed.parent WHERE se.company="ServiceNow" AND se.stock_entry_type="Manufacture" AND sed.item_code="SKU0015" AND sed.qty="20" AND sed.s_warehouse="Guardians - SN"
count: 1
Task: erpnext.create_stock_entry
Goal: create stock entry with ServiceNow for company, Material Issue for stock entry type, SKU0017 for item code, 50 for quantity, and Teen Kick - SN for source warehouse
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabStock Entry` AS se INNER JOIN `tabStock Entry Detail` AS sed ON se.name=sed.parent WHERE se.company="ServiceNow" AND se.stock_entry_type="Material Issue" AND sed.item_code="SKU0017" AND sed.qty="50" AND sed.s_warehouse="Teen Kick - SN"
count: 1
Task: erpnext.create_stock_entry_with_letterhead
Goal: create stock entry with ServiceNow for company, Manufacture for stock entry type, SKU0015 for item code, 20 for quantity, Finished Goods - SN for source warehouse, Stores - SN for target warehouse, and Wendigo Ltd. for letter head name with 3.0 for image height and 2.0 for image width
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabStock Entry` AS se INNER JOIN `tabStock Entry Detail` AS sed ON se.name=sed.parent INNER JOIN `tabLetter Head` AS lh ON se.letter_head=lh.letter_head_name WHERE se.company="ServiceNow" AND se.stock_entry_type="Manufacture" AND se.letter_head="Wendigo Ltd." AND lh.image_height="3.0" AND lh.image_width="2.0" AND sed.item_code="SKU0015" AND sed.qty="20" AND sed.s_warehouse="Finished Goods - SN" AND sed.t_warehouse="Stores - SN"
count: 1
Task: erpnext.create_stock_entry_with_letterhead
Goal: create stock entry with ServiceNow for company, Material Issue for stock entry type, SKU0017 for item code, 50 for quantity, The Dream Vault - SN for source warehouse, Work in Progress - SN for target warehouse, and rere for letter head name with 5.0 for image height and 4.0 for image width
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabStock Entry` AS se INNER JOIN `tabStock Entry Detail` AS sed ON se.name=sed.parent INNER JOIN `tabLetter Head` AS lh ON se.letter_head=lh.letter_head_name WHERE se.company="ServiceNow" AND se.stock_entry_type="Material Issue" AND se.letter_head="rere" AND lh.image_height="5.0" AND lh.image_width="4.0" AND sed.item_code="SKU0017" AND sed.qty="50" AND sed.s_warehouse="The Dream Vault - SN" AND sed.t_warehouse="Work in Progress - SN"
count: 1
Task: erpnext.create_stock_item_id_group
Goal: create stock item with SKU019 for item code and Products for item group
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem WHERE item_code="SKU019" AND item_group="Products"
count: 1
Task: erpnext.create_stock_item_id_group
Goal: create stock item with SKU050 for item code and Consumable for item group
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem WHERE item_code="SKU050" AND item_group="Consumable"
count: 1
Task: erpnext.create_stock_item_id_group
Goal: create stock item with SKU030 for item code and Raw Material for item group
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem WHERE item_code="SKU030" AND item_group="Raw Material"
count: 1
Task: erpnext.create_stock_item_name_id_group_description
Goal: create stock item with SKU090 for the item code, Flower Bouquet for the item name, Products for the item group, 'artificial flower bouquet that includes lilies, roses, carnations, tulips, and hyacinths' for description, and check the box 'Delivered by Supplier (Drop Ship)'
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem WHERE item_code="SKU090" AND item_group="Products" AND item_name="Flower Bouquet" AND description LIKE "%artificial flower bouquet that includes lilies, roses, carnations, tulips, and hyacinths%" AND delivered_by_supplier=1
count: 1
Task: erpnext.create_stock_item_name_id_group_description
Goal: create stock item with SKU091 for the item code, Cookie for the item name, Consumable for the item group, 'homemade cookie, options include chocolate chip, snickerdoodle, sugar, oatmeal raisin' for description, and check the box 'Delivered by Supplier (Drop Ship)'
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem WHERE item_code="SKU091" AND item_group="Consumable" AND item_name="Cookie" AND description LIKE "%homemade cookie, options include chocolate chip, snickerdoodle, sugar, oatmeal raisin%" AND delivered_by_supplier=1
count: 1
Task: erpnext.create_stock_item_name_id_group_description
Goal: create stock item with SKU092 for the item code, Laundry Detergent for the item name, Raw Material for the item group, 'laundry detergent liquid' for description, and check the box 'Delivered by Supplier (Drop Ship)'
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem WHERE item_code="SKU092" AND item_group="Raw Material" AND item_name="Laundry Detergent" AND description LIKE "%laundry detergent liquid%" AND delivered_by_supplier=1
count: 1
Task: erpnext.create_stock_item_name_id_group_description_shelf_life_warranty
Goal: Create a stock item with the following criteria: - item code: SKU022 - item name: Gingerbread House Decorating Kit - item group: Consumable - description: DIY gingerbread house decorating kit containing pre-baked gingerbread pieces, icing mix, candies for decoration, and piping bags - shelf life: 365 days - end of life: 2050-01-01 - warranty period: 30 days - weight per unit: 5 Set up the item to auto-reorder when stock quantity reaches 100 units. Select the Think Inside the Box - SN warehouse as the warehouse to send new stock to and enter 500 as the quantity to re-order. Finally, make it so that inspection is required before purchase and before delivery
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem INNER JOIN `tabItem Reorder` ON item_code=parent WHERE item_code="SKU022" AND item_group="Consumable" AND item_name="Gingerbread House Decorating Kit" AND description LIKE "%DIY gingerbread house decorating kit containing pre-baked gingerbread pieces, icing mix, candies for decoration, and piping bags%" AND shelf_life_in_days="365" AND end_of_life="2050-01-01" AND warranty_period="30" AND weight_per_unit="5" AND warehouse="Think Inside the Box - SN" AND warehouse_reorder_level="100" AND warehouse_reorder_qty="500" AND inspection_required_before_purchase=1 AND inspection_required_before_delivery=1
count: 1
Task: erpnext.create_stock_item_name_id_group_description_shelf_life_warranty
Goal: Create a stock item with the following criteria: - item code: SKU023 - item name: Box of Candy Canes - item group: Consumable - description: box of 12 peppermint candy canes - shelf life: 730 days - end of life: 2070-11-30 - warranty period: 60 days - weight per unit: 0.5 Set up the item to auto-reorder when stock quantity reaches 200 units. Select the Think Inside the Box - SN warehouse as the warehouse to send new stock to and enter 1000 as the quantity to re-order. Finally, make it so that inspection is required before purchase and before delivery
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem INNER JOIN `tabItem Reorder` ON item_code=parent WHERE item_code="SKU023" AND item_group="Consumable" AND item_name="Box of Candy Canes" AND description LIKE "%box of 12 peppermint candy canes%" AND shelf_life_in_days="730" AND end_of_life="2070-11-30" AND warranty_period="60" AND weight_per_unit="0.5" AND warehouse="Think Inside the Box - SN" AND warehouse_reorder_level="200" AND warehouse_reorder_qty="1000" AND inspection_required_before_purchase=1 AND inspection_required_before_delivery=1
count: 1
Task: erpnext.create_stock_item_name_id_group_description_shelf_life_warranty
Goal: Create a stock item with the following criteria: - item code: SKU024 - item name: Elf Hat - item group: Products - description: felted elf hat with small bells - shelf life: 3650 days - end of life: 2100-12-31 - warranty period: 90 days - weight per unit: 0.01 Set up the item to auto-reorder when stock quantity reaches 20 units. Select the The Dream Vault - SN warehouse as the warehouse to send new stock to and enter 100 as the quantity to re-order. Finally, make it so that inspection is required before purchase and before delivery
Validation config:
sql: SELECT COUNT(*) AS results_count FROM tabItem INNER JOIN `tabItem Reorder` ON item_code=parent WHERE item_code="SKU024" AND item_group="Products" AND item_name="Elf Hat" AND description LIKE "%felted elf hat with small bells%" AND shelf_life_in_days="3650" AND end_of_life="2100-12-31" AND warranty_period="90" AND weight_per_unit="0.01" AND warehouse="The Dream Vault - SN" AND warehouse_reorder_level="20" AND warehouse_reorder_qty="100" AND inspection_required_before_purchase=1 AND inspection_required_before_delivery=1
count: 1
Task: erpnext.delete_stock_item
Goal: delete stock item with ID SKU101
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_code="SKU101"
count: 0
Task: erpnext.delete_stock_item
Goal: delete stock item with ID SKU100
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_code="SKU100"
count: 0
Task: erpnext.disable_stock_item
Goal: disable stock item Bowl
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_code="Bowl" and disabled=1
count: 1
Task: erpnext.disable_stock_item
Goal: disable stock item Chopsticks
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_code="Chopsticks" and disabled=1
count: 1
Task: erpnext.edit_stock_item_warranty_weight
Goal: edit the warranty period of the stock item wine bottle to 100 days and weight per unit to 3.0
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_name="wine bottle" AND warranty_period="100" AND weight_per_unit="3.0"
count: 1
Task: erpnext.edit_stock_item_warranty_weight
Goal: edit the warranty period of the stock item clock to 365 days and weight per unit to 10.0
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_name="clock" AND warranty_period="365" AND weight_per_unit="10.0"
count: 1
Task: erpnext.edit_stock_item_warranty_weight_material_request_type_tag
Goal: For stock item Router, edit the warranty period to 100 days, weight per unit to 3.0, and default material request type to Purchase, then add the tag "priority" and allow an alternative item
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_name="Router" AND warranty_period="100" AND weight_per_unit="3.0" AND default_material_request_type="Purchase" AND _user_tags LIKE "%,priority%" AND allow_alternative_item=1
count: 1
Task: erpnext.edit_stock_item_warranty_weight_material_request_type_tag
Goal: For stock item Egg Crate, edit the warranty period to 365 days, weight per unit to 10.0, and default material request type to Material Issue, then add the tag "asap" and allow an alternative item
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabItem` WHERE item_name="Egg Crate" AND warranty_period="365" AND weight_per_unit="10.0" AND default_material_request_type="Material Issue" AND _user_tags LIKE "%,asap%" AND allow_alternative_item=1
count: 1
Task: erpnext.create_employee_full_address_HARD
Goal: Create a record for an employee named Eustace A Bagge. Enter Male for gender, 1997-04-19 for date of birth, 2024-09-18 for date of joining, and 112-111-1131 for their phone number. Enter their personal and company email addresses: eustace.bagge@servicenow.com and eustace.bagge@yahoo.com, respectively and choose Company Email as their preferred contact email. Next enter their current address and permanent address: 1233 Main St, Anytown, USA and 1455 Main St, Anytown, USA. Their current address is Rented and their permanent address is Owned. Their emergency contact is Peter Parker whose phone number is 123-456-7490 and relation is Friend. Lastly, enter 122000 USD for the employee's salary
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Eustace" AND middle_name="A" AND last_name="Bagge" AND gender="Male" AND date_of_birth="1997-04-19" AND date_of_joining="2024-09-18" AND cell_number="112-111-1131" AND personal_email="eustace.bagge@yahoo.com" AND company_email="eustace.bagge@servicenow.com" AND prefered_contact_email="Company Email" AND current_address="1233 Main St, Anytown, USA" AND current_accommodation_type="Rented" AND permanent_address="1455 Main St, Anytown, USA" AND permanent_accommodation_type="Owned" AND person_to_be_contacted="Peter Parker" AND emergency_phone_number="123-456-7490" AND relation="Friend" AND ctc="122000" AND salary_currency="USD"
count: 1
Task: erpnext.create_employee_full_address_HARD
Goal: Create a record for an employee named Muriel A Bagge. Enter Female for gender, 1975-05-21 for date of birth, 2024-04-22 for date of joining, and 122-121-1512 for their phone number. Enter their personal and company email addresses: muriel.bagge@servicenow.com and muriel.bagge@hotmail.com, respectively and choose Personal Email as their preferred contact email. Next enter their current address and permanent address: 4546 Elm St, Anytown, USA and 1213 Elm St, Anytown, USA. Their current address is Owned and their permanent address is Rented. Their emergency contact is Mary Jane Watson whose phone number is 123-456-7590 and relation is Family. Lastly, enter 800000 USD for the employee's salary
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Muriel" AND middle_name="A" AND last_name="Bagge" AND gender="Female" AND date_of_birth="1975-05-21" AND date_of_joining="2024-04-22" AND cell_number="122-121-1512" AND personal_email="muriel.bagge@hotmail.com" AND company_email="muriel.bagge@servicenow.com" AND prefered_contact_email="Personal Email" AND current_address="4546 Elm St, Anytown, USA" AND current_accommodation_type="Owned" AND permanent_address="1213 Elm St, Anytown, USA" AND permanent_accommodation_type="Rented" AND person_to_be_contacted="Mary Jane Watson" AND emergency_phone_number="123-456-7590" AND relation="Family" AND ctc="800000" AND salary_currency="USD"
count: 1
Task: erpnext.create_employee_full_address_HARD
Goal: Create a record for an employee named Courage TheCowardly Dog. Enter Male for gender, 1971-05-22 for date of birth, 2024-08-22 for date of joining, and 000-000-1111 for their phone number. Enter their personal and company email addresses: courage.dog@servicenow.com and courage.dog@gmail.com, respectively and choose Personal Email as their preferred contact email. Next enter their current address and permanent address: 7829 Oak St, Anytown, USA and 3417 Oak St, Anytown, USA. Their current address is Owned and their permanent address is Owned. Their emergency contact is Aunt May whose phone number is 123-456-7990 and relation is Friend. Lastly, enter 1200000 USD for the employee's salary
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Courage" AND middle_name="TheCowardly" AND last_name="Dog" AND gender="Male" AND date_of_birth="1971-05-22" AND date_of_joining="2024-08-22" AND cell_number="000-000-1111" AND personal_email="courage.dog@gmail.com" AND company_email="courage.dog@servicenow.com" AND prefered_contact_email="Personal Email" AND current_address="7829 Oak St, Anytown, USA" AND current_accommodation_type="Owned" AND permanent_address="3417 Oak St, Anytown, USA" AND permanent_accommodation_type="Owned" AND person_to_be_contacted="Aunt May" AND emergency_phone_number="123-456-7990" AND relation="Friend" AND ctc="1200000" AND salary_currency="USD"
count: 1
Task: erpnext.create_employee_name_gender_dob_join_date_salary_phone
Goal: create employee record with the full name Chris A Redfield, Male for gender, 1998-03-19 for date of birth, 2023-04-18 for date of joining, 111-111-1131 for mobile phone number, 120000.0 for salary, USD for salary currency
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Chris" AND middle_name="A" AND last_name="Redfield" AND gender="Male" AND date_of_birth="1998-03-19" AND date_of_joining="2023-04-18" AND ctc="120000.0" AND salary_currency="USD" AND cell_number="111-111-1131"
count: 1
Task: erpnext.create_employee_name_gender_dob_join_date_salary_phone
Goal: create employee record with the full name Renato Lee Lyra, Male for gender, 1973-04-21 for date of birth, 2010-05-22 for date of joining, 120-121-1512 for mobile phone number, 80000.0 for salary, AUD for salary currency
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Renato" AND middle_name="Lee" AND last_name="Lyra" AND gender="Male" AND date_of_birth="1973-04-21" AND date_of_joining="2010-05-22" AND ctc="80000.0" AND salary_currency="AUD" AND cell_number="120-121-1512"
count: 1
Task: erpnext.create_employee_name_gender_dob_join_date_salary_phone
Goal: create employee record with the full name Julio R Allegro, Transgender for gender, 1970-04-22 for date of birth, 2024-08-22 for date of joining, 000-000-0001 for mobile phone number, 120500.0 for salary, CNY for salary currency
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Julio" AND middle_name="R" AND last_name="Allegro" AND gender="Transgender" AND date_of_birth="1970-04-22" AND date_of_joining="2024-08-22" AND ctc="120500.0" AND salary_currency="CNY" AND cell_number="000-000-0001"
count: 1
Task: erpnext.create_employee_name_gender_dob_status_join_date
Goal: create employee record with the full name Albert James Wesker, Prefer not to say for gender, 1998-11-11 for birth date, Active for status, and 2023-08-08 for date of joining
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Albert" AND middle_name="James" AND last_name="Wesker" AND gender="Prefer not to say" AND date_of_birth="1998-11-11" AND status="Active" AND date_of_joining="2023-08-08"
count: 1
Task: erpnext.create_employee_name_gender_dob_status_join_date
Goal: create employee record with the full name Leon S Kennedy, Genderqueer for gender, 1973-11-11 for birth date, Inactive for status, and 2017-10-15 for date of joining
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Leon" AND middle_name="S" AND last_name="Kennedy" AND gender="Genderqueer" AND date_of_birth="1973-11-11" AND status="Inactive" AND date_of_joining="2017-10-15"
count: 1
Task: erpnext.create_employee_name_gender_dob_status_join_date
Goal: create employee record with the full name Ethan R Winters, Male for gender, 1990-12-14 for birth date, Suspended for status, and 2023-12-28 for date of joining
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Ethan" AND middle_name="R" AND last_name="Winters" AND gender="Male" AND date_of_birth="1990-12-14" AND status="Suspended" AND date_of_joining="2023-12-28"
count: 1
Task: erpnext.create_employee_with_emergency_contact_HARD
Goal: Create an employee record for the employee named Michael Jeffrey Jordan. Their gender is Male, date of birth is 1963-02-17, date of joining is 2024-08-18, department is Long John Silver's, and they can be reached at 222-111-1131. Add their emergency contact, Steve Kerr, whose phone number is 281-111-1111 and relation is Uncle. Lastly, enter 120500 CNY for Michael's salary and Bandaid as their health insurance (ID number 111-111-3344). If no department named Long John Silver's exists and/or no health insurance provider named Bandaid exists, create them.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Michael" AND middle_name="Jeffrey" AND last_name="Jordan" AND gender="Male" AND date_of_birth="1963-02-17" AND date_of_joining="2024-08-18" AND department="Long John Silver's - SN" AND cell_number="222-111-1131" AND person_to_be_contacted="Steve Kerr" AND emergency_phone_number="281-111-1111" AND relation="Uncle" AND ctc="120500" AND salary_currency="CNY" AND health_insurance_provider="Bandaid" AND health_insurance_no="111-111-3344"
count: 1