Currently we only support, due to our search framework, filters in the format of:
(A or B) and (C or D or E) and ....
We don't support (A and B) or (C and D) although there are plans to expand this functionality for activity exports as it is required in that case.
To the original question poster, if you're trying to extract contacts that were created/modified in a certain date range, you don't need to include the C_DateCreated in the filter criteria. You can achieve the same outcome by filtering on the C_DateModified only. A newly created contact record has the same C_DateCreated and C_DateModified values so you only need to filter the C_DateModified for the date range.
Can someone from Oracle officially confirm the tip from Muqadder Iqbal ' A newly created contact record has the same C_DateCreated and C_DateModified values so you only need to filter the C_DateModified for the date range'?
This would only work if the Contact records were not modified since being created, which I do not think is likely to be the case for the majority of Contacts.
To export all Contacts that were modified or created within a specific timeframe, two exports should be used.
A filter on ModifiedDate should be able to filter 'new' and 'modified' contacts, I guess.
For example -
New contact - CreateDate = ModifiedDate = 22.06.2016, 11:39:20
Modified contact - CreatedDate = 1.02.2015,10:00:00, ModifiedDate = 22.06.2016, 8:00:22
If I now create a filter on ModifiedDate >= 22.06.2016, 00:00:00 , it should be able to return both the new and modified contact
Yes, for that specific scenario, looking for all contacts created or modified after a certain date, it would work.
Can someone confirm if this is still true or has there been any enhancement to the API to allow for a more complex filter?
Confirmed. Here is the supported filter formats with logical operators from our Filtering tutorial:
Important: Supported filter formats with logical operators:
- (A OR B) AND (C OR D)
- A AND NOT B AND (C OR D)
- A AND B AND (C OR D)
- A AND (B OR C)
Note: Activity exports only support the A AND B AND C filter format.
Here is a Dream It idea to allow complex filters I'd encourage voting on, and adding in use case and business requirements as a comment.
That's too bad because it would be super useful if we could specify a filter that allows us to pull all records created or modified in a specified date range (for example a single day). I've up voted the dream it request for this. Thanks for the reply.
Thanks for info