Implementing Datatables in Django

Posted on

datatables

 

DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, built upon the foundations of progressive enhancement, that adds all of these advanced features to any HTML table.

I've been using this plug-in for almost every project that I'm involve with. It has a built-in search, sorting and pagination facility. Less hassle and simple to implement specially in dealing with huge datasets such as 100,000+ or even millions. It's UI can be in Bootstrap, among others.

Implementing it in Django requires proper format, it should follow the required structure of JSON and the table itself.

Django views.py and urls.py

Create a function in views.py that will handle sorting, searching and pagination of your table. To start,


In your HTML file.

Some common error encountered is on columns, make sure the index are properly matched!

Comments

Post a Comment

Feel free to ask, suggest and comment regarding this post/blog. You can also contact me through e-mail, just always use the contact page. Thank you for visiting this blog.

Popular posts from this blog

A Better Archive Page for Blogger

Posted on
Image
This is for me, the better Archive Page. Let's see the how it looks. or you can just click my ARCHIVE PAGE in the navigation bar on top. This has cool feature also: Sort by title (ascending or descending) - by clicking the "POST TITLE" table header. Sort by date (older first or newer first) -  by clicking the "POST DATE" table header. Option to show all post by Label When you hover the post title a snippet of the post will display. Things that it doesn't have, which is acceptable: You can't change the date format You can't change table header unless you edit the script. Here's how to implement it. 1. Create a Page           For New Blogger Interface: Dashboard > Pages > New Page > Blank Page           Put a title, of course, like "Archive". :D 2. HTML Tab > Paste the code below <div id="bp_toc"> Loading TOC. Please wait....</div> <script src="http:/
Read more

Publish PostGIS Layers in GeoServer Automatically using cURL and REST

Posted on
Disclaimer: The idea came from this blog . So, what's the difference? I'm using Windows.  cURL should be installed already. If you have lots of tables in your database that you wanted to publish in GeoServer, you can use this method. Just prepare a list of tables (separated by new line) you want to publish in a text file format. Before proceeding in publishing layers, you need to setup a workspace and store in your GeoServer first. Although this can be done using cURL and REST API, but it is more convenient in that way. After a minute.... :D :D Create ".bat" file Use the code below but (of course) change the necessary inputs for /f %%a in ( <list of tables you want to publish> .txt) do  curl -v -u <username> : <password>   -XPOST -H "Content-type: text/xml" -d "<featureType><name>%%a</name></featureType>" http://localhost:8080/geoserver/rest/workspaces/ <name of workspace> /datastores/
Read more

BECK Live Action

Posted on Post a Comment
Image
After watching this manga-inspired movie, I was kinda disappointed because I did not hear Koyuki's voice. Simply because it was muted for the reason that his voice, as stated in the manga is like "God's voice". And theres no such person on Earth that has the God's voice. I was hoping it, at least on their final song. But, if you really want to hear Koyuki's voice you better watch the anime version of it! Anyway, it's still on my list as favorites because of Maho played by Shiori Katsuna. Some of their songs: "Moon Beams" This song is muted on the movie. My favorite song in this movie is "Evolution".
Read more