-
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
From Data Islands to Unified Insights: Transforming Business with Salesforce
In the current digital age companies generate huge amounts of data each and every day. However, the majority of this data remains scattered across various…
Test Class in Salesforce - All You Need To Know
Below are some of the key points to note about the Test Class in Salesforce: Test Classes and test methods verify whether a particular piece…
Who Ya Gonna Call – ‘No Longer Your IT Team’ - (How To Enhance Your Value As A Salesforce Admin!)
Telephony has forever and a day been a dark art , thrust into the hands of the IT Department who typically do not have the…
Popular Salesforce Videos
Searching for Records In Salesforce
You can search globally across all of Salesforce for matching records to your search term. Or you can search within a specific object. You will…
Create Your First Salesforce App in 30 Minutes
In this session, we will design, build and deploy a Salesforce App in 30 minutes using the low code and Salesforce modern developer tooling. Presenter…
How To Create Permission Set Group | Salesforce Development Tutorial
How to create permission set groups. This video will cover the following points - 1. Introduction Get a brief introduction about Permission Set Groups. 2.…