Search

Hello All, I hope someone could help me or throw me any idea as I could not find a call back function in the following scenario : CSV/Excel export : There is fnComplete call back function, which get called after "Save" button clicked on modal window. [quote] Is there any specific call back function that gets called when "Cancel" button clicked on modal window ? [/quote] I would like to do alerting the user after save or cancel happens. I appreciate any help! Thanks, Sri

Is it possible to style (by css class) a single cell depend on value?

Hi I wonder if it is possible to use concat or group_concat in the Datatableeditor tnks

I want to be able to hide the column headers when the query returns 0 records. But i still want to have the sEmptyTable message show in the footer. Is there a way to do this ?

good day, Could anyone please share with me how can i add more filter criteria and improve the searchable result? Thanks

form this demo "http://datatables.net/release-datatables/extras/FixedColumns/themed.html" when themed with jQuery UI then fixed column why cannot sort the first column that Fixed?

Hi Alan, I am working with datatables first time. I am making an json object in a servlet by calling methods to get object data and then bind it with json data. But I am getting below exception while executing: WARNING: executePhase(RENDER_RESPONSE 6,com.sun.faces.context.FacesContextImpl@fb6dbd) threw exception java.lang.UnsupportedOperationException: Attempted to serialize java.lang.Class: org.hibernate.proxy.HibernateProxy. Forgot to register a type adapter? I am using JSF in jsp files. Data is coming very well from data object but could not bind into json object. My code snippets: Script for datatable: function getTable() { $(document).ready(function() { $('#example').dataTable({ 'bProcessing': true, 'bServerSide': true, 'bRetrieve' : true, 'sAjaxSource': './AddNewUserTestServlet', 'bJQueryUI': true, 'aoColumns': [ { 'mData': 'firstName' }, { 'mData': 'lastName' }, { 'mData': 'email' }, { 'mData': 'subscriptionType' } ] }); } ); } function clearTable() { $('#example').dataTable().fnClearTable(); } Servlet: /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package beans; import com.google.gson.*; import datatableobject.DataTableObject; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import dbmapping.UsersTbl; import dbopr.DBInformation; import java.lang.reflect.Type; import java.util.ArrayList; import java.util.List; import java.util.Map; import javax.faces.context.FacesContext; public class AddNewUserTestServlet extends HttpServlet { /** * Processes requests for both HTTP * GET and * POST methods. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("application/json"); PrintWriter out = response.getWriter(); AddNewUser newUser=new AddNewUser(); //newUser.getCompanyName(); //Code for getting userlist according to company //List userList = null; List userList = new ArrayList(); //Getting company name from AddNewUserTest String companyName="GridAllDeveloper/pune/India"; //Search method of AddNewUser.java Integer companyId=null; //userList.clear(); DBInformation dBInformation = new DBInformation(); int userId = 0, userType = 0; if (FacesContext.getCurrentInstance().getExternalContext().getSessionMap() != null) { userId = (Integer) FacesContext.getCurrentInstance().getExternalContext().getSessionMap().get("userId"); userType = (Integer) FacesContext.getCurrentInstance().getExternalContext().getSessionMap().get("userType"); } if (companyName != null) { companyId = dBInformation.getCompanyId(companyName); if (companyId != null) { userList = dBInformation.getAllUsersByUserIdNCompanyId(userId, companyId); } } dBInformation = null; DataTableObject dataTableObject = new DataTableObject(); dataTableObject.setUserList(userList); Gson gson = new GsonBuilder().setPrettyPrinting().create(); String json = gson.toJson(dataTableObject); out.print(json); //processRequest(request, response); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); //processRequest(request, response); } private void processRequest(HttpServletRequest request, HttpServletResponse response) { throw new UnsupportedOperationException("Not yet implemented"); } } Kindly help me. Regards, Arun Singh

I'm trying out DataTables with server-side processing. It looks like DataTables replaces the entire cell with the received data. Is it possible to target specific elements or attributes inside each cell? This is what the page normally looks like: http://tl.toofz.com/Quotes/List (http://debug.datatables.net/ukijor). This is what it looks like after I enable server-side processing: http://tl.toofz.com/Quotes/Quote/ListDT (http://debug.datatables.net/acabiy). Here's a sample JSON output: [code]{ "aaData":[ [ "Leonard", "This is an incredibly quotable quote.", "8" ], [ "Marsilio", "A sturdy lad ... who teams it, farms it ... and always like a cat falls on his feet, is worth a hundred of these city dolls.", "7" ], [ "Hermann", "If you hate someone, you hate something in him that is part of yourself. What isn't part of ourselves doesn't disturb us.", "6" ], [ "Alphonse", "Every man has three characters: That which he exhibits, that which he has, and that which he thinks he has.", "5" ], [ "Elmo", "You generally hear that what a man doesn't know doesn't hurt him, but in business what a man doesn't know does hurt.", "3" ] ], "iTotalDisplayRecords":8, "iTotalRecords":8, "sColumns":null, "sEcho":"1" }[/code]

Hello, I am trying to enable multiple controls (header and footer same) with export buttons. If controls are only in footer buttons are working fine. See http://bambous.cz/DataTables/jb2.html When I enable controls for header as well [code]"sDom": '<"top"iflp<"clear">>rt<"bottom"iflp<"clear">>'[/code] buttons will disappear. See http://bambous.cz/DataTables/jb2-1.html Please advice. Thanks. Kvjetoslav

Hello, I am trying to implement TableTools and keep getting this jQuery error: "Type Issue 'undefined' is not an object (evaluating '$.extend') Issue (Image) can be seen here: http://kulersolutions.com/ls_images/error.png Any ideas?