Support Topics Documentation Slack YouTube Blog

Where Clause with created date column Does not produce results

Are you looking for help?

This is a support forum for reporting issues related to Backendless services. Please note that due to our support policy we cannot provide you help with debugging your code, consulting in regards to any language or third-party library usage. For this kind of questions we recommend using more appropriate forums like Stack Overflow.

In order to suggest you a quality solution, we shall usually ask you to provide the details mentioned below first. Including them into your topic right away helps us to start investigating your issue much faster.

In case you have a suggestion or an idea, the details below are not always required, though still any additional background is welcome.

Backendless Version (3.x / 5.x, Online / Managed / Pro )

5.x

Client SDK (REST / Android / Objective-C / Swift / JS )

android

Application ID

Expected Behavior

Responses to show. at least 2 response
Please describe the expected behavior of the issue, starting from the first action.

1.o response
2.
3.

Actual Behavior

Please provide a description of what actually happens, working from the same starting point.
I get o results from my response.

Be descriptive: “it doesn’t work” does not describe what the behavior actually is – instead, say “the request returns a 400 error with message XXX”. Copy and paste your logs, and include any URLs.

Reproducible Test Case

Please provide a simple code that could be run in a new clean app and reproduce the issue.

See my where clause below: String whereClause = “status = ‘completed’ and asignedTo = '”+astatus+"’ and created = ‘08/18/2019’"; I dont get the results i want at all. it loads no result. Yet i have values i expect to load. Please is there something rong with my where clause ?

If the issue is more complex or requires configuration, please provide a link to a project on Github that reproduces the issue.

Hello,
Please use unix timestamp as milliseconds in the where clause of any Backendless SDK.
https://backendless.com/docs/rest/data_search_with_dates.html

Regards,
Olha