-
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
All About Data Modelling in Salesforce
In this blog, I am going to explain the topic of data modelling, fields, and object relationships. Let’s begin with: Database It is an organized…
Test Classes in Salesforce - Learn All About it Here
Content What is a Test class in Salesforce? What is the need of a Test class in Salesforce? How to write Test class in Salesforce? …
How to Integrate QuickBooks and Salesforce?
Introduction QuickBooks, a leading accounting software platform developed and marketed by Intuit, a financial software development company helping businesses develop and sell financial, accounting, and…
Popular Salesforce Videos
What is a Salesforce PDO Partner?
Salesforce market is growing very fast these years. It is estimated that in 2021 the Salesforce ecosystem will be worth around 100 billion U.S. dollars.…
Benefit of User Centric Design (UCD)
User-Centric Design (UCD) puts people at the heart of product development, ensuring your interface, features, and user journey are built for real needs, not assumptions.…
When to use which Sandbox? Salesforce Interview Questions and Answers
Watch this video by CRS Info Solutions to when to use which Sandbox. Salesforce sandboxes are copies of your Production environment. A Sandbox contains all the…