How to do multilevel Ordering in mat table in angular

Asked Jan 07 '19 at 10:27

Active Jan 07 '19 at 10:44

Viewed 111 times

I have table customer with columns country, customer_id and customer_name.

I need to order the mat table in angular by columns country, customer_id and customer_name, like in SQL query.

SELECT * FROM customers ORDER BY country, Customer-Name;

edited Jan 07 '19 at 10:44

GMB

asked Jan 07 '19 at 10:27

Guvaliour

1

Provide your column name in the order which you want separated by a comma after ORDER BY – Hassan Imam Jan 07 '19 at 10:29
Possible duplicate of [SQL multiple column ordering](https://stackoverflow.com/questions/2051162/sql-multiple-column-ordering) – Hassan Imam Jan 07 '19 at 10:31
4

I'm confused. Is this an SQL question or an Angular question? – GolezTrol Jan 07 '19 at 10:40
This is an angular question – Guvaliour Jan 07 '19 at 11:02
I got output sorry for wasting your valuable times thank u so much for all. – Guvaliour Jan 07 '19 at 11:03
http://jsbin.com/uxibic/1/edit?html,css,js,console,output – Guvaliour Jan 07 '19 at 11:03
@Ajai - Please post the answer and mark it accepted, if you were able to figure it out. That might help someone in future :) – Sudipta Mondal Jan 07 '19 at 11:09

0 Answers0