PageBlockTable Enhancer v2.0 - And the Awesomeness Continues

[Live Demo]
Note : A newer version of this plugin is released please check the same by clicking on this link

 Well I have been working on this new component "PageblockTable Enhancer" for a while and am trying to merge all the functionality that were featured in my earlier components " Sortable Pageblock table" and "Enhanced PageBlock Table".

The version 2.0b brings in some exciting changes like inclusion of Pagination along with the Sorting capability.

Check out the demo of the newest version here




How to use?

Parameter :

  • targetPbTableIds : comma-separated Ids of the target Pageblock tables




 <c:PageBlockTableEnhancer targetPbTableIds="mid,mid2"/>    
   <apex:pageBlock >  
       <apex:pageBlockTable value="{!accounts}" var="acc" id="mid">  
         <apex:column value="{!acc.Name}"/>  
       </apex:pageBlockTable>   
        <apex:pageBlockTable value="{!accounts}" var="acc" id="mid2">  
         <apex:column value="{!acc.Name}"/>  
       </apex:pageBlockTable>     
   </apex:pageBlock>


Demo And Installation / Unmanaged Package: http://blogforce9dev-developer-edition.ap1.force.com/ProjectDetail?id=a0290000007rdwd



PS: This is a beta version of the plugin, some bug may exists, If you find one, I will be more than happy to resolve them.
Posted by at
Labels: , , , ,

19 comments:

  1. TroyApril 24, 2013 at 5:42 AM

    I'm really impressed by this! I've implemented similar functionality through Apex/Visualforce before, but this is much faster than the way I was doing it (SOQL queries).

    I have two questions/requests, though!

    1. It appears that while the checkboxes persist through pagination (awesome!), only the results on the visible page are affected if the PageBlockTable is involved in a DML action (eg. insert or update).

    2. Is there a way the arrow could be displayed by default on page load for the current sort? Obviously this would be before the user interacts with it, but being able to lay down an arrow will at least imply to end users that the form can be clicked on. Without the arrow, it's not clear that it's a sortable form. Just a suggestion!

    ReplyDelete
    Replies
    1. AviApril 24, 2013 at 8:50 PM

      I am glad that you liked it.
      This basically uses jQuery to paginate and sort the data.
      Regarding your requests
      1. I guess if a DML is issued this will submit all the records, not the visible ones.
      2. I am already working on a newer version which will have the requested feature. currently it is not supported.

      Delete
    2. TroyApril 25, 2013 at 5:08 AM

      Hey-- that's good news re: #2 :) I'll keep watching for the update!

      I should describe what my scenario is for #1, though:

      I'm using a wrapper object with two variables: a Boolean isSelected field and a Custom Object reference. Then a List of that wrapper object is being built & passed to the Visualforce PageBlockTable. isSelected is mapped to an there.

      So what I've found is that my checkbox selections persist on the page despite pagination (which is great!)-- but when I submit the form on the page, only the checkboxes I can see page are submitted. If I've checked records that I've paged away from, they won't be submitted, even though I could see the checkmarks if I paged back to them.

      Hope that makes sense :) This could be my bug on my end but I just wanted to let you know.

      Delete
    3. AviJune 23, 2013 at 10:53 PM

      @Troy version with requested feature is almost ready. Will be publishing it in this week only

      Delete
  2. UnknownApril 29, 2013 at 3:46 PM

    I get the following error and cannot install on my Dev edition, any ideas?
    line 3, column 7: Method does not exist or incorrect signature: MyHelloWorld.addHelloWorld(LIST)
    null

    ReplyDelete
    Replies
    1. AviApril 29, 2013 at 4:03 PM

      Seems like your dev org contains a Class named "MyHelloWorld" and that class is throwing error. You can either fix the class or delete the same. Or you can try this in a new org

      Delete
    2. UnknownApril 29, 2013 at 9:19 PM

      This comment has been removed by the author.

      Delete
    3. UnknownApril 29, 2013 at 9:51 PM

      This comment has been removed by the author.

      Delete
  3. UnknownApril 30, 2013 at 7:13 PM

    Installed and working in the most part for me now, excellent thanks!!

    Just a few things I was wondering how I could fix, my table has both input and output fields, from free text, picklists and checkboxes

    The sort does not work for input fields, dates or checkboxes. It works great for output fields for text values.

    I am using the mass edit script and have about 25 fields in my table which is why this is very useful. Maybe one of your previous versions has this sort function and I should just use that?

    ReplyDelete
    Replies
    1. AviMay 2, 2013 at 9:35 PM

      Well am working on a new version that will have this feature. Currently it is not supported

      Delete
  4. DawnMay 14, 2013 at 9:36 PM

    Sweet component! You've saved me a bunch of work.

    ReplyDelete
  5. dMay 24, 2013 at 8:54 AM

    Wow..uh-may-zing! Much easier to implement than I thought, I was overanalyzing the sample page that comes with the package, but I should have just read the instructions above. There was no need to remove my existing code, I just had to add the 'id' to my pageblocktable and add the line. Very cool! Thank you!

    ReplyDelete
  6. UnknownJune 4, 2013 at 7:28 PM

    It worked fine for me.

    But I have a UI issue.

    When I try to click on first column to sort. The second column is sorting.

    I dont know whats the problem.Anyone faced this issue.


    ReplyDelete
    Replies
    1. AviJune 6, 2013 at 11:29 AM

      Havent experienced something like this

      Well can you post your code somewhere ?
      So that I can have a look on the same.

      Delete
  7. sharks17June 6, 2013 at 6:06 AM

    Hi,

    Thank you for this tool. I have a question, in my sandbox I am also testing an opportunity product tool, which makes adding product to an opportunity very easy (http://www.michaelforce.org/recipeView?id=a0G30000006eVxVEAU). I'm wondering if it would be possible for both of these tools to work together. In other words when I'm in the Opportunity Product screen, I'd like to click on the column headers to sort by the different columns. Any chance of having a bit of coaching on how that would work? Thank you very much!

    ReplyDelete
  8. dJune 8, 2013 at 1:31 PM

    Hello again, is there a way of setting the default number of rows to 40, instead of 10?

    ReplyDelete
    Replies
    1. AviJune 8, 2013 at 4:08 PM

      Hi,
      Well currently this is not supported!.
      But am working on a new version and will be posting the same soon with the ability to set the page number and their options

      Delete
    2. dJune 8, 2013 at 6:54 PM

      Ok, thanks. I eagerly await the update.

      Delete
    3. AviJune 23, 2013 at 10:53 PM

      version with requested feature is almost ready. Will be publishing it in this week only

      Delete

Subscribe to: Post Comments (Atom)