Default Filters Applied in Data Access API Reports for Non-Deleted Records
To ensure data accuracy and cleanliness, all Data Access API reports include default filters that exclude deleted records from each dataset. Below are the standard column filters used per dataset to retrieve non-deleted records by default.
|
Dataset |
Column(s) Used for Default Filtering |
Default Filter Condition |
|
Entitlement |
ActivationDeleted |
"ActivationDeleted" = "N" |
|
Account |
AccountDeleted |
"AccountDeleted" = "N" |
|
User |
UserDeleted |
"UserDeleted" = "N" |
|
Served Devices |
AccountDeleted |
"AccountDeleted" = "N" |
|
Product Feature |
ProductDeleted, ProductFeatureDeleted |
"ProductDeleted" = "N""ProductFeatureDeleted" = "N" |
|
Fulfillment Consolidated |
ActivationDeleted |
"ActivationDeleted" = "N" |
|
Devices |
Device_deleted |
"Device_deleted" = "N" |
|
Device History* |
Device_deleted |
"Device_deleted" = "N" |
|
Fulfillment History* |
ActivationDeleted |
"ActivationDeleted" = "N" |
|
Entitlement History* |
ActivationDeleted |
"ActivationDeleted" = "N" |
Note:* The Device History, Fulfillment History and Entitlement History reports are temporarily unavailable.
Filter Values for Deleted Status Columns
To provide flexibility, the following filter values can be applied to the respective _deleted columns in queries.
|
Filter Value |
Description |
|
"Device_deleted" = "N" |
Returns only non-deleted records (default behavior). |
|
"Device_deleted" = "Y" |
Returns only deleted records. |
|
"Device_deleted" = "ALL" |
Returns all records, including both deleted and non-deleted entries. |
Important:While Device_deleted is shown here as an example, the same logic applies to all _deleted columns across datasets.
Note:Data Access API reports are pre-configured to show only active (non-deleted) records using dataset-specific flags. Users can override this behavior by explicitly passing filter values ("Y" or "ALL") depending on the reporting needs.