3 2018-06-22T18:34:49+00:00

New wpDataTable

lftip","bSortCellsTop":false,"bFilter":true,"bPaginate":true,"aLengthMenu":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,"All"]],"iDisplayLength":10,"columnDefs":[{"sType":"string","wdtType":"string","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"newcolumn3","origHeader":"newcolumn3","notNull":false,"conditionalFormattingRules":[],"className":" column-newcolumn3","aTargets":[0]},{"sType":"formatted-num","wdtType":"int","bVisible":false,"orderable":true,"searchable":true,"InputType":"text","name":"wdt_ID","origHeader":"wdt_ID","notNull":false,"conditionalFormattingRules":[],"className":"numdata integer column-wdt_id","aTargets":[1]},{"sType":"formatted-num","wdtType":"int","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"newcolumn1","origHeader":"newcolumn1","notNull":false,"conditionalFormattingRules":[],"className":"numdata integer column-newcolumn1","aTargets":[2]},{"sType":"formatted-num","wdtType":"float","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"newcolumn2","origHeader":"newcolumn2","notNull":false,"conditionalFormattingRules":[],"className":"numdata float column-newcolumn2","aTargets":[3]}],"bAutoWidth":false,"order":[[0,"asc"]],"ordering":true,"buttons":[{"extend":"print","exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_print","text":"Print"},{"extend":"excelHtml5","exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_xls","title":"New wpDataTable","text":"Excel"},{"extend":"csvHtml5","exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_csv","title":"New wpDataTable","text":"CSV"},{"extend":"copyHtml5","exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_copy","title":"New wpDataTable","text":"Copy"}],"bProcessing":false,"serverSide":true,"ajax":{"url":"https:\/\/foodfinder1.info\/wp-admin\/admin-ajax.php?action=get_wdtable_onLoad&table_id=2","type":"POST"},"sPaginationType":"full_numbers","oSearch":{"bSmart":false,"bRegex":false,"sSearch":""}},"tabletWidth":"800","mobileWidth":"600","advancedFilterEnabled":true,"advancedFilterOptions":{"sPlaceHolder":"head:before","aoColumns":[{"type":"text","columnType":"string","numberOfDecimalPlaces":"2","possibleValuesType":"read","values":null,"origHeader":"newcolumn3","displayHeader":"new column3","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":"","rangeSlider":false},{"type":"null","columnType":"int","numberOfDecimalPlaces":"2","possibleValuesType":"read","values":null,"origHeader":"wdt_ID","displayHeader":"wdt_ID","possibleValuesAddEmpty":false,"possibleValuesAjax":-1,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":"","rangeSlider":false},{"type":"number","columnType":"int","numberOfDecimalPlaces":"2","possibleValuesType":"read","values":null,"origHeader":"newcolumn1","displayHeader":"New column1","possibleValuesAddEmpty":false,"possibleValuesAjax":-1,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":"","rangeSlider":false},{"type":"number-range","columnType":"float","numberOfDecimalPlaces":"2","possibleValuesType":"read","values":null,"origHeader":"newcolumn2","displayHeader":"New column2","possibleValuesAddEmpty":false,"possibleValuesAjax":-1,"defaultValue":["",""],"exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":"","rangeSlider":false}],"bUseColVis":true},"filterInForm":false,"serverSide":true,"autoRefreshInterval":0,"processing":true,"fnServerData":true,"columnsFixed":0,"sumFunctionsLabel":"","avgFunctionsLabel":"","minFunctionsLabel":"","maxFunctionsLabel":"Rahul","columnsDecimalPlaces":{"newcolumn3":-1,"wdt_ID":-1,"newcolumn1":-1,"newcolumn2":-1},"columnsThousandsSeparator":{"wdt_ID":0,"newcolumn1":1},"sumColumns":[],"avgColumns":[],"sumAvgColumns":[],"timeFormat":"h:i A","datepickFormat":"dd\/mm\/yy"}'/>
new column3 New column1 New column2
new column3 wdt_ID New column1 New column2
NULL 2 100 100,00
NULL 3 777 888,00
NULL 1 45 45,00
NULL 5 222 999,00
NULL 6 666 777,00
NULL 7 1.414 12.121,00
NULL 8 222 999,00
NULL 9 666 777,00
NULL 10 1.414 12.121,00
NULL 11 222 999,00