RQC List Filtering (from Hurricane 9.1.0)
Default Filter
CRM Page | Pricefx Page | Filter Value |
---|---|---|
Opportunity | Quote | {<opportunity>[<crm>.opportunityAssociationField]} equals {<quote>[<crm>.quoteOpportunityReferenceField} |
“ | Agreement/Promotion (Contract) | {<opportunity>[<crm>.opportunityAssociationField]} equals {<quote>[<crm>.contractOpportunityReferenceField} |
“ | Rebate Agreement | {<opportunity>[<crm>.opportunityAssociationField]} equals {<rebateAgreement>[<crm>.rebateAgreementOpportunityReferenceField} |
Account | Quote | {<account>[<crm>.accountAssociationField]} equals {<quote>[<crm>.quoteAccountReferenceField} |
“ | Agreement/Promotion (Contract) | {<account>[<crm>.accountAssociationField]} iContains {<contract>[<crm>.contractAccountReferenceField} |
“ | Rebate Agreement | {<rebateAgreement>[<crm>.rebateAgreementAccountReferenceField} iContains {<account>[<crm>.accountAssociationField]} |
For example, if I want to filter quotes by this condition: “(Field1 of the opportunity) === (additionalInfo3 of the quote)”, I can define the advanced config item:
{
...,
"salesforce":{
"opportunityAssociationField":"Field1",
"quoteOpportunityReferenceField":"additionalInfo3"
},
...
}
Let’s say we have this Opportunity payload:
{
"Id": "0011X00000opRk7QAE",
"Field1": "Field1 Value",
...
}
we will see this criteria in Salesforce > Opportunity > Quote List
{
"criteria": [
{
"fieldName": "additionalInfo3" ,
"operator": "equals",
"value": "Field1 Value"
}
],
"operator": "and"
}
Simple Custom Filter
CRM Page | Pricefx Page | Advanced Config Item Name | Model | Sample | Default Value |
---|---|---|---|---|---|
Opportunity | Quote | <crm>.quoteListOpportunityFilterDefinition | { | { | null (apply the above Default filter) |
“ | Agreement/Promotion (Contract) | <crm>.contractListOpportunityFilterDefinition | “ | { | “ |
“ | Rebate Agreement | <crm>.rebateAgreementListOpportunityFilterDefinition | “ |
| “ |
Account | Quote | <crm>.quoteListAccountFilterDefinition | “ |
| “ |
| Agreement/Promotion (Contract) | <crm>.contractListAccountFilterDefinition | “ |
| “ |
| Rebate Agreement | <crm>.rebateAgreementListAccountFilterDefinition | “ |
| “ |
For example, if I want to filter quotes by their statuses like: all quotes are in status of DRAFT or OFFER, I can define this advanced config item:
we will see this criteria in Salesforce > Opportunity > Quote List
Simple Custom Filter will override the Default Filter if both are configured.
Simple Customer Filter does not support 2 or more conditions (AND or OR).
Other Cases
This approach can replace “salesforce.accountLayoutQuoteStatusFilter
“ and provide more flexible filter by just configuration. In case of complex filter(s), we should use ‘<clic>ListFilterAdd’.
The same logic of Default Filter in Quote will be applied for crmOtherGetOpportunityFilters
as well, possible to extend for Agreement/Promotion and Rebate Agreement.
Found an issue in documentation? Write to us.
Pricefx version 12.0