Hi, writing NetSuite sql case statements CASE WHEN...
# general
s
Hi, writing NetSuite sql case statements CASE WHEN {transactionlines.custcol_proj_category_on_a_click} IN ('IT Ops & IS','DWS & DO') AND {transactionlines.custcol_project_entity_id} IN ('BRTP00415','BRTP00418') THEN 'DWS' else 'Digital Office' WHEN {transactionlines.custcol_proj_name_on_a_click_report} LIKE 'Fresher' AND {transactionlines.custcol_onsite_offsite}='Offsite' THEN 'Fresher Bench - Offshore' else 'Fresher Bench - Onsite' END