Search

have different renderings in columns.render for the two buttons

Hi @CrazyTester , If you just want to reference the files on the server, you can use columns.render to create a link to that file. That's likely to be easiest option. Cheers, Colin

my code with query: $column_search =array('att.emp_id','u.Name','date_format(att.added_date, "%d-%m-%Y")','pg.key_geographic_area','TIMESTAMPDIFF(HOUR,min(att.added_date),max(att.added_date))','min(att.added_date)','max(att.added_date)'); $column_order = array(null,'att.emp_id','u.Name','date_format(att.added_date,

Hi @wicebu , Another way that you could make work for both is to use columns.render - you can set the data to be whatever you like. Cheers, Colin

Hi @nofx , another option is to use columns.orderData so redefined what a sort to the Position column should do. See this example here. Cheers, Colin

Checkout this page: https://datatables.net/manual/data/renderers You will want to use columns.render. Kevin

be better of using columns.render. Something like this example:

Hi @julliaathayde , This blog post here talks about time (and date) formatting using the Moment.js library. You can also use columns.render to change how your data looks. Hopefully that'll do the trick, Cheers, Colin

and images) then use columns.render. There is a details

Hi @beerygaz , You can use a regular expression column search with this column().search() and add "^" to the start of the search string - that will only match when that string is at the beginning. Cheers, Colin