select Order.Id,Order.OrderNumber,Id,Cod_Voce_Fatturabile__c,vlocity_cmt__OneTimeCharge__c,Product2.name,Product2.ProductCode,vlocity_cmt__AttributeSelectedValues__c,Order.Offer_Name_CPQ__c from OrderItem where Order.OrderNumber in ( '00169089', '00168912', '00172077', '00172279', '00179812', '00176837', '00176061', '00181736', '00172699', '00172221', '00175221', '00175223', '00173083', '00175674', '00178398', '00177314', '00179054', '00178634', '00175244', '00178354', '00175593', '00176040', '00177316', '00171932', '00177956', '00176834', '00175235', '00175577', '00177947', '00175647', '00172864', '00173285', '00175438', '00173154', '00175626', '00176888', '00173536', '00172349', '00173142', '00175746', '00175451', '00173389', '00179004', '00174181', '00175222', '00173444', '00175692', '00179038', '00179049', '00178558', '00179043' ) and (vlocity_cmt__OneTimeCharge__c !=null and vlocity_cmt__OneTimeCharge__c !=0) and (Cod_Voce_Fatturabile__c =null or Cod_Voce_Fatturabile__c =' ' or Cod_Voce_Fatturabile__c ='null')
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter