How to show all Lined-up in DataTable?

in our system all data are showed i need to filter the DataTable. and show all Lined-up only any suggest. Thanks in advance.

class="ContainerBanner">
class="orders">Orders
"OrderList" class="display table table-striped" style="width:100%">
Agent
Client
Contact#
State
Address
Date Posted
Delivery Date
Quantity
Status
Date Delivered
Notes
Deleted
"@Url.Action("add","order")" class="btn btn-primary btn-sm">class="fas fa-cart-plus"> Order a Box

"text/javascript">

$(function () {

$('#OrderList').DataTable({

"ajax": "@Url.Action("getorderlist", "order")",

"columns": [

{ "data": "AgentName"},

{ "data": "ClientFullName" },

{ "data": "PrimaryContact" },

{ "data": "State"},

{ "data": "Address" },

{ "data": "DatePosted" },

{ "data": "DeliveryDate" },

{ "data": "Quantity" },

{ "data": "Status" },

{ "data": "DateDelivered" },

{ "data": "Notes" },

{ "data": "IsDeleted"},

{

"render": function (data, type, full, meta) {

return " + full.Id + ")'>"

}

]

});

function edit(id) {

window.location.href = "@Url.Action("add", "order")?id=" + id;

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

rahul bhat7y ago
Hi, Yeah with the combination of the Razor code you can do anything in your view.
0
Denmark Puso7y ago
hi
rahul bhat
Thank you for response is it possible to hide other status but when i search its searchable ?
0
rahul bhat7y ago
well you can write the Razor code and while the Model is populating you can put a filter / condition there only on the or you the do the same from back end only.
0