Ignited DataTables

[eluser]umefarooq[/eluser]
really great but it is not replacing space between words, well i have put

Code:

 

working.

[eluser]ηυмвєяσηє[/eluser]
hey everybody,
i've made a video about installing IgnitedDatatables and its usage in very limited time =).

Video : http://bit.ly/iXvRfk

Regards,
Yusuf

[eluser]GreatSlovakia[/eluser]
[quote author="ηυмвєяσηє" date="1308421296"]hey everybody,
i've made a video about installing IgnitedDatatables and its usage in very limited time =).

Video : http://bit.ly/iXvRfk

Regards,
Yusuf[/quote][offtopic]How... in... the... word... do... you... survive... in... dreamweaver...!?!? :S I would seriously advise you to look at the alternatives...[/offtopic] Now a bit more ontopic, these videos only tend to be useful if you record some audio with them as well, though I don't like doing that either

[eluser]skergetd[/eluser]
Hello, i have a situation here... I am using datatables+igniteddatatables and serverside processing on them. Now I want to apply filter on datatables. Not ordinary but extended filter. Example...filter on price range (show me records between 100-5000). Another one...I have a column with status and would like to filter on lets say 2 statuses (Available,Sold,For sale, Other and would like to show records that match Available and For sale). For now I am filtering like this

Code:

oTable.fnFilter(x, x);

But this only works for one match from specific column. And regex in this filter doesnt work.
Could anyone advise me how to do that? Is this even posible?

[eluser]ηυмвєяσηє[/eluser]
Hey skergetd,

You can push data to ajax like this (use aoData.push):

Code:

'fnServerData': function(sSource, aoData, fnCallback)
  {
    aoData.push( { "name": "filter_min", "value": "100" },
                 { "name": "filter_max", "value": "5000" } );
    $.ajax
            ({
              'dataType': 'json',
              'type'    : 'POST',
              'url'     : sSource,
              'data'    : aoData,
              'success' : fnCallback
            });
   },

Code:

function listener()
    {
      $this->datatables
        ->select('id, name, email, age')
        ->from('tbl_profile');

      $this->datatables->where('age >', $this->input->post('filter_min'));
      $this->datatables->where('age <', $this->input->post('filter_max'));

      $data['result'] = $this->datatables->generate();
      $this->load->view('ajax', $data);
    }

This should work..

[eluser]iwizard[/eluser]
Is there anyway we can use SQL grouping (group_by) ?
I can't find any in the library code.

Code:

$this->datatables->group_by('xxx')

[eluser]ηυмвєяσηє[/eluser]
you should use 'GROUP BY' in subqueries.

For Example :

Code:

$this->load->library("Datatables");

$this->datatables
->select('pages.id as pageid, title')
->from('(SELECT id,title,user_id FROM pages GROUP BY user_id) as pages')
->join('users', 'users.id = pages.user_id', 'left' )
->select('username');

echo $this->datatables->generate();

its not a very good example but i think u got the idea ^^

Regards,
Yusuf

[eluser]ηυмвєяσηє[/eluser]
Ignited Datatables v0.5.3 released, added mDataProp support for Datatables v1.8.1+


Regards,
Yusuf

[eluser]iwizard[/eluser]
Hi,

I've tried this in where clause:

Code:

$this->datatables->where("(tractivity.activestatus=1 and tractivitysubscriptions.userid = '" . $_SESSION['userid'] . "' and activitytype=1) or (tractivity.activitytype=0 and tractivity.activestatus=1) or (tractivity.userid='" . $_SESSION['userid'] . "')");

The result is correct but somehow I can't use the datatable search feature.
It's processing but didn't get a correct search result.

I wonder where's the problem in this?
Btw, the subquery was great... many thanks.

Thanks in advanced
Andry

[eluser]ηυмвєяσηє[/eluser]
Hello,

Try :

Code:

$this->datatables->where("((tractivity.activestatus=1 and tractivitysubscriptions.userid = '" . $_SESSION['userid'] . "' and activitytype=1) or (tractivity.activitytype=0 and tractivity.activestatus=1) or (tractivity.userid='" . $_SESSION['userid'] . "'))");