Loading

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

Дата публикации: Oct 13, 2022
Описание
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>
 
Решение
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.
Номер статьи базы знаний

000384194

 
Загрузка
Salesforce Help | Article