PS. IF you change a product's structure in PROD, don't forget to do it also in Davinci cause in a future migration/deploy via IDX, it will be overriden again. ________________________________________________A_________________________________________________ select id,product2.Name, vlocity_cmt__OneTimeCharge__c, order.Offer_Name_CPQ__c from orderitem where vlocity_cmt__OneTimeCharge__c !=0 and vlocity_cmt__OneTimeCharge__c != null and Cod_Voce_Fatturabile__c ='' and CreatedDate = TODAY ________________________________________________B_________________________________________________ select Product2.Name,Product2.ProductCode,Id, Codice_Robinson__c, Bene_Servizio__c, Cluster_Commissioning__c, Codice_Prodotto_Neta__c, Cod_Voce_Fatturabile__c, Costo_di_acquisto__c, Gross_margin__c from OrderItem where ID in ( '8027U000009DskAQAS' ) order by Product2.Name limit 1000 ________________________________________________C_________________________________________________ select Name,ProductCode from product2 ________________________________________________D_________________________________________________ select id,Product__r.name,Product__r.ProductCode, Product__r.Tipo__c, Product__r.Costo_di_acquisto__c, Product__r.Gross_margin__c, Service_Component__r.Codice_Prodotto_Robinson__c, Service_Component__r.Voce_Fatturabile_Net__c from Associazione_Product_Service_component__c where Product__r.name like 'Impianto Fotovoltaico' ________________________________________________E_________________________________________________ select id,name,vlocity_cmt__PicklistId__r.Name from vlocity_cmt__PicklistValue__c
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