Search

I have been browsing through the forum and have seen some posts like https://datatables.net/forums/discussion/comment/231766/ and https://datatables.net/forums/discussion/comment/220330. I have put together a small example (link below) that might serve as a reference to anyone else searching for this. https://stackblitz.com/edit/datatable-vue3-components

My mistake its actually rounding the value ... correct value - 64295442717783187437 displayed in excel - 64295442717783200000 Please give some advice as i am new to using data tables

My guess is you are initialising the DataTable hidden or outside the DOM. Call columns.adjust() when you make it visible. Also, add style="width:100%" to your table. I know you have w-[100%], but that isn't enough (CSS is really hard to parse in Javascript). Allan

Can confirm that both the issues have been fixed with 2.0.3. Thanks!

@allan Thanks for your support!

Yes, it will take some planning and testing to upgrade to 2.0. Kevin

Hi Allan, I did what you suggest and the position of the search input is now ok but the borders still missing. I will wait until you can check. Thanks and kind regards, Reginaldo Bray

Since you are passing an empty array to the client side "order" method which means "no client side ordering" and seem to not use Editor, this really isn't a Data Tables problem ... Looks like you have an issue generating the right SQL statement for your business problem. I would recommend you ask this on Stack Overflow. But of course you could also not do any server side ordering and do it client side: https://datatables.net/reference/option/order

Hi @allan , thanks for the code! -Abel

Thank you very much Allan