ICEfaces
  1. ICEfaces
  2. ICE-10811

ace:dataTable add support for ranged filtering

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 4.0
    • Fix Version/s: 4.1
    • Component/s: ACE-Components
    • Labels:
      None
    • Environment:
      Any
    • Assignee Priority:
      P1

      Description

      Add the ability to filter rows based on a range of values for a given column, so that all values within the specified minimum and maximum values are matched and rendered on the page. This would only apply to numerical and Date types.
      1. test.html
        1 kB
        Arturo Zambrano

        Issue Links

          Activity

          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46074 Thu Oct 08 15:04:48 MDT 2015 art.zambrano ICE-10811 added support for range filtering to ace:dataTable
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/model/table/LazyDataModel.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTable.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableDecoder.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ProxiedBodyColumn.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/Column.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/PropertyConstraintPredicate.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ColumnMeta.java
          Commit graph ADD /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/RangeConstraintPredicate.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ColumnType.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableHeadRenderer.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46076 Mon Oct 12 15:32:49 MDT 2015 art.zambrano ICE-10811 changed attribute name from 'filterRange' to 'rangeFilter'; modified lazy mode approach for range filtering; added special controls for boolean filter inputs; added fix to date filtering inputs to make the max date cover the entire number of seconds in that day, instead of just the first second; restricted input of number types to only allow numbers, the decimal point and the minus sign
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/model/table/LazyDataModel.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTable.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ProxiedBodyColumn.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/PropertyConstraintPredicate.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ColumnMeta.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/resources/icefaces.ace/datatable/datatable.js
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/RangeConstraintPredicate.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableHeadRenderer.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46080 Tue Oct 13 11:11:52 MDT 2015 art.zambrano ICE-10811 added 'Filtering Dates' and 'Filtering Ranges' showcase demos
          Files Changed
          Commit graph ADD /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/webapp/resources/examples/ace/dataTable/dataTableFilteringRanges.xhtml
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/java/org/icefaces/samples/showcase/view/menu/data/CentralDataList.java
          Commit graph ADD /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/java/org/icefaces/samples/showcase/example/ace/dataTable/DataTableFilteringRanges.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/resources/org/icefaces/samples/showcase/view/resources/messages.properties
          Commit graph ADD /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/java/org/icefaces/samples/showcase/example/ace/dataTable/Event.java
          Commit graph ADD /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/webapp/resources/examples/ace/dataTable/dataTableFilteringDates.xhtml
          Commit graph ADD /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/java/org/icefaces/samples/showcase/example/ace/dataTable/DataTableFilteringDates.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46082 Wed Oct 14 11:24:57 MDT 2015 art.zambrano ICE-10811 fixed input issues in number filter fields and removed ".0" at the end of the value for float and double types, unless an actual fraction is specified
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/resources/icefaces.ace/datatable/datatable.js
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableHeadRenderer.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46083 Wed Oct 14 11:36:33 MDT 2015 art.zambrano ICE-10811 added bean bindings to filter values, in order to prevent disappearing input issues
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/webapp/resources/examples/ace/dataTable/dataTableFilteringRanges.xhtml
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/java/org/icefaces/samples/showcase/example/ace/dataTable/DataTableFilteringRanges.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/webapp/resources/examples/ace/dataTable/dataTableFilteringDates.xhtml
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/java/org/icefaces/samples/showcase/example/ace/dataTable/DataTableFilteringDates.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46098 Mon Oct 19 21:18:58 MDT 2015 art.zambrano ICE-10811 fix for exception issue with boolean column type; fix for issue with not being able to clear filter values; fix for avoiding popping up the calendar right after clearing the value; fix to support other non-character keys in number filter fields like delete, arrows keys, etc.; changed spelling of attribute from rangeFilter to rangedFilter; change for not having to use all capital letters in the type attribute; fix to make the boolean menu start in an unset state instead of false; removed logging comments
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTable.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ProxiedBodyColumn.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/Column.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/PropertyConstraintPredicate.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/column/ColumnMeta.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/resources/icefaces.ace/datatable/datatable.js
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/RangeConstraintPredicate.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableHeadRenderer.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46099 Mon Oct 19 21:21:25 MDT 2015 art.zambrano ICE-10811 updated demo pages after recent changes
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/webapp/resources/examples/ace/dataTable/dataTableFilteringRanges.xhtml
          Commit graph MODIFY /icefaces4/trunk/icefaces/samples/showcase/showcase/src/main/webapp/resources/examples/ace/dataTable/dataTableFilteringDates.xhtml
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46117 Thu Oct 22 14:59:20 MDT 2015 art.zambrano ICE-10811 fix to render option labels of the boolean as inner text instead of using the label attribute, in order to make labels visible on FF
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableHeadRenderer.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46184 Thu Nov 05 13:46:12 MST 2015 art.zambrano ICE-10811 added keycodes for the number pad keys; fix for allowing to submit a date by pressing enter; added the specified date pattern as an inField label so that users who want to type a date know which format to use
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/resources/icefaces.ace/datatable/datatable.js
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/DataTableHeadRenderer.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46210 Tue Nov 10 15:29:09 MST 2015 art.zambrano ICE-10811 check for null before setting the min and max value filters, in order to avoid losing the submitted value
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46214 Thu Nov 12 10:30:57 MST 2015 art.zambrano ICE-10811 fix for issue with not being able to clear the ranged filter fields; fix for including rows whose filter property is equal to the min or max filter values
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/RangeConstraintPredicate.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46227 Mon Nov 16 20:34:17 MST 2015 art.zambrano ICE-10811 fix consisting of sending the filtering request from inside a timeout function and keeping a reference to such timeout function for clearing the timeout (and thus preventing the filtering request) when another filtering request is triggered within 200 milliseconds from the first one, in order to prevent javascript errors due to certain objects not found due to not having been set up yet
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/resources/icefaces.ace/datatable/datatable.js
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46231 Tue Nov 17 10:54:49 MST 2015 art.zambrano ICE-10811 refactored fix for including dates that are exactly the specified minimum/maximum dates to make it work consistently
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/util/collections/RangeConstraintPredicate.java
          Repository Revision Date User Message
          ICEsoft Public SVN Repository #46253 Thu Nov 19 15:28:27 MST 2015 art.zambrano ICE-10811 added a different way of detecting when the date filter fields are empty, since empty strings are not submitted in these cases, unlike the other filter types
          Files Changed
          Commit graph MODIFY /icefaces4/trunk/icefaces/ace/component/src/org/icefaces/ace/component/datatable/FilterState.java

            People

            • Assignee:
              Arturo Zambrano
              Reporter:
              Arturo Zambrano
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: