Hi i need help with this if statement

mosiahazuaje2019

i have this colomns configuration
columns: [
{data: 'departments.name'},
{data: 'phases.name'},
{data: 'date_start'},
{data: 'date_close'},
{data: 'users.name'},
{data: 'debtors.name'},
{data: 'states.name'}
],

and i need to do somthing like

          if({data:'states.name' === 'Aproved' }){
              {data:'states.name', className:'aproved'}
          }

How can i change the className of my column with if statement, somebody can help?? thanks...

rf1234

That means you want to assign a className to individual cells depending on their contents. Try using this:
https://datatables.net/reference/api/cell().node()

The example should point you in the right direction.

You can check the contents with this:
https://datatables.net/reference/api/cell().data()

And to loop through the cells this would be the best option:
https://datatables.net/reference/api/cells().every()

This looks very much like what you require:

rf1234

This should do the job I guess:

table.column( 6 ).cells().every( function () {
     if ( this.data === 'approved' ) {
        $(this.node()).addClass( 'approved' );
     } else {
        $(this.node()).removeClass( 'approved' );
     }
} );

mosiahazuaje2019

Thanks a lot rf1234

rf1234

you are welcome! I personally don't like to have column indexes "hard coded" like in the above code. You could assign an id to the column in your HTML and use that as the selector.

Like this for example:

<th id="status">Status</th>

table.column('#status').cells().every( function () { ...

mosiahazuaje2019

oh i think is better, however i need only change the background color for one, something like that .