This topic is locked

how to make a list that only displays the current month

9/1/2010 11:09:04 PM
PHPRunner General questions
M
mumtaz author

How to make list that only displays the current month.

But we could still see the data for another month with Advance search.
i use this script on List Page : Before SQL Query
$strWhereClause = whereAdd($strWhereClause, "EXTRACT(YEAR_MONTH FROM TRANSDATE)=EXTRACT(YEAR_MONTH FROM NOW())");
But I can not display the data for other months.

K
kkiboo 9/2/2010

I had this problem and the only way I found a solution was to make a view of the table you are trying to list. Use the where clause on the view and keep the original table the same, just link to it when you need to search.
I don't know if this will help you, but it's what I had to end up doing. :\

Sergey Kornilov admin 9/2/2010

kkiboo is right. You need to add WHERE clause right to SQL query on 'SQL Query' screen.