Тёмный

agGrid + angular: Pagination, Sorting, Searching and filters [data table] 

CodeSpace
Подписаться 20 тыс.
Просмотров 84 тыс.
50% 1

How to do pagination, sorting, searching or filter millions of rows/datas in Angular using agGrid
agGrid : www.ag-grid.com/
agGrid series : • agGrid + angular: Pagi...
Drag, pin, resize : • agGrid + angular: mova...
------------------------------------------------
Follow me on:
►RU-vid : bit.ly/2W1X7zz
►Facebook : / e.codespace
►LinkedIn : / gourabpaul
►Twitter : / gourab_p
-----------------------------------------------
#pagination #sorting #searching

Опубликовано:

 

12 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 164   
@juangomez874
@juangomez874 6 лет назад
Excellent tutorial. Very complete, clear and concise. Very good job. It helped me a lot. Thanks
@codespace
@codespace 4 года назад
Welcome. My pleasure
@explore-learn-share6937
@explore-learn-share6937 3 года назад
Very well explained video and gives a good understanding of how to start using ag-grid
@codespace
@codespace 3 года назад
My pleasure 😊
@AmirHussain-xj5ln
@AmirHussain-xj5ln 5 лет назад
mock json url -> raw.githubusercontent.com/ag-grid/ag-grid-docs/master/src/olympicWinnersSmall.json
@codespace
@codespace 4 года назад
Thank you
@daniellaerachannel
@daniellaerachannel 5 лет назад
you saved my day thanks a lot
@codespace
@codespace 4 года назад
Welcome. My pleasure
@urbannerdz
@urbannerdz 6 лет назад
Nice tutorial. Is the AG Grid responsive for mobile devices?
@codespace
@codespace 5 лет назад
yes
@ponlakshmia3192
@ponlakshmia3192 4 года назад
Excellent video.. Looking forward for more video in ag grid angular
@codespace
@codespace 4 года назад
There are few agGrid videos in the playlist ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iGGaUQFMA08.html
@shubhasismahata4726
@shubhasismahata4726 4 года назад
Is it server side pagination ? I mean if load 1Lac data what will be happen? I want to load data as per paging request
@codespace
@codespace 4 года назад
Its a paid version available in enterprise edition www.ag-grid.com/javascript-grid-server-side-model-pagination/
@abhaybabariya1094
@abhaybabariya1094 3 года назад
Hello Sir this is a Server side pagination ? If yes then we can required to change our API code ?
@codespace
@codespace 3 года назад
It requires enterprise paid edition
@sharmafamilykvideos
@sharmafamilykvideos 4 года назад
I want dynamic async context menus, which make api call and return menus. This is possible in ag grid for angular??
@codespace
@codespace 4 года назад
Its supported, but paid www.ag-grid.com/javascript-grid-context-menu/
@AbdulSamad-fs5is
@AbdulSamad-fs5is Год назад
Question: can we convert the simple html table to ag-grid for example: i have a table like and i want to use it as it is inside this table tag so is it possible??
@kumarmahadeva3821
@kumarmahadeva3821 5 лет назад
Hi...this AngularGrid is paid right? den how can we use it??? I thought of doing column resizing and all but it is paid....how to achieve it? pls guide me
@codespace
@codespace 5 лет назад
Majority of the Ag-grid services are free. But few services are paid which are marked as "e" in there website www.ag-grid.com/
@DeepakPandey-ij3bz
@DeepakPandey-ij3bz 3 года назад
Thanks for the tutorial. Is there any way to set the page count? I don't want to fetch all the data at once. Thanks
@user-ny8nl5ib5w
@user-ny8nl5ib5w 2 года назад
Nice tutorial, Thanks. Is there any way to change labels in paginationPanel?
@riaganesha
@riaganesha 5 лет назад
Thank you so much,awesome !!
@codespace
@codespace 4 года назад
Welcome . My pleasure
@BudiSantoso-er6cq
@BudiSantoso-er6cq 5 лет назад
Thank a lot.. btw, can it be used with millions of records ?
@codespace
@codespace 5 лет назад
Yes. It can be. Aggrid takea care of everything
@BudiSantoso-er6cq
@BudiSantoso-er6cq 5 лет назад
@@codespace Thank you very much for your explanation..🙏
@markdioneeb8997
@markdioneeb8997 4 года назад
Why the columns are not auto fitted on the tables width? I really want to achieve that
@syedsalmannizami252
@syedsalmannizami252 4 года назад
How do we make a dynamic columnDef . In your demo, you are hard coding the headerNames etc . Is it possible to dynamically change the columnDefs as the data we receive ? . Hope you understood my question :)
@codespace
@codespace 4 года назад
In ag-grid the columns in gridOptions are used once at grid initialisation. If you change the columns after initialisation, you must tell the grid. This is done by calling gridOptions.api.setColumnDefs() Details of this api method are provided in the ag-grid documentation here. www.ag-grid.com/angular-grid-api/index.php
@syedsalmannizami1322
@syedsalmannizami1322 4 года назад
@@codespace Thank you for your quick response . Btw which Version of angular ru using in this tutorial ? Because when I try to replicate your steps , I'm getting an error ag-grid- community is not found or something related to that . Can't recall the exact error but it was related to that itself .
@codespace
@codespace 4 года назад
5
@syedsalmannizami252
@syedsalmannizami252 4 года назад
@@codespace Then probably it won't be compatible with version 9 right ??
@codespace
@codespace 4 года назад
Syed Salman Nizami this may b due to systemjs config
@sehajwalia7660
@sehajwalia7660 3 года назад
Hello!! I am getting a error Cant bind to 'enablesorting' since it isnt a known property of ag-grid-angular
@behroozbk
@behroozbk 5 лет назад
Great tutorial, Thank you
@codespace
@codespace 4 года назад
Welcome . My pleasure
@anupkumarprasad6753
@anupkumarprasad6753 2 года назад
Any solution for white space between pinned and unpinned columns when resize
@geetanjalikarne2549
@geetanjalikarne2549 3 года назад
I have taken the excel file as input and converted to json but how to access it using ag grid
@veerababujujjavarapu7477
@veerababujujjavarapu7477 Год назад
Excellent video.I have one doubt ?How to call excel data instead of API
@sainath7661
@sainath7661 Год назад
I would typically write a service on node/BE layer that processes the excel type of data and provide back the json response which you are going to use it as input to ag-grid. This will help you publish the service and secure the way you check/process the excel/data.
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 3 года назад
@codeSpace.. in my project i want to get ag grid table dynamically ..like my requirement is ..if the user is assigned to 2 clients then 2 intsances of ag grid table should come on the page..if 3 clients then 3 instances of ag grid tables,can u please tell as this is achieved by html table ,but whether the same can be done by ag grid too ???
@codespace
@codespace 3 года назад
U can use ngIf to show and hide particular table based on ur conditions
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 3 года назад
@@codespace but can I get multiple instances dynamically for ag grid ??
@codespace
@codespace 3 года назад
@@TruptiaurKirankiDuniya yes
@adarshnair9846
@adarshnair9846 4 года назад
Are these server-side operations?
@codespace
@codespace 4 года назад
This is frontend pagination. Though aggrid supports server pagination but it is enterprise(paid) version
@srinidhiuttanuru6715
@srinidhiuttanuru6715 3 года назад
Sir errors giving like ag-grid-angular is not known element what to do sir
@sujananuvvula361
@sujananuvvula361 3 года назад
Rowindex is not updating when sorting data please reply how to solve this ?
@sankethsanbro8926
@sankethsanbro8926 2 года назад
getting error in console as rowData.map is not a function?
@tejashreeshirole7375
@tejashreeshirole7375 3 года назад
Hey, I am new to javascript and protractor, I want to test and verify filter and sorting functionality using protractor, but i cant find row data, column data maybe i dont know how to find it on grid, i didnt find any documentation on that please help me
@pavanachyut9349
@pavanachyut9349 4 года назад
i am getting error like columndefs is private and can be accessible by only Appcomponent
@codespace
@codespace 4 года назад
Remove private from columndefs
@saranvlog5810
@saranvlog5810 4 года назад
bro i have one doubt..Installing packages...npm WARN deprecated request@2.88.2: request has been deprecated, see github.com/request/request/issues/3142...may i know what i should do..
@codespace
@codespace 4 года назад
Check out the link medium.com/@codewin/npm-warn-deprecated-request-2-88-2-b6da20766fd7
@breakdownman
@breakdownman 5 лет назад
How to connect to ag-grid mongodb? I couldn't find information on this, can you help me?
@codespace
@codespace 5 лет назад
Connecting database from UI is not a good practice. You can write a service layer using nodejs/java/.net and return the Json format using API
@geetanjalikarne2549
@geetanjalikarne2549 3 года назад
can you just help me out how can i take the user input in ag grid
@pyarelfernandes9211
@pyarelfernandes9211 4 года назад
Hey. I have installed the ag-grid and ag-grid angular module. Still I’m getting this error Cannot find module ‘ag-grid-angular/main’
@codespace
@codespace 4 года назад
Checkout this page www.ag-grid.com/ag-grid-angular-systemjs/?framework=all#gsc.tab=0
@sagarnangare9674
@sagarnangare9674 4 года назад
Did you found solution? Am still getting the same error
@ruchirverma4216
@ruchirverma4216 3 года назад
@@sagarnangare9674 Have you found out the solution ?
@joelmachango
@joelmachango 5 лет назад
thanks man!
@codespace
@codespace 4 года назад
Welcome my pleasure
@aibrainwaves_mk
@aibrainwaves_mk 5 лет назад
Can you post video on server side pagination?
@codespace
@codespace 4 года назад
Its paid version, enterprise version www.ag-grid.com/javascript-grid-server-side-model-pagination/
@pavankumars9313
@pavankumars9313 2 года назад
Nice 👍
@codespace
@codespace 2 года назад
Thanks 😊
@uppremkumar4460
@uppremkumar4460 3 года назад
how to add search icon at each row in ag grid?
@codespace
@codespace 3 года назад
You need to use header components www.ag-grid.com/documentation/javascript/component-header/
@karlrussellmenil9460
@karlrussellmenil9460 3 года назад
Topic: Full stack javascript - Data Pagination and Filtering Good day, If I may humbly ask a little help, any hints, comments and suggestions are very much welcome, thank you in advance for all your help, please see question below, how do I code this?: /* Create the `showPage` function This function will create and insert/append the elements needed to display a "page" of nine students */ /* Create the `addPagination` function This function will create and insert/append the elements needed for the pagination buttons */ // Call functions
@jaychemical5952
@jaychemical5952 2 года назад
how can I do this when records are grouped by a column, the groups are sorted according to the values of this column in ag-grid?
@ramaraob333
@ramaraob333 4 года назад
For production deployment, does it require any license?
@codespace
@codespace 4 года назад
No. Enterprise version marked in red e requires license
@ladaniavadh2996
@ladaniavadh2996 4 года назад
can i set page 1,2,3 on pagination?
@codespace
@codespace 4 года назад
Yes you can Checkout their official link www.ag-grid.com/javascript-grid-pagination/
@fadlylado
@fadlylado 5 лет назад
How about filtering and sorting direct to the server?
@codespace
@codespace 4 года назад
Its a paid version available in enterprise edition www.ag-grid.com/javascript-grid-server-side-model-pagination/
@tapankumarpanda8879
@tapankumarpanda8879 4 года назад
Can u share the JSON data URL....in my pc the data not found...it's urgent please
@codespace
@codespace 4 года назад
Check previous comments.
@tapankumarpanda8879
@tapankumarpanda8879 4 года назад
I checked already but didn't got anything... please help me
@codespace
@codespace 4 года назад
@@tapankumarpanda8879 raw.githubusercontent.com/ag-grid/ag-grid/master/packages/ag-grid-docs/src/olympicWinnersSmall.json
@shrithiharidas2325
@shrithiharidas2325 5 лет назад
Hi Sir, Are these features available for free or licensed fetaures?
@codespace
@codespace 5 лет назад
Majority of the Ag-grid services are free. But few services are paid which are marked as "e" in there website www.ag-grid.com/
@rajeshnaika7354
@rajeshnaika7354 4 года назад
nice
@codespace
@codespace 4 года назад
I have mailed you
@lengchang40
@lengchang40 5 лет назад
I did followed exactly what you did, but when browser reloads, the data are not loading. It only showed the "Loading" prompt. Need help...
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@uppremkumar4460
@uppremkumar4460 3 года назад
How to expand the row in case a cell has two-three lines of text
@Navarathnam92
@Navarathnam92 4 года назад
how to add validations to the cells (mandatory columns)
@anandadake9960
@anandadake9960 3 года назад
hello dear, can we show horizontal ag grid table?
@codespace
@codespace 3 года назад
Not sure. Didn't find any documentation
@vijendarkumar7436
@vijendarkumar7436 5 лет назад
Sir I want learn complete angular step by step by your tutorial.whare is the complete tutorial.
@codespace
@codespace 5 лет назад
Angular playlist: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-r0xz6KzwYeY.html videos of Angular: ru-vid.com/group/PLd0lZIptCEwPcF9ZDMKc_Dx3jkJMRWQX1 agGrid playlist : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iGGaUQFMA08.html videos of agGrid : ru-vid.com/group/PLd0lZIptCEwMG6L97aJlxps-j0ooQubNP
@sravankumarreddy8956
@sravankumarreddy8956 6 лет назад
HI Code Space he way of the ur teaching is excellent i subscribed channel also.I need a small help in this example how we can provide the GLOBAL filter to grid not column level filter can u please help me with this.
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
also what control are u using to terminat ethe batch job at 7:22
@codespace
@codespace 4 года назад
Angular cli
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
@@codespace thanks but the grid is not coming only .:(
@sunilgudivada9242
@sunilgudivada9242 4 года назад
hi i followed the same procedure but the grid shows as loading....
@codespace
@codespace 4 года назад
Open the browser debugger option and check for any error in console. Also check if your api is returning data properly
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
Hi code space..can I make such kind of requirement like..entering id data in textbox and fetching only that data in grid related to the I'd I entered in the textbox
@codespace
@codespace 4 года назад
Yes. You can use search/filter functionality
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
@@codespace no actually I can't use search as I am having 40 lakh records..so I am going to fetch only data related to client id..I have already made a servic in webapi .net which fetches client id based data ..but I am stuck in how to bind it with ag grid .could u plz tell
@codespace
@codespace 4 года назад
In that case you need to use server side pagination /filter. But its not free in agGrid. So you need to implement it urself
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
@@codespace okz thankyou so much..but can u please tell me what is the limit of records maximum we can fetch using ag -grid... also can ng-prime be the alternative if ag-grid is not free for server side pagination
@nireekshapoojary5535
@nireekshapoojary5535 5 лет назад
Will this work in angular 7
@codespace
@codespace 5 лет назад
Yes it will work
@nireekshapoojary5535
@nireekshapoojary5535 5 лет назад
@@codespace Thank you....one more doubt ...how to filter the column of table fetched from database
@vigneshmuralidoss2966
@vigneshmuralidoss2966 5 лет назад
Where can I find that css style sheet which u have imported in angular.json file
@vigneshmuralidoss2966
@vigneshmuralidoss2966 5 лет назад
@@codespace thanks a lot
@codespace
@codespace 4 года назад
🙂
@darshan.vhatkars
@darshan.vhatkars 6 лет назад
Where is next tutorial video u mention
@codespace
@codespace 4 года назад
Checkout the below playlist ru-vid.com/group/PLd0lZIptCEwMG6L97aJlxps-j0ooQubNP
@amar16patil
@amar16patil 4 года назад
Can you show, custom select with (value + id) in cell dropdown please
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@sidheshwarnevade8737
@sidheshwarnevade8737 6 лет назад
Hello This is great. However I am developing an web application with AngularJS. Can you assist me with using AgGrid in AngularJS.
@sidheshwarnevade8737
@sidheshwarnevade8737 6 лет назад
How can I contact you.
@sravanreddynaram6399
@sravanreddynaram6399 6 лет назад
How can define global filter in this grid
@sravanreddynaram6399
@sravanreddynaram6399 6 лет назад
Sir I tired can u please put the global filter to this example please
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@bhanuprakashreddy6279
@bhanuprakashreddy6279 5 лет назад
how can i filter a key which nested from parent object
@codespace
@codespace 4 года назад
Its an enterprise paid version. Check out the link www.ag-grid.com/javascript-grid-tree-data/
@pranalipawar3401
@pranalipawar3401 4 года назад
What is the onGridReady()
@codespace
@codespace 4 года назад
Its an event www.ag-grid.com/javascript-grid-reference-overview/#grid-options
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
hi code space..i am getting error code "ERROR in src/app/app.component.html:4:20 - error TS2341: Property 'columnDefs' is private and only accessible within class 'AppComponent'
@codespace
@codespace 4 года назад
update this private columnDefs; to simply columnDefs;
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
@@codespace hi thankyou ..the grid worked ..thanks for all your replies as well..
@codespace
@codespace 4 года назад
Welcome
@TruptiaurKirankiDuniya
@TruptiaurKirankiDuniya 4 года назад
@@codespace :one doubt plz..i have to fetch data from the databse like sql server ..there are 6 lakhs record ..
@codespace
@codespace 4 года назад
@@TruptiaurKirankiDuniya You can use server side pagination, but that is paid in agGrid. So you need to implement your own logics to handle it
@sivasumanth
@sivasumanth 6 лет назад
Cannot read property 'api' of undefined bro I'm Getting the above error while running
@sivasumanth
@sivasumanth 6 лет назад
@@codespace thanks bro will try and let you know
@codespace
@codespace 4 года назад
Welcome
@StayNerv
@StayNerv 6 лет назад
Great, where is the second part with server side features like slice and dice, pagination, pivot, infinite scrolling 😊 ?
@StayNerv
@StayNerv 6 лет назад
CodeSpace thanks à lot for your answer. I'm using paid version for enterprise row model features mainly.
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@kirankumar1559
@kirankumar1559 4 года назад
hi sir, i want to clone this project ,please provide the link..i will do it in practical way..
@kirankumar1559
@kirankumar1559 4 года назад
sir , reply...
@codespace
@codespace 4 года назад
HI Kiran I am sorry to let you know that I don't have the code base. So I will request you to kindly pause the video and note the respective js files. Since I have recorded the complete flow so you won't face any issues with the implementation.
@aditya-tp2bk
@aditya-tp2bk 6 лет назад
How to call sever side method on sorting
@aditya-tp2bk
@aditya-tp2bk 6 лет назад
When header was click
@aditya-tp2bk
@aditya-tp2bk 6 лет назад
I have 10 lacks records in db .I want to call server side method when header is click ed.i have to send header name for sorting.for the store procedure.
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@sravankumar2919
@sravankumar2919 2 года назад
Music is disturbing.
@codespace
@codespace 2 года назад
Fixed in all latest videos
@siddharthsharma3679
@siddharthsharma3679 4 года назад
hello, do you know how i can limit a big decimal number to only 2 values ? ex: 19.22234 to 19.22
@codespace
@codespace 4 года назад
You can chng the number in api call
@lugepime3
@lugepime3 3 года назад
Guau!
@jayakumar2927
@jayakumar2927 3 года назад
Share code
@HAFIZZOHAIBdilawer
@HAFIZZOHAIBdilawer 5 лет назад
can you share code?
@codespace
@codespace 4 года назад
I hope you are able to resolve it. If not let me know your query in details. Sorry for delayed response
@swag-swara9431
@swag-swara9431 4 года назад
Please can you share code?
@codespace
@codespace 4 года назад
@@swag-swara9431 sorry to let you know that I don't have the codebase
@george18almonte
@george18almonte 5 лет назад
never talks about pagination
@codespace
@codespace 4 года назад
The bottom 1,2,3 pages are pagination. You might be confusing with infinite scrolling
@user-xd2qs8xv2e
@user-xd2qs8xv2e Год назад
Add Comment Submit Cancel import { Component, ViewChild, ElementRef } from '@angular/core'; import { AgGridAngular } from 'ag-grid-angular'; @Component({ selector: 'app-your-component', templateUrl: './your-component.component.html', styleUrls: ['./your-component.component.css'] }) export class YourComponent { gridApi: any; defaultColDef: any; columns: any[] = []; @ViewChild('commentModal') commentModal!: ElementRef; // Reference to the modal constructor(private gridService: GridService) { this.defaultColDef = { // Define your default column properties here // ... }; } onGridReady(params: any) { this.gridApi = params.api; this.gridService.initialize(); } onFirstDataRendered(event: any) { const commentCol = this.gridApi.getColumnDef('Comment'); // Replace 'Comment' with the actual column name if (commentCol) { commentCol.cellClassRules = { 'cell-comment': () => true }; commentCol.cellRenderer = this.commentCellRenderer; this.gridApi.refreshCells(); } } commentCellRenderer(params: any) { const cellElement = document.createElement('div'); cellElement.classList.add('cell-comment'); cellElement.innerHTML = params.value || ''; cellElement.addEventListener('click', () => { this.openCommentModal(params); }); return cellElement; } openCommentModal(params: any) { const modalRef = new bootstrap.Modal(this.commentModal.nativeElement); // Initialize the modal modalRef.show(); modalRef._element?.addEventListener('hidden.bs.modal', () => { const comment = modalRef._element?.querySelector('input').value; // Handle the comment submission console.log(comment); }); } } Your Angular App
Далее
Angular Ag-Grid Server Side Pagination - CodeWithSrini
22:53
Как подписать? 😂 #shorts
00:10
Просмотров 706 тыс.
All about ag-grid in angular 6
10:01
Просмотров 28 тыс.
Angular Material Confirm Dialog
15:05
Просмотров 75 тыс.
Getting Started with Angular Data Grid using ag-Grid
9:24
Reactive Forms  - The Basics
15:48
Просмотров 256 тыс.
Angular Material Popup Dialog & Model
21:17
Просмотров 241 тыс.
Using ChatGPT To Create Fake Datasets
5:18
Просмотров 2 тыс.
Reflection 70b Problems?! What We Know So Far...
19:39
API's & Data - Alteryx Basics
16:08
Просмотров 16 тыс.