Loading

'Parent Case Number' field in report or list view filters

Date de publication: Oct 13, 2022
Description
The Parent Case Number field on the Case object is treated as a numeric field like the Case Number field it references, rather than being treated like other similar relationship fields (such as Parent Account). This results in incorrect results being returned when using the following filters in List Views or Reports:  
 
Parent Case Number equals <blank>
Parent Case Number not equal to <blank>
 
Résolution
To work around this behavior, there are two options:

1. Create a new text formula field on the Case object with the following formula, and then use this field in your filter instead: 
ParentId
2. Use "Parent Case Number less or equal 0" to only include Cases that do not have Parent Cases, or "Parent Case Number greater than 0" to only include Cases that have Parent Cases.

Of the above two options, we recommend using the formula field method to ensure that your filters do not change if the behavior of the Parent Case Number field ever changes.
Numéro d’article de la base de connaissances

000384194

 
Chargement
Salesforce Help | Article