thebrettbarlow

# query the accounts and put them in chatty_accounts_to_move__backup.csv
soql "
select id, name, ownerid, owner.name
from account
where ownerid = '005j000000Ea93uAAB'
" -u dev1 -r csv > chatty_accounts_to_move__backup.csv &&

# cut out the Id of each account and set the new OwnerId
cat chatty_accounts_to_move__backup.csv | \
cut -d "," -f 1 | \

thebrettbarlow

sfdx force:data:bulk:upsert \
     --sobjecttype account \
     --externalid id \
     --csvfile chatty_accounts_to_move.csv \
     --targetusername dev1 \
     --wait 10

thebrettbarlow

soql "
select id, name, ownerid, owner.name 
from account 
where ownerid = '005j000000Ea93uAAB'
" -u dev1 -r csv > chatty_accounts_to_move.csv

thebrettbarlow

soql "select id, username from user where firstname = 'chatty'" -u dev1

thebrettbarlow

# This will open a login page that will let you connect your org to the CLI
sfdx force:auth:web:login --setalias HelloWorldOrg

# You will now see the org you connected with!
sfdx force:org:list

thebrettbarlow

SELECT Id, Name, (SELECT Id, Name, Amount, CloseDate FROM Opportunities)
FROM Account
WHERE Id IN (SELECT AccountId FROM Opportunity)

thebrettbarlow

SELECT Id, Name, (SELECT Id, Name, Amount, CloseDate FROM Opportunities)
FROM Account

thebrettbarlow

SELECT Id, FirstName, LastName, Title, Account.Name
FROM Contact
WHERE Title = 'CEO'

thebrettbarlow

SELECT Id, Company, LeadSource, format(CreatedDate)
FROM Lead
ORDER BY CreatedDate
LIMIT 10

thebrettbarlow

SELECT Id, Name, BillingState
FROM Account
WHERE BillingState IN ('CA', 'NY', 'FL')
LIMIT 10