Forum Discussion

ewoytowitz's avatar
ewoytowitz
Cloud Apps
04-04-2024
Solved

Is there a way to change the display order of the data options in a MemberFilterTile?

I am using the MemberFilterTile component from @sisense/sdk-ui. In some cases, I want the options I'm seeing to be displayed in a different order. Is there a way to change the order in which the options are displayed? For example, in this Competition Year filter I would want the most recent year displayed first, instead of last (DESC instead of ASC order).

 

  • IvanBiletskyi's avatar
    IvanBiletskyi
    04-05-2024

    Yes, you can. You need to sort an Attribute that you are using for this filter.

    For example:

    import { filterFactory, Sort } from '@sisense/sdk-data';
  
const sortedYearsAttribute = DM.Commerce.Date.Years.sort(Sort.Descending);
const filter = filterFactory.members(sortedYearsAttribute, ['2013-01-01T00:00:00']);
//...
return (
  <MemberFilterTile
    title={'Year'}
    attribute={sortedYearsAttribute}
    filter={filter}
  />
)

     

4 Replies

  • IvanBiletskyi's avatar
    IvanBiletskyi
    Sisense Employee
    04-05-2024

    Yes, you can. You need to sort an Attribute that you are using for this filter.

    For example:

    import { filterFactory, Sort } from '@sisense/sdk-data';
  
const sortedYearsAttribute = DM.Commerce.Date.Years.sort(Sort.Descending);
const filter = filterFactory.members(sortedYearsAttribute, ['2013-01-01T00:00:00']);
//...
return (
  <MemberFilterTile
    title={'Year'}
    attribute={sortedYearsAttribute}
    filter={filter}
  />
)

     

    • ewoytowitz's avatar
      ewoytowitz
      Cloud Apps
      04-08-2024

      Thank you Ivan! That worked perfectly. Is there also a way to do more complicated sorting (other than ascending and descending)? For example, I have another member tile filter where I am using a "Code Name" as the attribute, but I want the list of "Code Names" to be displayed in ascending order according to the associated "Code Id" (a different attribute in the same interface/dimension as "Code Name").

      • IvanBiletskyi's avatar
        IvanBiletskyi
        Sisense Employee
        04-11-2024

        Unfortunately, custom sorting is not possible for now as it is applied by the backend (DB). We don't sort the array of filter members on the client side because we have lazy-loading of members, so data chunks should come to the client already sorted by the backend.

        Perhaps, at some point, we will add the possibility of passing a raw members array to the filter-tile instead of loading them from the DB. This way, you will be able to query all the members you need and sort them as you want before passing them to filter-tile. However, currently, it is not possible.