ServiceNow-AI/erpnext-tasks huggingface dataset:
Task: erpnext.create_employee_with_emergency_contact_HARD
Goal: Create an employee record for the employee named Dennis Keith Rodman. Their gender is Non-Conforming, date of birth is 1961-05-13, date of joining is 2020-12-22, department is Subway, and they can be reached at 222-121-1512. Add their emergency contact, Larry Bird, whose phone number is 281-232-2456 and relation is Spouse. Lastly, enter 80500 USD for Dennis's salary and Gauze as their health insurance (ID number 120-121-2244). If no department named Subway exists and/or no health insurance provider named Gauze exists, create them.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Dennis" AND middle_name="Keith" AND last_name="Rodman" AND gender="Non-Conforming" AND date_of_birth="1961-05-13" AND date_of_joining="2020-12-22" AND department="Subway - SN" AND cell_number="222-121-1512" AND person_to_be_contacted="Larry Bird" AND emergency_phone_number="281-232-2456" AND relation="Spouse" AND ctc="80500" AND salary_currency="USD" AND health_insurance_provider="Gauze" AND health_insurance_no="120-121-2244"
count: 1
Task: erpnext.create_employee_with_emergency_contact_HARD
Goal: Create an employee record for the employee named Scottie Maurice Pippin. Their gender is Prefer not to say, date of birth is 1965-09-25, date of joining is 2025-08-18, department is Panera, and they can be reached at 888-000-0000. Add their emergency contact, Magic Johnson, whose phone number is 000-000-0111 and relation is Roommate. Lastly, enter 160500 AUD for Scottie's salary and Tums as their health insurance (ID number 000-000-5544). If no department named Panera exists and/or no health insurance provider named Tums exists, create them.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE first_name="Scottie" AND middle_name="Maurice" AND last_name="Pippin" AND gender="Prefer not to say" AND date_of_birth="1965-09-25" AND date_of_joining="2025-08-18" AND department="Panera - SN" AND cell_number="888-000-0000" AND person_to_be_contacted="Magic Johnson" AND emergency_phone_number="000-000-0111" AND relation="Roommate" AND ctc="160500" AND salary_currency="AUD" AND health_insurance_provider="Tums" AND health_insurance_no="000-000-5544"
count: 1
Task: erpnext.update_employee_department
Goal: update the profile of the employee named Ackie Monitor so their department is Dispatch
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE employee_name="Ackie Monitor" AND department="Dispatch"
count: 1
Task: erpnext.update_employee_department
Goal: update the profile of the employee named Jake so their department is Management
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabEmployee` WHERE employee_name="Jake" AND department="Management"
count: 1
Task: erpnext.create_journal_entry
Goal: create journal entry with Debit Note for entry type, ServiceNow for company, ST 6.25% - SN for account, and 400.0 for debit
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="ST 6.25% - SN" AND voucher_type="Debit Note" AND company="ServiceNow" AND total_debit="400.0" AND total_credit="400.0"
count: 1
Task: erpnext.create_journal_entry
Goal: create journal entry with Opening Entry for entry type, ServiceNow for company, ST 6% - SN for account, and 50.0 for debit
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="ST 6% - SN" AND voucher_type="Opening Entry" AND company="ServiceNow" AND total_debit="50.0" AND total_credit="50.0"
count: 1
Task: erpnext.create_journal_entry_with_account_dependency_HARD
Goal: Create a Debit Note-type journal entry with ServiceNow as the company, 1234567 - Hello There - SN as the account, and $400350.0 as the debit amount. If the 1234567 - Hello There - SN account does not exist, create it with 'Hello There' as the account name, '1234567' as the account number and Accounts Receivable - SN as the parent account.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` AS je INNER JOIN `tabAccount` AS a ON je.title=a.name WHERE je.voucher_type="Debit Note" AND je.company="ServiceNow" AND a.account_name="Hello There" AND a.account_number="1234567" AND a.parent_account="Accounts Receivable - SN" AND je.total_debit="400350.0" AND je.total_credit="400350.0"
count: 1
Task: erpnext.create_journal_entry_with_account_dependency_HARD
Goal: Create a Credit Card Entry-type journal entry with ServiceNow as the company, 1234566 - Good Morning - SN as the account, and $5008.0 as the debit amount. If the 1234566 - Good Morning - SN account does not exist, create it with 'Good Morning' as the account name, '1234566' as the account number and Cash In Hand - SN as the parent account.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` AS je INNER JOIN `tabAccount` AS a ON je.title=a.name WHERE je.voucher_type="Credit Card Entry" AND je.company="ServiceNow" AND a.account_name="Good Morning" AND a.account_number="1234566" AND a.parent_account="Cash In Hand - SN" AND je.total_debit="5008.0" AND je.total_credit="5008.0"
count: 1
Task: erpnext.create_payment_entry_with_cost_center_cheque_date_reference
Goal: create a new payment entry with Pay for payment type, ServiceNow for company, ACME Corp. for party, Creditors - SN for account paid to, 10000.0 for paid amount, Check for mode of payment, 123456 for cheque number, 2025-09-17 for cheque date, and Main - SN for cost center
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE payment_type="Pay" AND company="ServiceNow" AND mode_of_payment="Check" AND party_name="ACME Corp." AND paid_to="Creditors - SN" AND paid_amount="10000.0" AND reference_no="123456" AND reference_date="2025-09-17" AND cost_center="Main - SN"
count: 1
Task: erpnext.create_payment_entry_with_cost_center_cheque_date_reference
Goal: create a new payment entry with Receive for payment type, ServiceNow for company, Beth Anglin for party, Bank Account - SN for account paid to, 300.0 for paid amount, Wire Transfer for mode of payment, 789012 for cheque number, 2025-10-25 for cheque date, and Secondary - SN for cost center
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE payment_type="Receive" AND company="ServiceNow" AND mode_of_payment="Wire Transfer" AND party_name="Beth Anglin" AND paid_to="Bank Account - SN" AND paid_amount="300.0" AND reference_no="789012" AND reference_date="2025-10-25" AND cost_center="Secondary - SN"
count: 1
Task: erpnext.create_payment_entry_with_customer_account_project_dependencies_HARD
Goal: Create a payment entry with: - 'Pay' for payment type - 'ServiceNow' for company - 'Cash' for mode of payment - 'Customer' for party type - 'Wowowow' for party - 'Lalalala Land - SN' for account paid to - $300.0 for paid amount - 'US ST 4%' for sales tax and charges template - 'Project A' for project If the customer Wowowow does not exist, create a new customer named 'Wowowow' with 'Company' for customer type, 'wow123@servicenow.com' for email, and '1234567890' for mobile number. If the account Lalalala Land - SN does not exist, create a new account named 'Lalalala Land' with 'Equity' for account type and 'Equity - SN' for parent account If the project Project A does not exist, create a new project named Project A
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` AS pe INNER JOIN `tabCustomer` AS c ON pe.party=c.customer_name INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=c.name AND dl.link_doctype="Customer" INNER JOIN tabContact AS ct ON ct.name=dl.parent INNER JOIN `tabAccount` AS a ON pe.paid_to=a.name INNER JOIN `tabProject` as p ON pe.project=p.name WHERE pe.payment_type="Pay" AND pe.company="ServiceNow" AND pe.mode_of_payment="Cash" AND pe.party_type="Customer" AND pe.party="Wowowow" AND c.customer_type="Company" AND ct.email_id="wow123@servicenow.com" AND ct.mobile_no="1234567890" AND pe.paid_to="Lalalala Land - SN" AND a.account_type="Equity" AND a.parent_account="Equity - SN" AND pe.paid_amount="300.0" AND pe.sales_taxes_and_charges_template="US ST 4% - SN" AND p.project_name="Project A"
count: 1
Task: erpnext.create_payment_entry_with_customer_account_project_dependencies_HARD
Goal: Create a payment entry with: - 'Pay' for payment type - 'ServiceNow' for company - 'Cash' for mode of payment - 'Customer' for party type - 'Yayayay' for party - 'Moonlight - SN' for account paid to - $5500.0 for paid amount - 'US ST 6%' for sales tax and charges template - 'Project B' for project If the customer Yayayay does not exist, create a new customer named 'Yayayay' with 'Individual' for customer type, 'yay123@servicenow.com' for email, and '1234567899' for mobile number. If the account Moonlight - SN does not exist, create a new account named 'Moonlight' with 'Receivable' for account type and 'Accounts Receivable - SN' for parent account If the project Project B does not exist, create a new project named Project B
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` AS pe INNER JOIN `tabCustomer` AS c ON pe.party=c.customer_name INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=c.name AND dl.link_doctype="Customer" INNER JOIN tabContact AS ct ON ct.name=dl.parent INNER JOIN `tabAccount` AS a ON pe.paid_to=a.name INNER JOIN `tabProject` as p ON pe.project=p.name WHERE pe.payment_type="Pay" AND pe.company="ServiceNow" AND pe.mode_of_payment="Cash" AND pe.party_type="Customer" AND pe.party="Yayayay" AND c.customer_type="Individual" AND ct.email_id="yay123@servicenow.com" AND ct.mobile_no="1234567899" AND pe.paid_to="Moonlight - SN" AND a.account_type="Receivable" AND a.parent_account="Accounts Receivable - SN" AND pe.paid_amount="5500.0" AND pe.sales_taxes_and_charges_template="US ST 6% - SN" AND p.project_name="Project B"
count: 1
Task: erpnext.create_payment_entry_with_customer_account_project_dependencies_HARD
Goal: Create a payment entry with: - 'Pay' for payment type - 'ServiceNow' for company - 'Cash' for mode of payment - 'Customer' for party type - 'Huhuhuh' for party - 'Sunlight - SN' for account paid to - $12399.0 for paid amount - 'US ST 6.25%' for sales tax and charges template - 'Project C' for project If the customer Huhuhuh does not exist, create a new customer named 'Huhuhuh' with 'Partnership' for customer type, 'huh123@servicenow.com' for email, and '8654566545' for mobile number. If the account Sunlight - SN does not exist, create a new account named 'Sunlight' with 'Payable' for account type and 'Accounts Payable - SN' for parent account If the project Project C does not exist, create a new project named Project C
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` AS pe INNER JOIN `tabCustomer` AS c ON pe.party=c.customer_name INNER JOIN `tabDynamic Link` AS dl ON dl.link_name=c.name AND dl.link_doctype="Customer" INNER JOIN tabContact AS ct ON ct.name=dl.parent INNER JOIN `tabAccount` AS a ON pe.paid_to=a.name INNER JOIN `tabProject` as p ON pe.project=p.name WHERE pe.payment_type="Pay" AND pe.company="ServiceNow" AND pe.mode_of_payment="Cash" AND pe.party_type="Customer" AND pe.party="Huhuhuh" AND c.customer_type="Partnership" AND ct.email_id="huh123@servicenow.com" AND ct.mobile_no="8654566545" AND pe.paid_to="Sunlight - SN" AND a.account_type="Payable" AND a.parent_account="Accounts Payable - SN" AND pe.paid_amount="12399.0" AND pe.sales_taxes_and_charges_template="US ST 6.25% - SN" AND p.project_name="Project C"
count: 1
Task: erpnext.create_payment_entry_with_mode_of_payment_account_supplier_cost_center_dependencies_HARD
Goal: Create a payment entry with payment type 'Pay', mode of payment 'Pigeon', party 'SPECTRE', paid amount $10000.0, and cost center '12345 - Bucky's - SN'. If there is no mode of payment named Pigeon, create it with type set to 'Cash', company set to 'ServiceNow', and default account set to 'Certificate of Deposits - SN'. If there is no account named Certificate of Deposits - SN, create it with name set to 'Certificate of Deposits', company set to 'ServiceNow' and parent account set to 'Current Assets - SN'. If there is no supplier named SPECTRE, create it with type set to 'Company'. If there is no cost center named 12345 - Bucky's - SN, create it with name set to 'Bucky's', number set to '12345' and parent cost center set to 'ServiceNow - SN'
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` AS pe INNER JOIN `tabMode of Payment` AS mop ON pe.mode_of_payment=mop.name INNER JOIN `tabMode of Payment Account` AS mopa ON mop.name=mopa.parent INNER JOIN `tabAccount` AS a ON mopa.default_account=a.name INNER JOIN `tabSupplier` AS s ON pe.party=s.name INNER JOIN `tabCost Center` AS cc ON pe.cost_center=cc.name WHERE pe.payment_type="Pay" AND pe.company="ServiceNow" AND pe.mode_of_payment="Pigeon" AND mop.type="Cash" AND mopa.company="ServiceNow" AND mopa.default_account="Certificate of Deposits - SN" AND a.parent_account="Current Assets - SN" AND pe.party_type="Supplier" AND pe.party="SPECTRE" AND s.supplier_type="Company" AND pe.paid_amount="10000.0" AND cc.cost_center_name="Bucky's" AND cc.cost_center_number="12345" AND cc.parent_cost_center="ServiceNow - SN"
count: 1
Task: erpnext.create_payment_entry_with_mode_of_payment_account_supplier_cost_center_dependencies_HARD
Goal: Create a payment entry with payment type 'Pay', mode of payment 'Boat', party 'Quantum', paid amount $300.0, and cost center '31459 - Andy's - SN'. If there is no mode of payment named Boat, create it with type set to 'General', company set to 'ServiceNow', and default account set to 'Checking - SN'. If there is no account named Checking - SN, create it with name set to 'Checking', company set to 'ServiceNow' and parent account set to 'Bank Accounts - SN'. If there is no supplier named Quantum, create it with type set to 'Company'. If there is no cost center named 31459 - Andy's - SN, create it with name set to 'Andy's', number set to '31459' and parent cost center set to 'ServiceNow - SN'
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` AS pe INNER JOIN `tabMode of Payment` AS mop ON pe.mode_of_payment=mop.name INNER JOIN `tabMode of Payment Account` AS mopa ON mop.name=mopa.parent INNER JOIN `tabAccount` AS a ON mopa.default_account=a.name INNER JOIN `tabSupplier` AS s ON pe.party=s.name INNER JOIN `tabCost Center` AS cc ON pe.cost_center=cc.name WHERE pe.payment_type="Pay" AND pe.company="ServiceNow" AND pe.mode_of_payment="Boat" AND mop.type="General" AND mopa.company="ServiceNow" AND mopa.default_account="Checking - SN" AND a.parent_account="Bank Accounts - SN" AND pe.party_type="Supplier" AND pe.party="Quantum" AND s.supplier_type="Company" AND pe.paid_amount="300.0" AND cc.cost_center_name="Andy's" AND cc.cost_center_number="31459" AND cc.parent_cost_center="ServiceNow - SN"
count: 1
Task: erpnext.create_payment_entry_with_mode_of_payment_account_supplier_cost_center_dependencies_HARD
Goal: Create a payment entry with payment type 'Pay', mode of payment 'Telepathy', party 'Fillet of Soul', paid amount $500.0, and cost center '727881 - Ralph's - SN'. If there is no mode of payment named Telepathy, create it with type set to 'Phone', company set to 'ServiceNow', and default account set to 'Savings - SN'. If there is no account named Savings - SN, create it with name set to 'Savings', company set to 'ServiceNow' and parent account set to 'Bank Accounts - SN'. If there is no supplier named Fillet of Soul, create it with type set to 'Company'. If there is no cost center named 727881 - Ralph's - SN, create it with name set to 'Ralph's', number set to '727881' and parent cost center set to 'ServiceNow - SN'
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` AS pe INNER JOIN `tabMode of Payment` AS mop ON pe.mode_of_payment=mop.name INNER JOIN `tabMode of Payment Account` AS mopa ON mop.name=mopa.parent INNER JOIN `tabAccount` AS a ON mopa.default_account=a.name INNER JOIN `tabSupplier` AS s ON pe.party=s.name INNER JOIN `tabCost Center` AS cc ON pe.cost_center=cc.name WHERE pe.payment_type="Pay" AND pe.company="ServiceNow" AND pe.mode_of_payment="Telepathy" AND mop.type="Phone" AND mopa.company="ServiceNow" AND mopa.default_account="Savings - SN" AND a.parent_account="Bank Accounts - SN" AND pe.party_type="Supplier" AND pe.party="Fillet of Soul" AND s.supplier_type="Company" AND pe.paid_amount="500.0" AND cc.cost_center_name="Ralph's" AND cc.cost_center_number="727881" AND cc.parent_cost_center="ServiceNow - SN"
count: 1
Task: erpnext.create_payment_entry_without_cost_center
Goal: create payment entry with Pay for payment type, ServiceNow for company, Cash for mode of payment, We Sell Chips for party, Employee Advances - SN for account paid to, and 100.0 for paid amount
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE payment_type="Pay" AND company="ServiceNow" AND mode_of_payment="Cash" AND party_name="We Sell Chips" AND paid_to="Employee Advances - SN" AND paid_amount="100.0"
count: 1
Task: erpnext.create_payment_entry_without_cost_center
Goal: create payment entry with Receive for payment type, ServiceNow for company, Cash for mode of payment, Horchata Ltd. for party, Cash - SN for account paid to, and 300.0 for paid amount
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE payment_type="Receive" AND company="ServiceNow" AND mode_of_payment="Cash" AND party_name="Horchata Ltd." AND paid_to="Cash - SN" AND paid_amount="300.0"
count: 1
Task: erpnext.assign_journal_entry
Goal: assign journal entry titled Cash - SN to the user Queen
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="Cash - SN" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Queen"), "%")
count: 1
Task: erpnext.assign_journal_entry
Goal: assign journal entry titled Earnest Money - SN to the user Beyonce
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="Earnest Money - SN" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Beyonce"), "%")
count: 1
Task: erpnext.cancel_journal_entry
Goal: cancel journal entry named The Boys
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="The Boys" AND docstatus=2
count: 1
Task: erpnext.cancel_journal_entry
Goal: cancel journal entry named Scooter
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="Scooter" AND docstatus=2
count: 1
Task: erpnext.cancel_journal_entry
Goal: cancel journal entry named Genie
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabJournal Entry` WHERE title="Genie" AND docstatus=2
count: 1
Task: erpnext.assign_payment_entry
Goal: assign payment entry named MA Inc. to the user named Lizzie
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE title="MA Inc." AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Lizzie"), "%")
count: 1
Task: erpnext.assign_payment_entry
Goal: assign payment entry named Orlando to the user named Eugene Krabs
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE title="Orlando" AND _assign LIKE CONCAT("%", (SELECT email FROM `tabUser` WHERE full_name="Eugene Krabs"), "%")
count: 1
Task: erpnext.cancel_payment_entry
Goal: cancel payment entry named Ltd.
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE title="Ltd." AND status="Cancelled"
count: 1
Task: erpnext.cancel_payment_entry
Goal: cancel payment entry named Father
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE title="Father" AND status="Cancelled"
count: 1
Task: erpnext.cancel_payment_entry
Goal: cancel payment entry named Okoye
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabPayment Entry` WHERE title="Okoye" AND status="Cancelled"
count: 1
Task: erpnext.create_project_with_customer_full_address_HARD
Goal: Create a Low priority project named Starlord. Bill it to the company ServiceNow and add a note that says 'take out the trash'. Add Rachel Weisz as the project customer but if they're not in the system, create their record, entering Rachel Weisz for their name, Company for customer type, USD for billing currency, www.rachelweisz.com for website, and 'Customer likes to wear pink' for customer details. Add an address to their record with 'Rachel's home' for the address title and Personal for the address type. The address is 333 Potato St, Anytown, Anystate, 12434, Canada
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabCustomer` AS c ON p.customer=c.name INNER JOIN `tabAddress` AS a ON c.customer_primary_address=a.name WHERE p.project_name="Starlord" AND p.priority="Low" AND p.notes LIKE "%take out the trash%" AND p.company="ServiceNow" AND p.customer="Rachel Weisz" AND c.customer_type="Company" AND c.default_currency="USD" AND c.website="www.rachelweisz.com" AND c.customer_details LIKE "%Customer likes to wear pink%" AND a.address_title="Rachel's home" AND a.address_type="Personal" AND a.address_line1="333 Potato St" AND a.city="Anytown" AND a.state="Anystate" AND a.country="Canada" AND a.pincode="12434"
count: 1
Task: erpnext.create_project_with_customer_full_address_HARD
Goal: Create a Medium priority project named Gamora. Bill it to the company ServiceNow and add a note that says 'return Blockbuster movie'. Add Kirsty Swanson as the project customer but if they're not in the system, create their record, entering Kirsty Swanson for their name, Individual for customer type, USD for billing currency, www.kirstyswanson.com for website, and 'Customer likes to wear red' for customer details. Add an address to their record with 'Kirsty's home' for the address title and Current for the address type. The address is 444 Dinner St, Anytown, Anystate, 12345, Canada
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabCustomer` AS c ON p.customer=c.name INNER JOIN `tabAddress` AS a ON c.customer_primary_address=a.name WHERE p.project_name="Gamora" AND p.priority="Medium" AND p.notes LIKE "%return Blockbuster movie%" AND p.company="ServiceNow" AND p.customer="Kirsty Swanson" AND c.customer_type="Individual" AND c.default_currency="USD" AND c.website="www.kirstyswanson.com" AND c.customer_details LIKE "%Customer likes to wear red%" AND a.address_title="Kirsty's home" AND a.address_type="Current" AND a.address_line1="444 Dinner St" AND a.city="Anytown" AND a.state="Anystate" AND a.country="Canada" AND a.pincode="12345"
count: 1
Task: erpnext.create_project_with_customer_full_address_HARD
Goal: Create a High priority project named Rocket. Bill it to the company ServiceNow and add a note that says 'this is a note'. Add Jane Goodall as the project customer but if they're not in the system, create their record, entering Jane Goodall for their name, Individual for customer type, USD for billing currency, www.janegoodall.com for website, and 'Customer likes to go hiking in the jungle' for customer details. Add an address to their record with 'Jane's home' for the address title and Permanent for the address type. The address is 777 Steak St, Anytown, Anystate, 12445, Canada
Validation config:
sql: SELECT COUNT(*) AS results_count FROM `tabProject` AS p INNER JOIN `tabCustomer` AS c ON p.customer=c.name INNER JOIN `tabAddress` AS a ON c.customer_primary_address=a.name WHERE p.project_name="Rocket" AND p.priority="High" AND p.notes LIKE "%this is a note%" AND p.company="ServiceNow" AND p.customer="Jane Goodall" AND c.customer_type="Individual" AND c.default_currency="USD" AND c.website="www.janegoodall.com" AND c.customer_details LIKE "%Customer likes to go hiking in the jungle%" AND a.address_title="Jane's home" AND a.address_type="Permanent" AND a.address_line1="777 Steak St" AND a.city="Anytown" AND a.state="Anystate" AND a.country="Canada" AND a.pincode="12445"
count: 1