How to filter my report based on date?

0

SELECT date as rdate,count(reviews.id) as reviewCount FROM `reviews` left join source on source.source_id = reviews.source_id left join processed_reviews on processed_reviews.id = reviews.id left join category on processed_reviews.category = category.category_id where reviews.client_id =151 and reviews.is_processed > 0 and reviews.is_deleted=0 and reviews.is_competition=0  GROUP BY rdate ORDER BY date(date)

 

 

I have this query in my ireport designer. I want this report display only those rows which relay in a date range like form 01-03-2017 to 31-03-2017, not all data in report. How Can i apply this filter in this query or iReport. Can anyone lead me. 

anjanachoudhary2111's picture
Joined: Aug 17 2017 - 11:28pm
Last seen: 2 years 1 month ago

1 Answer:

1

hey Anjana, create two filters, say start date and end date...and while writing the query pass them in between condition.

 

 

AnilSaini's picture
Joined: Feb 28 2016 - 7:34pm
Last seen: 1 year 10 months ago
Feedback
randomness