bug hunting and a (small) new set of widget code
[Evergreen.git] / Open-ILS / src / reporter / widgets.example.xml
index 5d9c556..fccc717 100644 (file)
                                This widget allows the user to pick a month relative to the
                                report runtime on which to report.
                        </description>
                                This widget allows the user to pick a month relative to the
                                report runtime on which to report.
                        </description>
+                       <filter-code type="perl">
+                               $where_clause = 
+                                       "DATE_TRUNC($full_col, 'month') = ".
+                                               "DATE_TRUNC(now(), 'month') - CAST(? || ' months' AS INTERVAL);
+                               push @$bind_list, $val;
+                       </filter-code>
                </widget>
                
                <widget name="quarter">
                </widget>
                
                <widget name="quarter">