Between the dates

REST
1

I’m trying in rest console to write a query that lists all the rows between two specific dates like all the rows between 1/12/2025 and 1/18/2025 and I can’t find an example of it.

2

This should help:

https://backendless.com/docs/rest/data_search_with_dates.html

3

I looked at that, I dont see an example that shows how to get information between two different dates. I tried using greater and less then …also before and after and they all errored out.

4

Data:

Data Browser - ConsoleDemo - Backendless 2025-01-15 14-23-25
Data Browser - ConsoleDemo - Backendless 2025-01-15 14-23-251678×760 109 KB

Query:

REST Console - ConsoleDemo - Backendless 2025-01-15 14-22-25
REST Console - ConsoleDemo - Backendless 2025-01-15 14-22-252350×1674 321 KB

5

{
“code”: 1025,
“message”: “There seems to be an issue with the query. Please check the following sections for potential errors:\n- SELECTED properties: \n- WHERE clause: SnowClosure after ‘01/12/2025’ before ‘01/18/2025’\n- ORDER BY: \n- GROUP BY: \n- HAVING clause: \nHint: Offending token ‘before’ is placed between ‘‘01/12/2025’’ and ‘‘01/18/2025’’, probably expected a token ‘2’.\nPlease review these parts of your query and try again.”
}

Inline image

I have this column I want to be able to get all rows between specific dates in this column.

in the rest console I put in SnowClosure after ‘01/12/2025’ before ‘01/18/2025’ and the error I get … “Code”: 1025 (( whole error at top, it wont paste down here))

6

Could you post the text of the entire query you’re testing?

7

Inline image

Have to do this once a week to see which ones were closed that week. I noticed there really isn’t any reporting software so I figure I need to do some kind of where query and download it as a pdf.

8

The syntax is incorrect. It should be:

ColumnName after 'date' AND ColumnName before 'date'
9

Sorry for hijacking this thread for something else, but is there a way to make a column in a datatable a drop down instead of typing in the values?

10

Yes, there is. See this page in the docs. Also, please create a new topic for every new question. It will help keep the conversation on point and allow others to find solutions.

Thank you.
Mark

11

My apology I will in the future… one last thing… in the Desktop preview the column I made multiple choice isn’t showing me a drop down of the choices is there something I have to do to make that happen beyond editing the column type?

12

@mark_lefler, we answered to you in this topic:

13

Ok Thank you.

| Nikita Fedorishchev Backendless Team
January 17 |

  • | - |

@mark_lefler, we answered to you in this topic: