magritton
3/26/2015 - 9:04 PM

Cyberquery Switch case example

Cyberquery Switch case example

CQ Switch2
content_copyfile_download
string strCompItemType = switch (msiv_bbom_bic_msiv:item_type) 
           case 'P' : 'Purchased' 
           case 'AI' : 'ATO Item'
           case 'EXP' : 'Expense'
           default : msiv_bbom_bic_msiv:item_type;
CQ Switch
content_copyfile_download
number cost_of_sales = switch (product:product_group) 
           case 8 : sales - (sales * 0.525) 
           case 2 : sales - (sales * 0.398)
           case 6 : sales - (sales * 0.511)
           case 1 : sales - (sales * 0.501)
           case 3 : sales - (sales * 0.177)
           case 4 : sales - (sales * 0.181)
           case 7 : sales - (sales * 0.237)
           case 5 : sales - (sales * 0.173)/mask="zz,zz9";