-
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
Showcasing the Salesforce Ecosystem
Managing the Company Information with Salesforce Provides the Ultimate Support. Salesforce provides the website visitors, clients, managers, and service agents the required platform that acts…
5 Ways to Speed Up Your Non-profit Business | Salesforce Guide
Mission, communication, and motivation are the three pillars of success for non-profit organizations. According to NonProfitPRO, these three steps help charities achieve their goals. First,…
6 Best Practices While Implementing Salesforce Sales Cloud
Sales Cloud is one of the most prominent offerings in the Salesforce ecosystem and has a proven track record of transforming the sales pipeline and…
Popular Salesforce Videos
Salesforce Interview Questions and Answers | 70 Salesforce Interview Questions for the Beginners
In this video, Interesting data explains 70 Salesforce Interview Questions for Beginners. All the interview questions have been divided into the following important areas of…
Accenture Salesforce Training 2022
This video is about -Accenture Salesforce Training 2022 Orientation session and ASE SFDC Salesforce Certification. As the trusted leader in Salesforce implementation and transformation, Accenture can…
Invoke a Salesforce function from Apex
Learn about the different ways in which you can invoke a Salesforce. Watch this video and learn, if you have any doubts or concerns, do…