Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static final String PRD_QUERY_CHANGELOG = 'SELECT LastModifiedBy.Name, ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Product__c', '', new Set<String>()) +
- ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_ProductAttribute__c', '', new Set<String>()) + ', ' +
- + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Attribute__c', 'Attribute__r.', new Set<String>()) +', Attribute__r.LastModifiedBy.Name FROM Attributes__r WHERE Active__c = true ORDER BY Order__c ASC) ' +
- ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_ProductComponent__c', '', new Set<String>()) + ', ' +
- + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Component__c', 'Component__r.', new Set<String>()) +', Component__r.LastModifiedBy.Name FROM ProductComponents__r ORDER BY Order__c ASC) ' +
- ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_ProductComponentDependency__c', '', new Set<String>()) + ', Master_Attribute__r.TECH_Definition_Id__c, Master_Attribute_Value__r.TECH_Value_ID__c, '+
- 'Master_Attribute_Value__r.TECH_External_Id__c, Primary_Component__r.TECH_Definition_ID__c, Primary_Component__r.TECH_External_Id__c, Secondary_Component__r.TECH_Definition_ID__c, Secondary_Component__r.TECH_External_Id__c FROM ComponentDependencies__r) ' +
- ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_AttributeValueDependency__c', '', new Set<String>()) + ', Master_Attribute__r.TECH_Definition_Id__c, Master_Value__r.TECH_Value_ID__c, Dependent_Attribute__r.TECH_Definition_Id__c, Dependent_Value__r.TECH_Value_ID__c, '+
- 'Master_Value__r.TECH_External_Id__c, Component__r.TECH_Definition_ID__c, Component__r.TECH_External_Id__c FROM AttributeValueDependencies__r) ' +
- //', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Sold_Service_Mapping__c', '', new Set<String>()) + ' FROM Sold_Service_Mappings__r) ' +
- ', (SELECT Name, Data_Type__c, Source_Constant_Value__c, Source_Field_Name__c, Target_Field_OLI__c, Target_Field_Sold_Service__c, Type_of_Service__c, Update_on_Change__c, Upsert_Key__c, TECH_External_Id__c FROM Sold_Service_Mappings__r) ' +
- ', (SELECT Name, Price_Type__c, Dependencies_Logic__c, Row_Field__c, Row_Value__c, Rows_Linear__c, Target_Attribute__c, Column_Field__c, Column_Value__c, Columns_Linear__c, Multiplier_Field__c, Multiplier_Value__c, Target_Field__c, TECH_External_Id__c FROM Product_Pricings__r) ' +
- ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_AttributeDefaultValue__c', '', new Set<String>()) + ' FROM AttributeDefaultValues__r) ' +
- ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_AttributeRule__c', '', new Set<String>()) + ' FROM AttributeRules__r) ' +
- ' FROM CPQ_Product__c ';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement