Search

Hi, The data merge is doing by the server script. There is now way to show the Data of two rows in the editor? Andreas

This question was answered here: https://datatables.net/forums/discussion/53055/hidden-tables-made-visible-lose-formatting#latest Kevin

designation is coming from transaction table code for retrieving data to front end is like this th= user.getDataValue('po_value') if(user.getDataValue('transaction_tbls').length > 0) for tr in user.getDataValue('transaction_tbls') th= (tr['dataValues'])['designation'] th= (tr['dataValues'])['quantity'] th= (tr['dataValues'])['rate'] else th th th

This is a bug in the current release of KeyTable which the web-site demo is using I'm afraid. Its resolved with the nightly and I'm going to release that alongside Editor 1.8 by the end of this week. Allan

Hi @rdm , The problem is that you had data() before the search on the first post - your second doesn't. Your second post is right, or you could have a single draw(), like this: table.column(1).search('Engineer'); table.column(2).search('San'); table.draw(); See the example here. Cheers, Colin

Thanks @colin I will check that.

My last part that I need to figure out is how to remove any offices that have a "0" value, but I can spend some time figuring that out. Thank you for your help.

Hi @mpalmer , Looking at a combination of this thread and this one, this should work: Field::inst( 'perm_id' ) ->setFormatter( function ( $val, $data, $opts ) { return $val ? '' : $data['projname']; } ) Cheers, Colin

Hi @Nina111 , As you can see, it works in that example, so it's something wrong with your code - but without seeing it, there isn't much we can do. We're happy to take a look, but it would help, as per the forum rules, if you could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here. Cheers, Colin

Hi @WalterKuhn , This thread here may help. Cheers, Colin