Search
11455 results 2141-2150
Forum
- 12th Nov 2014Filter datatables based on where clausei would like my table to display only data related to the user that is loggged in employer's id. when i hard code it, it works but how do i make it dynamic? my php code below works, how do i make it work without hard coding the value. ->where($key = "active", $value = 'yes', $op = "=") ->where($key = "employer_id", $value = "344" , $op = "=") ->process( $_POST ) ->json();
- 26th Oct 2014Problem when inserting header and filter by columnI'm trying to dynamically insert search by column and the header, but it is appearing only search by column. What is wrong in my code? var dataSet = [ ['Trident', 'Internet Explorer 4.0', 'Win 95+', '4', 'X'], ['Trident', 'Internet Explorer 5.0', 'Win 95+', '5', 'C'], ['Trident', 'Internet Explorer 5.5', 'Win 95+', '5.5', 'A'], ['Trident', 'Internet Explorer 6', 'Win 98+', '6', 'A'], ['Trident', 'Internet Explorer 7', 'Win XP SP2+', '7', 'A'], ['Trident', 'AOL browser (AOL desktop)', 'Win XP', '6', 'A'], ['Gecko', 'Firefox 1.0', 'Win 98+ / OSX.2+', '1.7', 'A'], ['Gecko', 'Firefox 1.5', 'Win 98+ / OSX.2+', '1.8', 'A'], ['Gecko', 'Firefox 2.0', 'Win 98+ / OSX.2+', '1.8', 'A'], ['Gecko', 'Firefox 3.0', 'Win 2k+ / OSX.3+', '1.9', 'A'], ['Gecko', 'Camino 1.0', 'OSX.2+', '1.8', 'A'], ['Gecko', 'Camino 1.5', 'OSX.3+', '1.8', 'A'], ['Gecko', 'Netscape 7.2', 'Win 95+ / Mac OS 8.6-9.2', '1.7', 'A'], ['Gecko', 'Netscape Browser 8', 'Win 98SE+', '1.7', 'A'], ]; var $table = $("table#column-filtering"); oTable = $table.dataTable({ "aaData": dataSet, "aoColumns": [ { "bSearchable": true, "sTitle": "Engine", "sClass": "center", "bSortable": true }, { "sTitle": "Browser" }, { "sTitle": "Platform" }, { "sTitle": "Version", "class": "center" }, { "sTitle": "Grade", "class": "center" } ], "oLanguage": { "sProcessing": "Processando...", "sLengthMenu": "Mostrar _MENU_ registros", "sZeroRecords": "<div style='text-align: center;font-weight: bold; height: 50px; line-height: 50px;'>Não foram encontrados resultados</div>", "sInfo": "Mostrando de _START_ até _END_ de _TOTAL_ registros", "sInfoEmpty": "Mostrando de 0 até 0 de 0 registros", "sInfoFiltered": "", "sInfoPostFix": "", "sSearch": "Buscar:", "oPaginate": { "sFirst": "Primeiro", "sPrevious": "Anterior", "sNext": "Seguinte", "sLast": "Ãltimo" } } }).columnFilter({ sPlaceHolder: "head:before", aoColumns: [ { type: "select", values: ['Gecko', 'Trident', 'KHTML', 'Misc', 'Presto', 'Webkit', 'Tasman'] }, { type: "text" }, null, { type: "number" }, { type: "select" } ] });
- 10th Oct 2014Getting datatables object in a variable so that I can change the ajax url and reload with new filterI know you can do this with server side processing turned on but that looks too tricky for me right now. So please look at this code. http://jsfiddle.net/o00yLj47/ you will see what isn't working. Any ideas guys? This datatable is in a modal. Behind the modal is a different datatable as well with a different name so I don't think that would cause conflicts.
- 30th Sep 2014Need to update some values when the search filter is applied.Here is my example table. Artist | Service | Cash | Credit | Expense | Date | Description A | Services | 400 | 200 | 100 | 09/29/2014 | user test. jonn | test | 100 | 0 | 0 | 09/29/2014 | sample sale Steve | tattoo | 100 | 0 | 0 | 09/30/2014 | mermaid Steve | piercing | 0 | 50 | 0 | 09/30/2014 | Nose Showing 1 to 4 of 4 entries Total Cash: $600 Total Credit: $250 Total: $750 WHEN the search filter(Steve) is applied,Total Cash, Credit, Total should get calculated once again. How can we do this? Artist | Service | Cash | Credit | Expense | Date | Description Steve | tattoo | 100 | 0 | 0 | 09/30/2014 | mermaid Steve | piercing | 0 | 50 | 0 | 09/30/2014 | Nose Showing 1 to 2 of 2 entries (filtered from 4 total entries) Total Cash: $600 Total Credit: $250 Total: $750 Please let me know how to implement this. Thanks, AK
- 26th Sep 2014Change Filter behaviorHello, we are using this Code: aoColumns: [ null, { sSelector: "#filter_a", type: "date-range" }, { sSelector: "#filter_b", type: "select", values: [ ] }, null, null, null, null, null, null, null, null ] }); var $options = $("#filter_b").find("select > option").clone(); $('#pilotnames') .empty() .append($options); It will output all Names. How it is possible that we change select box to a special value who no one could change? I mean how it is possible to insert the filter_b value with no selector? So How it is possible to replace the type "select" to a fix value?
- 22nd Sep 2014Alignment between column filter and body:Hi, I've added sPlaceHolder: "head:before" for datatable. After adding the alignment between column header and body will be mismatched. Can you please let me know what to do for alignment? Kindly waiting for your response. Thanks, Santosh
- 19th Sep 2014Column filter for special charactersIs there any example for datatable columnFilter for special characters?
- 9th Sep 2014Is there a way to order filter results by the 'most relevant' result.For example we have a value "Unclassified" that always appears at the bottom when a user searches "un" due to the default order being ascending. As "unclassified" includes the characters "un" earlier in the string than, say, "duncan" I'd like it to appear at the top. All of the examples I've been looking at apply custom sorting to the table regardless of whether or not it has been filtered.
- 30th Aug 2014Datatable filter huge amount of datasetsfilering stuff there. Because filtering on server-side based on
- 15th Aug 2014Filter parameter sent by fnFilter is empty (server side processing)Hi everybody, just a short question: I'm using server side processing and would like to use an external search field for a global search. The global search is initiated through a key up event on a text field which then calls the fnFilter function of the datatable. But on the server I can only see an empty string. If I use the internal global search field it is working. Is there any additional setting which is neccessary? Cheers, Chris