A NetSuite user wants to build a Customer Saved Search that includes a result column showing if the Customer is an individual or a company. Which expression would yield the correct results?
A NetSuite user wants to build a Customer Saved Search that includes a result column showing if the Customer is an individual or a company. Which expression would yield the correct results?
The correct expression to determine if a customer is an individual or a company in a NetSuite Customer Saved Search is by using the field {isperson}. The field {isperson} indicates whether the customer is an individual. The proper syntax in SQL for this conditional logic is indeed 'CASE {isperson} WHEN 'Yes' THEN 'Individual' ELSE 'Company' END'. This expression checks the value of {isperson} and returns 'Individual' if the value is 'Yes'; otherwise, it returns 'Company'.
B is the right answer. Tested in SS
SQL should start with CASE WHEN