英文:
Is there any way to implement sorting and searching data from client side in AG-Grid?
问题
我想在网格中显示来自API的数据。所以我们已经在.NET Core C#中创建了API。
为了显示数据，我们在Angular中使用AG grid。
API已经在服务器端创建了分页。现在我想在AG Grid Angular中从客户端实现排序和搜索。
英文:
I want to show data in grid from API. so we have created API is in .NET Core C#.
For showing up data we are using AG grid in Angular.
API is created with pagination in server side. Now I want to implement sorting and searching from client side in AG Grid angular.
答案1
得分: 1
这不是在服务器端分页时使用客户端搜索和排序的最佳方法。您将只对当前页面上的数据进行排序或搜索，而忽略了所有其他行。
尽管如此，您可以启用客户端排序，通过将可排序参数添加到您的列定义中：
<ag-grid-angular
[columnDefs]="columnDefs"
/* 其他网格选项 ... */
</ag-grid-angular>
// 仅在 'name' 和 'age' 列上启用排序
this.columnDefs = [
{ field: 'name', sortable: true },
{ field: 'age', sortable: true },
{ field: 'address' },
];
您还可以使用 AG Grid 的快速过滤器来启用搜索：
<input
type="text"
id="filter-text-box"
placeholder="筛选..."
(input)="onFilterTextBoxChanged()"
/>
private gridApi!: GridApi;
onFilterTextBoxChanged() {
this.gridApi.setQuickFilter(
(document.getElementById('filter-text-box') as HTMLInputElement).value
);
}
英文:
It's not the best approach to use client side search and sorting when you have a server side pagination.
What you will get is that you will sort or search only the data you currently have in the page, leaving out all the other rows.
Still, you can enable client side sorting, adding the sortable parameter to your column defs:
<ag-grid-angular
[columnDefs]="columnDefs"
/* other grid options ... */>
</ag-grid-angular>
// enable sorting on 'name' and 'age' columns only
this.columnDefs = [
{ field: 'name', sortable: true },
{ field: 'age', sortable: true },
{ field: 'address' },
];
And you can enable searching using AG Grid Quick Filter:
<input
type="text"
id="filter-text-box"
placeholder="Filter..."
(input)="onFilterTextBoxChanged()"
/>
private gridApi!: GridApi;
onFilterTextBoxChanged() {
this.gridApi.setQuickFilter(
(document.getElementById('filter-text-box') as HTMLInputElement).value
);
}
答案2
得分: 1
如果您想要服务器端分页，必须在服务器端使用排序和筛选。
英文:
if you want server-side pagination, you must use sorting and filter server side.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论