Loading...
 
Features / Usability

Features / Usability


Pagination issues with LIST with TABLESORTER?

posts: 24 Australia
Bernard Sfez / Tiki Specialist wrote:

Mmm... I'm not strong with tablesorter and Tiki but I think it has it's own pagination parameters and tools.

Yes, see :
https://doc.tiki.org/Tablesorter
https://doc.tiki.org/PluginFancyTable#Sorting_Filtering_and_Paginating


Thanks Bernard,

I have a sort-of solution that works (in a hacky way) based on what you shared above:

{LIST()}
  {filter field="tracker_id" content="6"}
  {filter type="trackeritem"}
  {pagination max="1000"}
{sort mode="modification_date_ndesc"}
{OUTPUT(template="table")}
	 {column label="Name" field="name" mode="raw"}
         {column label="Status" field="status" mode="raw"}
         {column label="Department(s)" field="depts" mode="raw"}
         {column label="Description" field="desc" mode="raw"}
        {tablesorter server="n" sortable="type:reset" tsortcolumns="type:text|type:none|type:none|type:none" tsfilters="type:text|type:dropdown|type:dropdown|type:text" tspaginate="max:25"} 

{OUTPUT}

{FORMAT(name="name")}{display name="tracker_field_POW_Name" format="trackerrender"}{FORMAT}
{FORMAT(name="status")}{display name="tracker_field_POW_Status" default=""}{FORMAT}
{FORMAT(name="depts")}{display name="tracker_field_POW_Depts" default=""}{FORMAT}
{FORMAT(name="desc")}{display name="tracker_field_POW_Desc" default=""}{FORMAT}

{ALTERNATE()}{REMARKSBOX(type="warning" title="There are no line items that can be displayed." close="n")}{REMARKSBOX}{ALTERNATE}
{LIST}


So

tspaginate="max:25"


works on the table to paginated, but the number of results returned Overall depends on

{pagination max="1000"}


I looked up whether I can make pagination max a dynamic number based on the number of of results returned. I read somewhere that you can use something like $count. So I tried this but it failed. Any idea how I can get this right?

{pagination max="$count"}


Thanks,

Leena