Creating filter using standard fields on 'UnifiedIndividuals' object returns 'NULL' value for date fields.
Trailblazer Community

Creating filter using standard fields on 'UnifiedIndividuals' object returns 'NULL' value for date fields.

CDP

Last updated 2022-03-08 ·Reference W-10448208 ·Reported By 0 users

In Review

Summary
In the Data Explorer, when users are using a Filter on the standard field the Date columns(Birth Date & Created date ) are shown empty. However, placing a filter on a custom field will return the correct values. This issue persists when we copy the SOQL and query in the Developer console. The dates coming from the backend table are in the format "yyyy-MM-dd HH:mm: ss". This date would be failing while trying to parse and if it fails a null value will be loaded instead.

Repro
To reproduce the issue:

- Open any org which have UnifiedIndividuals
- Open the Data Explorer > Data Model Objects > Unified Individuals
- Find one object which has a Date field in it, like created date or last modified date
- Filter on the data explorer using the first name of the identified Individual and see if the Dates are still visible for the record.

Workaround
None, use custom fields for filter crreation until this is resolved.

Reported By (0)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.