Page 2 of 3

Correct syntax for database request

Posted: Mon Feb 23, 2015 4:44 pm
by Evgene Karachevtsev

Hello Joe,

Please check your MessagesDB_statusupdate_list_service now. I just set up method POST instead of GET in Settings. Now response looks like good response.


Correct syntax for database request

Posted: Thu Feb 26, 2015 12:13 pm
by Joe Bohen

Hi Evgene, Thanks for the information. The data returned does not take into account the between date parameters. Is this possible?


Correct syntax for database request

Posted: Thu Feb 26, 2015 8:40 pm
by Evgene Karachevtsev

Joe,

As I can see you haven't search between 2 dates at your 'where' parameter now http://gyazo.com/6e8324cbb3d118f46478...
Please try to add them


Correct syntax for database request

Posted: Fri Feb 27, 2015 5:40 pm
by Joe Bohen

Hi I have a greater than parameter in the where clause this doe's not appear to have any effect on the query!

http://gyazo.com/3a5da08d30a2c51cfdc9...


Correct syntax for database request

Posted: Fri Feb 27, 2015 6:03 pm
by Evgene Karachevtsev

Joe,

Could you please share your data base with support and tell us its name?


Correct syntax for database request

Posted: Sat Feb 28, 2015 10:07 am
by Joe Bohen

I have shared the data base with support.


Correct syntax for database request

Posted: Sun Mar 01, 2015 9:17 am
by Joe Bohen

Do you have any update on this?


Correct syntax for database request

Posted: Sun Mar 01, 2015 10:20 am
by Illya Stepanov

Hi Joe -

Unfortunately nothing yet. We'll post an update as soon as possible.


Correct syntax for database request

Posted: Mon Mar 02, 2015 12:31 pm
by Joe Bohen

Hi do you have any news on this please?


Correct syntax for database request

Posted: Mon Mar 02, 2015 1:55 pm
by Evgene Karachevtsev

Hello Joe,

Unfortunately it seems to be a bug we are working on it
For the more:
1) you had wrong url for your service
2) also there should be method GET instead of POST