You need to sign in to do that
Don't have an account?
Doug Beltowski X
Remote Object Query not respecting multiple conditions on single field
I'm trying to utilize Remote Objects in order to query a Custom Object. My JSON criteria are below. My query returns data, the problem is that the first Custom_Date_Time__c field criteria is ignored. As shown it will return all objects with date before January 1st 2016, and if I switch the lines it will return all objects with the date after January 1st 2014. What I need are all objects with the date between these two.
{ where: { RecordTypeId: {in: ids}, Custom_Boolean__c: {eq: true}, Custom_Date_Time__c: {gte: new Date('2014-1-1')}, Custom_Date_Time__c: {lte: new Date('2016-1-1')} }, limit: 100 }Is this a bug/limitation with Remote Objects, or is my query somehow malformed?
The following format returned the records that I wanted.