sort foreign key Value under refined search in a grid

Applications Grid / Reports
#1

Hi guys

I am looking for a way to sort foreign keys in a grid under the menu option refined search. The only thing that is being sorted is the id key from the other table and not the effective value I am using.

SELECT ID_Ort, Ort FROM ort ORDER BY Ort

I want to sort the attribute “Ort” in the refined search. In the menu refined search I can only choose ID_Ort.

Does any body have an idea to sort this issue?

Thanks for your help.

Best regards

nuri

#2

Hi Nuri,

The only way that I find to solve this problem, was create a view with description values, in that way, I can to order the refined search.

Regards,