DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
Examples
Manual
Reference
Extensions
Plug-ins
Blog
Forums
Discussions
Sign In
Support
FAQs
Download
Purchase
≡
Show site navigation
Add a column to the table that is not a database column
Add a column to the table that is not a database column
diogogmt
Posts: 1
Questions: 0
Answers: 0
July 2011
edited July 2011
in
General
I'm trying to add a new column to the table, that is not a database column.
I can't find any examples.
Any help is appreciated.
Thanks.
Replies
fbas
Posts: 1,094
Questions: 4
Answers: 0
July 2011
edited July 2011
1) You can tell your database to use the same field twice, then you can edit one of those fields at will, i.e. with
fnRender
or any other callback function.
http://www.datatables.net/forums/discussion/5862/creating-an-action-column-for-icons-view-edit-delete#Item_6
2) You could also use database functions in your SQL / DataTables fields
[code]
SELECT id, name_last, name_first, rand() as r FROM sometable;
[/code]
3) your server side code can add an entry into your
aaData
anywhere you like with whatever value you like
This discussion has been closed.
Sign In
·
Register
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Quick Links
Categories
Recent Discussions
Unanswered
Categories
74.3K
All Categories
56
Priority support
24K
Free community support
997
General
14
Announcements
2.5K
DataTables
79
DataTables 2
1.3K
DataTables 1.10
92
DataTables 1.9
35
DataTables 1.8
9
CloudTables
2.2K
Editor
2.8K
Extensions
20
AutoFill
310
Buttons
50
ColVis
30
DateTime
68
FixedColumns
50
FixedHeader
32
ColReorder
30
KeyTable
103
Responsive
23
RowReorder
42
Scroller
163
SearchBuilder
193
SearchPanes
107
Select
26
StateRestore
22
TableTools
220
Bug reports
67
Feature requests
100
Plug-ins
11
Blog
69
Web-site
Replies
http://www.datatables.net/forums/discussion/5862/creating-an-action-column-for-icons-view-edit-delete#Item_6
2) You could also use database functions in your SQL / DataTables fields
[code]
SELECT id, name_last, name_first, rand() as r FROM sometable;
[/code]
3) your server side code can add an entry into your aaData anywhere you like with whatever value you like