Topic
  • 2 replies
  • Latest Post - ‏2012-12-06T15:23:58Z by venkat_Jey
Senators
Senators
37 Posts

Pinned topic FM Sorting fields - Relational model.

‏2012-12-05T14:24:22Z |
Hi Folks

I have a relational model. I have a DateTime field in which I'd like to pre-sort to be in Descending order in FM.

The reason: The data is being used in sort of a unique manner. When the users use this dateTime field and they filter on it in the report, they will only choose 1 date. Hence, a date range prompt for them in QUERY studio (they don't use RS) doesn't make sense as it gives the illusion that it's to be used. So I changed the Prompt info to be 'Select Value' in the model.

So far that works fine. They select a single date.

The enhancement: They would like the latest date to be at the top of the list when they go to filter. I was hoping there'd be an FM option to easily do this, but that's not the case.

But maybe someone can confirm?

Thanks!
Updated on 2012-12-06T15:23:58Z at 2012-12-06T15:23:58Z by venkat_Jey
  • Senators
    Senators
    37 Posts

    Re: FM Sorting fields - Relational model.

    ‏2012-12-05T14:25:09Z  
    Sorry to clarify, it's sorting the data in a specific field. Not ordering fields in a Query subject
  • venkat_Jey
    venkat_Jey
    92 Posts

    Re: FM Sorting fields - Relational model.

    ‏2012-12-06T15:23:58Z  
    • Senators
    • ‏2012-12-05T14:25:09Z
    Sorry to clarify, it's sorting the data in a specific field. Not ordering fields in a Query subject
    Cant you use max(date) ?