Tuesday, December 3, 2013

Easy Way To Clear ADF Table Columns Filters

In ADF table you can enable column filters just when you drag viewobject to the page and choose Table --> ADF Table
Just select Enable Filtering
Now when you run the page you will find inputtext above every cloumn in the table
You can filter the data using these inputtext above every cloumn. If you want to clear all the filters inputtext just add new cloumn to the table (put it as a first column)




 Select the new cloumn and from Property Inspector (Appearance section) set Width to "14" and RowHeader to "true"

Now run the page again you will find new icon above first column when you press this icon it will clear all columns filters and re-execute the view object query.








9 comments:

  1. is this a joke ? from where the image came to that column and how its works

    ReplyDelete
    Replies
    1. hehehe Nothing impossible in programming world :)
      This is a power of RowHeader property. If any column with RowHeader property set to true this column automatically will move to the first and will be frozen and if the column filter is appear then the small icon will automatically appear to clear the filter data this is a built in feature in af:column component.

      Delete
  2. Haha .. typical ADF implementation. Hidden and secret features. This is not straightforward. what if I dont want that extra column in my table ? It just looks odd.

    ReplyDelete
    Replies
    1. No need to add this column, you can set the first column RowHeader to "true"

      Delete
  3. didnt work.. i tried this in JDev 11.1.1.7

    ReplyDelete
    Replies
    1. Because in JDev 11.1.1.7 the ADF application use skin family not has this clear icon. If you want to enable this clear icon you should use a skin family extend "fusionFx-v1.1.desktop", I tried it and it is working fine.
      To know how to define skin family check this URL
      http://sameh-nassar.blogspot.ie/2009/10/using-skin-in-your-application.html


      have a look on this:
      https://community.oracle.com/thread/2479228?tstart=0

      Delete