Ability to sort Activity Views by userdefinable fields

by André Friese on February 11, 2019

We would appreciate the extension of the options to sort Activity Views. Currently the items can be sorted by any field definable as filter.

But some field types like numeric or text can not be used as filter and therefor are not available as sort option.
We would like to be able to sort our items by any user definable field. We want to give the items a kind of sort-number and then have the Activities sorted by this number.

This would be really helpful. I know that numeric fields make no sense as filter so maybe the filter and sort function have to be separated from each other.

 

  • Ideas

    Status
  • Please login to view any attachments.

  • Hi David
    I know about the challenge. And I'm aware that grouping by a numeric field would not make sense. But nevertheless it would be very helpful to separate the sorting from the grouping. Currently you can always sort by some system fields, even though they are not used as filter. And you can sort by some of your Filters.
    Activity Views are much better than listing reports, because you can filter ad hoc and you can view items from different applications in the same view.
    That's why I open this Enhancement Request, because it would be an enhancement to be able to sort by other fields than the ones defined for grouping.
    Especially the field type numeric is predestined to be used as sort value.
    A drop down would not bring the same efficiency, because I would need to define all the possible values in an AUX Table (I might not know them in advance), create a new relational field in all my apps, even though I already have the sort-order field and the users would need to select them instead of simply writing a number into a field.

    I would appriciate if this enhancement would get a chance.

    Thank you

    Regards André
    André Friese Commented by André Friese February 13, 2019
    Top 50 Reviewer  -  

    Hi David
    I know about the challenge. And I'm aware that grouping by a numeric field would not make sense. But nevertheless it would be very helpful to separate the sorting from the grouping. Currently you can always sort by some system fields, even though they are not used as filter. And you can sort by some of your Filters.
    Activity Views are much better than listing reports, because you can filter ad hoc and you can view items from different applications in the same view.
    That's why I open this Enhancement Request, because it would be an enhancement to be able to sort by other fields than the ones defined for grouping.
    Especially the field type numeric is predestined to be used as sort value.
    A drop down would not bring the same efficiency, because I would need to define all the possible values in an AUX Table (I might not know them in advance), create a new relational field in all my apps, even though I already have the sort-order field and the users would need to select them instead of simply writing a number into a field.

    I would appriciate if this enhancement would get a chance.

    Thank you

    Regards André

    Hi Andre. I'd like to clarify the expectations for this idea. As you note, you can currently sort by user definable fields in Activity view - so I believe your request is to be able to sort by non-structured text fields. The challenge would be a lack of grouping since every field content would be unique. In other words, Activity View provides value because you can filter or sort by groups of items to drill down into the available data. Without some sort of commonality, you're basically duplicating a sorted listing report, yes? And if your idea is to have the same "sort number" used for multiple items, couldn't that be a defined dropdown selection?
    David J. Easter Commented by David J. Easter February 12, 2019
    #1 Reviewer  -  

    Hi Andre. I'd like to clarify the expectations for this idea. As you note, you can currently sort by user definable fields in Activity view - so I believe your request is to be able to sort by non-structured text fields. The challenge would be a lack of grouping since every field content would be unique. In other words, Activity View provides value because you can filter or sort by groups of items to drill down into the available data. Without some sort of commonality, you're basically duplicating a sorted listing report, yes? And if your idea is to have the same "sort number" used for multiple items, couldn't that be a defined dropdown selection?

     

PrintEmail

Recent Tweets