why back button disappear
Hi Yaniv.
Ok i've tested your DB and your query service.
You have 3 items in your collection:
precode
1 2014-06-29 10:00:00.000 - 2014-06-29 14:20:00.000
2 2014-06-29 18:30:00.000 - 2014-06-29 22:00:00.000
3 2014-06-29 18:30:00.000 - 2014-06-29 22:00:00.000
/code/pre
So here is a tests:
1 test:
Test date:
2014-06-29 11:00:00.000 - 2014-06-29 12:00:00.000 - not overlaped with 2nd and 3rd items.
request would be:
precode
{
"$or": [
{"$and": [ {"EventStartDate": {"$gt": "2014-06-29 11:00:00.000"} }, {"EventEndDate": {"$gt": "2014-06-29 12:00:00.000"} } ] },
Code: Select all
{"$and": [ {"EventStartDate": {"$lt": "2014-06-29 11:00:00.000"} }, {"EventEndDate": {"$lt": "2014-06-29 12:00:00.000"} } ] } ]
}
/code/pre
And it should return 2 items: http://prntscr.com/3rn5ls/direct
Passed OK.
2 test:
Test date:
2014-06-29 14:21:00.000 - 2014-06-29 14:22:00.000 - not overlaped with all three items.
request would be:
precode
{
"$or": [
{"$and": [ {"EventStartDate": {"$gt": "2014-06-29 14:21:00.000"} }, {"EventEndDate": {"$gt": "2014-06-29 14:22:00.000"} } ] },
Code: Select all
{"$and": [ {"EventStartDate": {"$lt": "2014-06-29 14:21:00.000"} }, {"EventEndDate": {"$lt": "2014-06-29 14:22:00.000"} } ] } ]
}
/code/pre
And it should return 3 items: http://prntscr.com/3rn6wi/direct
Passed OK.
3 test:
Test date:
2014-06-29 18:31:00.000 - 2014-06-29 18:32:00.000 - not overlaped with 1st item.
request would be:
precode
{
"$or": [
{"$and": [ {"EventStartDate": {"$gt": "2014-06-29 18:31:00.000"} }, {"EventEndDate": {"$gt": "2014-06-29 18:32:00.000"} } ] },
Code: Select all
{"$and": [ {"EventStartDate": {"$lt": "2014-06-29 18:31:00.000"} }, {"EventEndDate": {"$lt": "2014-06-29 18:32:00.000"} } ] } ]
}
/code/pre
And it should return 1 item: http://prntscr.com/3rn7xk/direct
Passed OK.
Also i've tested other test cases and all was passed ok.
Note: If you want to see only "count" without all items information please add to your request parameter "count" with value "1" http://prntscr.com/3rn8ky/direct
Regards.