Sort Primefaces DataTable column with two Columns names in sortBy attribute

Question

I would like to sort a dataTable which has column named "CustomerName" which needs to be sorted based on Customer's FirstName & LastName. So i'd like to pass value to sortBy attribute as shown below sortBy="CustomerTable.FirstName,CustomerTable.LastName"

When i try this i get a parser error stating that String

I am able to sort a column with one table name & column name as input like shown below sortBy="CustomerTable.CustomerNumber"

What version of PrimeFaces are you using? – Jasper de Vries May 24 '17 at 08:45 — Jasper de Vries, May 24 '17 at 08:45
primefaces 3.5 @JasperdeVries – Chaithanya RC May 24 '17 at 09:09 — Chaithanya RC, May 24 '17 at 09:09

score 0 · Accepted Answer · answered Dec 05 '17 at 06:08

0

sortBy="CONCAT(CustomerTable.FirstName,' ',CustomerTable.LastName)" This will sort the column in alphabetical order after concatenating the FirstName and LastName columns of CustomerTable

answered Dec 05 '17 at 06:08

Chaithanya RC

75
1
11

Sort Primefaces DataTable column with two Columns names in sortBy attribute

1 Answers1