SuiteQL: Retrieve all customers’ names and email addresses.

SELECT entityid, email 
FROM customer 
WHERE isinactive = 'F' 
ORDER BY entityid ASC;
  • This query retrieves all active customers (isinactive = 'F').
  • It selects the entityid (customer name) and their email.
  • The results are sorted alphabetically by entityid using ORDER BY ASC.

Leave a comment

Your email address will not be published. Required fields are marked *