pagination

[tmith]

Hi.

One more question (for now)!

I'm looking to integrate some/all of the UserSpice logic to handle user processes within a 3rd party app.

Part of the process will be the user viewing the results of the userspice queries. Does userspice have the ability to display "test" data for queries in a pagination format?? Or will I have to roll my own?

I'm thinking of something like the following...


                                                             page       first 2,3,4...last
+------------------------------------------------------------------------------+
+   field1    +   field2   +   field3   +   field4   +   field5   +   field6   +  
+                +              +               +              +               +              +  
+                +              +               +              +               +              +  
+                +              +               +              +               +              +  
+                +              +               +              +               +              +  
+------------------------------------------------------------------------------+


thoughts/comments???

thanks

[mudmin]

Hi.

One more question (for now)!

I'm looking to integrate some/all of the UserSpice logic to handle user processes within a 3rd party app.

Part of the process will be the user viewing the results of the userspice queries. Does userspice have the ability to display "test" data for queries in a pagination format?? Or will I have to roll my own?

I'm thinking of something like the following...


                                                             page       first 2,3,4...last
+------------------------------------------------------------------------------+
+   field1    +   field2   +   field3   +   field4   +   field5   +   field6   +  
+                +              +               +              +               +              +  
+                +              +               +              +               +              +  
+                +              +               +              +               +              +  
+                +              +               +              +               +              +  
+------------------------------------------------------------------------------+


thoughts/comments???

thanks

Yeah. We have datatables.  So give your table an id="paginate" and make sure it is properly formatted with a table head, table body etc, then at the bottom of the page put....

Code:

 <script>
    $(document).ready(function() {
        $('#paginate').DataTable(
     {
       "pageLength": 25
     }
   );
    });
</script>
    <script src="../users/js/pagination/jquery.dataTables.js" type="text/javascript"></script>
    <script src="../users/js/pagination/dataTables.js" type="text/javascript"></script>

If it doesn't look paginated then most likely you're missing tag in your formatting.