Ability it use SOQL to provide complex filters on Vlocity and Salesforce Metadata types to create custom Compare & Deploy Filters
I would like to have the ability to enter SOQL queries to filter Metadata types and data. Currently you can only use Object or Regex when you try to filter the data to fine tune the comparison. We are looking to do this for Vlocity and Salesforce metadata types and objects
Surinder Dhillon
shared this idea
-
Surinder Dhillon
commented
I should be able to do something similar to the following:
Creating a Revenue Cloud filter using SOQL queries
To start, open the comparison filter using the cog icon or via Manage custom filters in the comparison filters dropdown.Click on the Revenue Cloud section in the sidebar (Advanced Approvals and Billing are also supported)
Choose the object you wish to apply a query for and enter your SOQL query into the input field provided and click Test SOQL query
The number of records matching your query will be displayed for your source and target. Any syntax errors with your query or problems retrieving the results will also be displayed.
When you've finished configuring the metadata and CPQ records to include in your comparison, click Update comparison.
Note: All records will be retrieved and compared before being displayed.
Example query format
Only the WHERE clause conditions are needed when using a SOQL query to filter records. For example, the query format that you'd use in Gearset would therefore take the following format:CreatedDate > 2022-07-01T00:00:00Z AND CreatedDate < 2023-01-01T00:00:00Z
Family = 'Hardware' OR Family = 'Miscellaneous'
ProductCode LIKE 'USB%'
Description != null
IsActive = True
-
Surinder Dhillon
commented
We have a lot of Legacy products that don't need to be included