0

Sort concatenated values in table view not working

Hi, I have a parent table "Programmes" and a child table "Works" .
In the "Works" table I have a number field called Order and then a field which combines the WorkTitle with the order (Order+"-"+Title). This is so I can decide in what order the works are for each programme because it can change.

In the "Programmes" table view I need a column which lists the Titles in the order they have been set via the order field. (1-TitleA, 2-TitleB, 3-TitleC...) but when I create a function for that column such as:

sort(concat(Works.TitleandOrder))  they still get sorted by their ID.

Any ideas?

3 replies

null
    • szormpas
    • 1 mth ago
    • Reported - view

     Hi,

    Could you try the following?

    concat((Works order by Order).TitleandOrder)

      • Sean_Wood
      • 1 mth ago
      • Reported - view

      Thanks, yes I've done that before and hoped not to have to do it here as it means I first have to make sure it only shows the data for that one programme , using something like

      let PROG := Title;

      concat((select Programme-Works where Works.Title=PROG order by 'Order in programme').Title)

      it does work though. "Programme-Works" is my join table .

    • John_Halls
    • 1 mth ago
    • Reported - view

    Any attempt to order by in the formula of the view is ignored. The sort is determined by the setting of the columns in the view. You will need to show the Order and set this column.

    Regards John

Login to reply

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 30Views
  • 3 Following