Announcement

Collapse
No announcement yet.

sort foreign key Value under refined search in a grid

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • sort foreign key Value under refined search in a grid

    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,

    Comment

    Working...
    X