Option of restricting elements for selectors

Up to now, for a selector, there was only the possibility to display all elements or only the active elements. However, I had the requirement in many projects that the selectable elements should be restricted depending on other filtering.

Reasons could be for example:

  • Elements of entities are no longer valid, but should remain historically available (old accounts, old contracts, old rental objects, ...).
  • Entities that are in an n:m relationship
  • Entities where it does not make sense to pull them together in a tree because the relationship changes and the data has to be shown historically. (slowly changing dimensions)

Desired functionality:

  • The selectable elements in a selector shall be restrictable by a cube.
  • The display of the maximum elements should adapt accordingly, both for the counter (4/10) and for the percentage.

A comparable function can already be found in the suggested values part of data entry (See Picture).

Examples for desired functionality:

Situation:

  • There are two entities: Rental Object and Contract.
  • The entity rental object has 10 elements.
  • The entity contract has 4 elements.

Case 1:

  • Contract 1 and 2 have expired and are no longer active.
  • On a screen, the selectable elements of the selector contract can be limited to the active contracts with a selection cube.
  • When operating the selector, only contracts 3 and 4 are displayed. Contracts 1 and 2 are no longer selectable.
  • The counter displays "2/2" (instead of the current "2/4") and the percentage "100%" (instead of the current 50%).
  • If the user selects contract 3, contract 3 is displayed in white and contract 4 is greyed out (as before).
  • The counter now displays "1/2" (instead of the current 1/4) and the percentage "50%" (instead of the current 25%).

Case 2:

  • The user has filtered to contract 3.
  • Contract 3 includes rental objects 1, 2, 3 and 4.
  • A mapping cube (contract x rental object) is used to restrict the selectable elements for the rental objects selector to rental objects 1, 2, 3 and 4.
  • The counter displays "4/4" (instead of "4/10") and the percentage "100%" (instead of 40%).
  • If the user selects rental object 1, 2 and 3, rental object 1, 2 and 3 are displayed in white and rental object 4 is greyed out. The counter now shows "3/4" (instead of 3/10) and the percentage "75%" (instead of 30%).

13
13 votes

Accepted · Last Updated

Comments

  • Product Management Team
    Product Management Team Employee, Group Leader
    250 Likes 500 Comments First Anniversary Name Dropper

    Hi Niklas, thank you for sharing your idea! We appreciate the time and effort you put into crafting your suggestion, and we understand the need of this solution. We have accepted this Idea to be part of our backlog and we are evaluating the feasibility of adding it to the development roadmap. 
     
    We are committed to delivering the best possible experience to our customers, and we must prioritize the features and enhancements that will have the most significant impact on your daily use of our software.