Thread

if you don’t like echoing stuff in your controller, then simply load an ajax view in that controller… and still call that controller in your sAjaxSource…

you might want to take a look at my post: http://ellislab.com/forums/viewreply/940908/ and also my explanation: http://ellislab.com/forums/viewreply/942604/

what is this ajax view? That’s the part that I don’t understand after reading this entire thread for a LONG time…thanks for replying. Please explain the ajax view (show code).

In other words, what is inside ajax.php or where is this file??

its simply a file to load all the generated json code:

application/views/ajax.php:

<?php echo $result; ?>

Oops..duh. I guess my problem is really that I have to load a view within a view since I’m using jquery tabs. Not a topic for this thread. Thanks again! Very nice work with this Library.

How to i use

find_in_set('4',user)

in where condition?

I tried following one but it shows empty row

$this->datatables
 ->select("id,name,filename",FALSE)
 ->from("tb_upload")
 ->where("find_in_set('4',user)");

Please help me

thanks in advance,Logan

try:

$this->datatables->where("find_in_set('4', user)", NULL, FALSE);

this is based on codeigniter’s user guide database->active record

on the definition of $this->db->where(), the 4th part talks about passing custom strings.

http://ellislab.com/codeigniter/user-guide/database/active_record.html

Weird Quirk disregard.  I went back and started reading some old posts in this thread.

I have a problem with OR within WHERE clause. It works when the table is initialized (the results are correct), but when trying to filter table data nothing happens.

For example, this won’t work:

->where("(departure LIKE '%SOME_VALUE%') OR (arrival LIKE '%SOME_VALUE%') ");

This will work, but I need OR, not AND.

->where("(departure LIKE '%SOME_VALUE%') AND (arrival LIKE '%SOME_VALUE%') ");

I have a problem with OR within WHERE clause. It works when the table is initialized (the results are correct), but when trying to filter table data nothing happens.

For example, this won’t work:

->where("(departure LIKE '%SOME_VALUE%') OR (arrival LIKE '%SOME_VALUE%') ");

This will work, but I need OR, not AND.

->where("(departure LIKE '%SOME_VALUE%') AND (arrival LIKE '%SOME_VALUE%') ");

Try

->where("((departure LIKE '%SOME_VALUE%') OR (arrival LIKE '%SOME_VALUE%') )");

It works! Thank you very much! 😊

I am manually changing the “iDisplayLength” to a value greater than 10 but the table will only show 10 records at a time.  Also the datatable generate function only pulls 10 records from the database.  The only way to retrieve more than 10 records from the database I had to change the iLenght value in the get_paging() function.

Is there a way to change that value to get this to work.

$('#wtable').dataTable({
            "bPaginate": true,
            "bFilter": true,
            "bSort": true,
            "bAutoWidth": false,
            "sDom": '<"top"f>t<"bottom"lip>',  
            "sAjaxSource": "<?php echo site_url('ajax/controller/get_table_data'); ?>",
   "iDisplayLength ": 50,
            "aaSorting": [[ 6, "desc" ]],
   'aoColumns' : [
    { 'sName': 'entry.publish_status', 'bSortable': false },
    { 'sName': 'entry.entry_id'},
    { 'sName': 'employee_name'},
    { 'sName': 'employee.first_name', 'bVisible': false },
    { 'sName': 'building.building_name'},
    { 'sName': 'entry.observed_by' },
    { 'sName': 'entry.date_submitted' },
    { 'sName': 'functions', 'bSortable': false },
   ],
        });

Thank you in advance.

nice post

thanks for sharing

Handicrafts products in Mumbai, India

nice information

thanks for sharing

Handicrafts Products in Mumbai,India

Trying to execute a simple callback in a helper file and it doesn’t do anything.

//leaddate = yyyy-mm-dd hh:mm:ss
$this->datatables->edit_column('leaddate','$1',format_date('leaddate'));

in helper file

if(!function_exists('format_date')){

 function format_date($tdate)
 {
    $part=explode(" ",$tdate);
    return $part[0];
  } 
}

no errors, just returns the date as if it didn’t use the function…very strange?? would actually like it to return am/pm format, but just trying to get this to work first. thanks.