Loading
Get Started with Communications, Media, and Energy & Utilities (CME)...
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Required Indexes for Industries CPQ Implementations

            You are here:

            1. Salesforce Help
            2. Docs
            3. Communications, Media, and Energy & Utilities Managed Package

            Required Indexes for Industries CPQ Implementations

            If you are implementing Industries CPQ, add the following required indexes to support the related CPQ objects.

            Note
            Note

            Salesforce does not allow installation of custom indexes in an org during install. To have a custom index added to an org, open a case with Salesforce technical support and provide the exact SOQL queries with bind variables needed to create and test the index.

            If you are implementing Industries CPQ, you must add the following required indexes to support the related CPQ objects.

            CPQ Objects

            Required Indexes

            Opportunity-Based CPQ

            • OpportunityLineItem.vlocity_cmt__ParentItemId__c

            • OpportunityLineItem.vlocity_cmt__RootItemId__c

            Order-Based CPQ

            • OrderItem.vlocity_cmt__ParentItemId__c

            • OrderItem.vlocity_cmt__RootItemId__c

            • OrderItem.vlocity_cmt__AssetReferenceId__c

            Quote-Based CPQ

            • QuoteLineItem.vlocity_cmt__ParentItemId__c

            • QuoteLineItem.vlocity_cmt__RootItemId__c

            • QuoteLineItem.vlocity_cmt__AssetReferenceId__c

            Contract and Asset-Based Operations

            • Asset.vlocity_cmt__ParentItemId__c

            • Asset.vlocity_cmt__RootItemId__c

            • Asset.vlocity_cmt__AssetReferenceId__c

            • Asset.vlocity_cmt__PricebookEntryId__c

            • vlocity_cmt__ContractLineItem__c.vlocity_cmt__AssetReferenceId__c

            • vlocity_cmt__ContractLineItem__c.vlocity_cmt__PricebookEntryId__c

            Sample SOQL Queries Requiring Custom Indexes

            The following sample SOQL queries require custom indexes. You may need to update the ID values in the WHERE clauses so that they refer to an actual record in your Salesforce org.

            Optional Indexes for CPQ Implementation

            For better performance, we recommend indexing the vlocity_cmt__SubClassId__c field for the object vlocity_cmt__ObjectFieldAttribute__c.

            Asset SOQL Queries

            Asset.vlocity_cmt__ParentItemId__c

            SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__ParentItemId__c,vlocity_cmt__PricebookEntryId__c,vlocity_cmt__RootItemId__c FROM Asset WHERE vlocity_cmt__ParentItemId__c = '02i3i00000099TNAAY'

            Asset.vlocity_cmt__RootItemId__c

            SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__RootItemId__c FROM Asset WHERE vlocity_cmt__RootItemId__c = '02i3i00000099TaAAI'

            Asset.vlocity_cmt__AssetReferenceId__c

            SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c FROM Asset WHERE vlocity_cmt__AssetReferenceId__c = 'f49e9fa7-2f95-814f-084a-bc017de032ff'

            Asset.vlocity_cmt__PricebookEntryId__c

            SELECT Id,ParentId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__PricebookEntryId__c,vlocity_cmt__RootItemId__c FROM Asset WHERE vlocity_cmt__PricebookEntryId__c = '01u3i000000PavqAAC'

            Order Item SOQL Queries

            OrderItem.vlocity_cmt__ParentItemId__c

            SELECT Id,OrderId,vlocity_cmt__ParentItemId__c FROM OrderItem WHERE vlocity_cmt__ParentItemId__c = '8023i0000000EBkAAM'

            OrderItem.vlocity_cmt__RootItemId__c

            SELECT Id,OrderId,vlocity_cmt__ParentItemId__c,vlocity_cmt__RootItemId__c FROM OrderItem WHERE vlocity_cmt__RootItemId__c = '8023i0000000EBkAAM'

            OrderItem.vlocity_cmt__AssetReferenceId__c

            SELECT Id,OrderId,vlocity_cmt__AssetReferenceId__c,vlocity_cmt__ParentItemId__c,vlocity_cmt__RootItemId__c FROM OrderItem WHERE vlocity_cmt__AssetReferenceId__c = 'f8c87dd8-42bd-acce-c064-0ff505aa0883'
             
            Loading
            Salesforce Help | Article