Mat-table Filter data from Firebase by column

Question

I use angular 6, firebase and material angular. I can load my data into the table, I can sort them, have the paginator, and filter them globally

I would now like to modify my filter so that it just filters on the 'name' column and have a second filter field to filter on the 'common' column.

Can you help me on the strategy to adopt?

@Component({
selector: 'app-table',
templateUrl: './table.component.html',
styleUrls: ['./table.component.scss']
})

export class TableComponent implements OnInit {

showSpinner = true;

Data = {nom: '',finessgeo:'', cat1: '', commune: '',CP: '',departement:'',tel: ''}

displayedColumns = ['nom', 'finessgeo', 'cat1', 'commune', 'CP',    'departement',  'tel'];
dataSource = new MatTableDataSource();

applyFilter(filterValue: string) {
filterValue = filterValue.trim(); 
filterValue = filterValue.toLowerCase(); 
this.dataSource.filter = filterValue;
}

@ViewChild(MatPaginator) paginator: MatPaginator;
@ViewChild(MatSort) sort: MatSort;

ngAfterViewInit() {
this.dataSource.paginator = this.paginator;
this.dataSource.sort = this.sort;
}

constructor(public authService: AuthService,private geoService: GeoService, private router: Router,private database: AngularFireDatabase) { }


onNewGeo() {
this.router.navigate(['']);
}

onSignOut() { this.authService.signOutUser(); }

ngOnInit() { return this.geoService.getGeos().subscribe(res =>{this.dataSource.data = res;this.showSpinner = false;});  }}


export class DataDataSource extends DataSource<any> {

constructor(private geoService: GeoService) { super() }

connect() {return this.geoService.getGeos();}
disconnect() {}
}

Pramod Pramod · Accepted Answer · 2019-04-24T05:27:50

Try below code:

ngOnInit() {
    this.dataSource.filterPredicate = function(data, filter: string): boolean {
      return data.name.toLowerCase().includes(filter) || data.nom.toString() === filter;
    };
  }

Mat-table Filter data from Firebase by column

1 Answers