Forums

Does anyone know how to create a search, pagination or sorter for the loaded db fields. I have about 1000 rows and it is hard to find specific entries. Any ideas on how I could present that data in a more useable fashion? I will post anything if I find it. Thanks.

Hunt

Pagination yes, it is here

http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=26&t=22070

For searching and sorting work is in progress 🙂

Hi,

I may prepare something for this in the next version😉

Regards,
Max

Hi,

I may prepare something for this in the next version😉

Regards,
Max

Hello Max,
Tanks for this.

I did some testing di search and pagination with multi loader.
I made some changes to files db_multi_record_loader.ctp and db_multi_record_loader.php.
They are needed for the total number of records and limitstart and limit in the query.
I added the field "postwhere" in order to submit LIMIT and ORDER BY into query.
The problem is that in the new field "postwhere" (in param) php must be entered without the CR command.

I send form, table and new files.

Is this a work in progress or is this the solution? I have a client with some pretty urgent needs and I am willing to pay the Chronoforms team to accomplish paginated results in multi db loader with the ability to search the total results from all pages. I have to admit that this is a bit over my head at the moment. Thanks for all your help guys.


Hunt

For me work is in progress, pending the new version announced by Max.

Thanks vales, I am looking forward to the next version or a solution. Thanks guys.

Found a solution to sorting tables here http://www.kryogenix.org/code/browser/sorttable/.
Thought I would post here if anyone wanted to get same results.

-Get sorttable.js from the above link.
-Add the sorttable.js file contents to the js loader in the on load section.
-Create your table in the custom code within the on load section, with the table and th classes, making sure to add the styles to your template css as outlined the tutorial.

Works great for me but only in Firefox. Cant seem to get it to work in IE, seems like I have some infinite loop, too much data or conflicting scripts. Can't pinpoint the problem if anyone has any suggestions.