-
How to Filter empty date field in SF analytics api?
Using the analytics rest api we need to add a filter to a date field to get only the records where this field is empty. In json: { "column": "Account.Date_Field__c", "operator": "equals", "value": "" },
This filter is also shown if you fetch the report meta data from SF, so the syntax should be correct.
Till the rollout of Summer 14 release it was working as expected, after the release change we get the error message "Filter the date in the correct format. Accepted formats are yyyy-MM-dd'T'HH:mm:ss'Z' and yyyy-MM-dd.]" I checked to use null, but this leads to an error "574902135-2760 (-2136086741)"
Any ideas how to filter on empty date field?
Log In to reply.
Popular Salesforce Blogs
Steps to Send a Marketing Cloud Email by using Triggered Sends in Sales Cloud
Steps to send a Marketing cloud Email by using Triggered send in sales cloud Note - First you have to enable the Triggered send in…
Salesforce Trends to Look Out for in 2021
Salesforce is one of the top Customer Relationship Management (CRM) platforms. It helps businesses to connect with customers and potential clients by using cloud technology.…
Fillable PDFs for Salesforce Field Service
Automating the generation and parsing of fillable PDFs in Salesforce Field Service can help you save time and eliminate human errors during data entry. Some…
Popular Salesforce Videos
Add Sound Effects to Your Salesforce Org | Salesforce Tutorials | #SalesforceBolt
In this video you will learn to Use a Lightning Web Component to play a fun sound when a big deal closes. You can play…
How To Build a Kanban View Using LWC without APEX | Real-Time Project in LWC | Salesforce
In this project, you will learn 60% of the LWC. You gonna learn the following topics 1. How to create a lightning Page 2. How…
Salesforce Security and Sharing Model Demystified
The Salesforce Sharing and Security Model has undergone numerous enhancements and offers many features to help you configure it to meet the privacy requirements your…