I'm trying to line products from the bundle into one row using Product Family as the column header. However, my query results return null cells. See below. Is there a way to merge data by bundle id and hide the null cells?
#SOQL Queries #Salesforce CPQ & Billing #Salesforce CPQ #CPQAskAnExpert
Sorry, I'm a newbie to SOQL. Having a hard time using GROUP BY to get the return I'm looking for. I'm trying to use this query in Conga Composer and currently using TableGroup Hide in the word doc as a workaround, however, I'm hoping there's a cleaner way. Here's my original query:
SELECT Bundle_ID__c, Order_QTY__c, Slab_Config_Details__c, Jamb_Config_Details__c, Hinges_Config_Details__c, Handing_Config_Details__c, Machining_Config_Details__c, Query_Order__c, Slab_Product_Image__c FROM OrderItem WHERE Order.Id = '{pv0}' AND SBQQ__QuoteLine__r.Bundle_ID__c != NULL ORDER BY Bundle_ID__c, Query_Order__c ASC
