Listing - Order By Label But Not A Value

[myfatebiz]

Hi,

I have a table which is using database join from another table using id as a value to store data and name as a label. But unfortunately listing order by using value id instead a name as label. Now my listing is like irregular arrangement like row 1 is Lenneth, row 2 is Kenny, row 3 is Annie, row 4 is Raymon, row 5 is John. Are this possible make order by using label?.

Thanks

Regards,
MyFateBiz

 

[rob]

I can't replicate this - could you post a screen shot of your database join element's settings please?

 

[myfatebiz]

Hi Rob,

Please see the attachment. Now listing is sorting by value "id". What i want is it order by label.

Regards,
MyFateBiz

 

[myfatebiz]

Friendly Bumb

 

[troester]

Add
ORDER BY full_name ASC
to the "Join WHERE und/oder ORDER BY Anweisung (SQL)" field

 

[myfatebiz]

Hi troester,

Now i understand :

Order By on Data area for Label and Order By on Group By area for value.

Thanks.

Regards,
MyFateBiz