Hi all,
just thought this could be useful for anybody.
I have enhanced the latest ChronoConnectivity Version 2 RC3 with the capability of frontend sorting. You can now sort all your database entries with just a single mouse click.
Feedback is greatly appreciated.
Cheers,
Eric
EDIT 1 (01.08.2010): Updated the attachment with a bug fixed version (corrected AJAX callback)
EDIT 2 (01.08.2010): Added the capability of a frontend edit ID other than the primary key
EDIT 3 (03.08.2010): Fixed a bug regarding the pagination
I downloaded and installed your version. I set frontend sorting to yes, selected the fields, etc....but nothing happened to my table. The table column names are not clickable for sorting.
Do you have instructions how to configure the sorting? or do I have to put additional codes on the header, body, footer, SQL box, etc?
Please reply.
Thanks
mod911
Hi "mod911",
actually the frontend sorting should be easy to do:
Let's say you want to connect the table "jos_content" with ChronoConnectivity and that you want to show the fields "ID, title, state", then you would simply select these columns in the FrontEnd Settings and enter the appropriate DataView Column Titles, e.g. "ID, Name, Published". Afterwards, just enter "{sorting}" in the head section of the ChronoConnectivity code, and "{id}, {title}, {state}" in the body section.
That should actually be it. You should now be able to use the frontend sorting.
Cheers,
Eric
Dear Eric,
Yeah, it works for me now! But I noticed, it gives duplicate data link names (pls see attached screen shot). Is it possible to have my existing Column Titles to be "clickable" for sorting instead? How?
Thanks,
mod911
Dear "mod911",
I actually do not know how you created your previous column titles but modifying them to be clikable would be a bit difficult, I think.
What you can do instead is to style the frontend sorting to look just like your own one. For this purpose, every ordering column is wrapped in a separated DIV container with a shared class name "sorting" and a unique class name according to the column name (e.g. "id", "title" etc).
You can check out the actual class names by using external tools like FireBug.
Hope this helps ...
Cheers,
Eric
Thanks Eric, I appreciate your help!