-
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
A Complete Guide to Clone Permission Set Using migSO
Permission sets are a vital metadata type that provides users additional access to different tools and features beyond what their profile allows. Managing user access…
Top Salesforce Spring '23 Service Cloud Features
With the all-new Salesforce Spring '23 Service Cloud features discover new capabilities that will assist you and your team provide efficient, high-quality service. Share links,…
How Virtual Salesforce Administrators Help with Automation
Robotic Process Automation (RPA) for Salesforce is a tool that allows you to automate certain tasks. This virtual Salesforce administrator can be helpful if you…
Popular Salesforce Videos
What is Salesforce Hyperforce?
In this video, you will take a look at Salesforce Hyperforce, Salesforce's new re-architecting of the Salesforce platform. 00:00 Introduction 00:28 What is Salesforce Hyperforce?…
Simplify Salesforce Development using CLI and VSCode Tasks
The Salesforce CLI is a powerful command-line interface that simplifies development and builds automation when working with your Salesforce org. Typing commands can be monotonous…
Salesforce Lightning Training
Here, the video is about the Salesforce Lightning Tutorial. These video covers comprise real-world projects that will introduce you to advanced concepts such as Lightning…