Hi, My invoice table contains data from april to june . So when I query my invoice table from the database with this query: {"$and":[{"posId":"pos001"},{"year":"2015"},{"status":"completed"}]} I get all the data from april - june....

Database service does not give all the value irrespective of the query I write. I'm trying to get the total sales for the current year for all the transactions that are completed to achieve this I use this query in the where clause of the db service: return '{"$and":[{"posId":&qu...