Advertisement
Guest User

changelog1

a guest
Jan 20th, 2017
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.34 KB | None | 0 0
  1. public static final String PRD_QUERY_CHANGELOG = 'SELECT LastModifiedBy.Name, ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Product__c', '', new Set<String>()) +
  2.                                             ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_ProductAttribute__c', '', new Set<String>()) + ', ' +
  3.                                                          + 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) ' +
  4.                                             ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_ProductComponent__c', '', new Set<String>()) + ', ' +
  5.                                                          + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Component__c', 'Component__r.', new Set<String>()) +', Component__r.LastModifiedBy.Name FROM ProductComponents__r ORDER BY Order__c ASC) ' +
  6.                                             ', (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, '+
  7.                                                 '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) ' +
  8.                                             ', (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, '+
  9.                                                 'Master_Value__r.TECH_External_Id__c, Component__r.TECH_Definition_ID__c, Component__r.TECH_External_Id__c FROM AttributeValueDependencies__r) ' +
  10.                                             //', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_Sold_Service_Mapping__c', '', new Set<String>()) + ' FROM Sold_Service_Mappings__r) ' +
  11.                                             ', (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) ' +
  12.                                             ', (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) ' +
  13.                                             ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_AttributeDefaultValue__c', '', new Set<String>()) + ' FROM AttributeDefaultValues__r) ' +
  14.                                             ', (SELECT ' + CPQ_Utils01_SObjectHelperCls.getFieldListForSOQL('CPQ_AttributeRule__c', '', new Set<String>()) + ' FROM AttributeRules__r) ' +
  15.                                               ' FROM CPQ_Product__c ';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement