This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

can anyone suggest a cleaner way to write the following saved search? i have this feeling i’m doubling up on criteria and it’s slowing it down

 `CASE WHEN MOD(TO_CHAR({today}, 'IW'), 2) = '1' THEN ( CASE WHEN {custentity_call_list_week} = 'Week 1' THEN 'Fortnightly on W1' ELSE '' END )`
	`WHEN MOD(TO_CHAR({today}, 'IW'), 2) = '0' THEN ( CASE WHEN {custentity_call_list_week} = 'Week 2' THEN 'Fortnightly on W2' ELSE '' END )`
	`ELSE ''`
	`END`

you only really have 3 cases
 odd weeks where custentity_call_list_week is Week 1
 even weeks where custentity_call_list_week is Week 2
 and an else case

you can combine comparison with AND, and simply use one else since all 3 of your are the same

that said, thats unlikely to really slow down your search by much, if at all

<@U5TF1GQ20> cheers! yeah weird, it’s about 2 minutes with the field and 10 seconds without for 83 records