CHECK missing VOCe fatturabile on OrderItems General approach

PHOTO EMBED

Thu Aug 31 2023 13:23:54 GMT+0000 (Coordinated Universal Time)

Saved by @atsigkas 

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')
content_copyCOPY