I have a list of selective access for users. Due to the dynamic maintenance of that list from various sources, a sorting of the list items is missing. For readability, I want the list items to be sorted in the modules and on dashboards. I use a line item with formula CODE (ITEM ()), on which I set sorting. Due to the selective access on the list, this sorting does not work for users who do not have read or write access to all list items. Does anyone have a solution for this?
"Due to the dynamic maintenance" means that the list is filled with new members that appear in several data import lists. So I import all actual transactions and then check if the WBS-elements can be found in the list WBS-elements. Any new item will be added to the list, but allways on top (or at the bottom, I'm not sure about that) in the group of the parent hierarchy. My hierarchy is 3 levels: 1 Project; 2 Project fase 3; WBS-element, so the same happens whith the new parents (2 Project fase).
The issue is that the sort at only level 3 can be fixed by using a lineitem in a module to sort at. But as the parents are in a different list there is no sort on level 2 items. I'm beginning to realize that the selective access is not an issue in this problem.
This link might provide you with a couple of ideas. A combination of this process laid out by @StefR at your L2 and a sort on the L3 might create the view that you are looking at with minimal effort. There are also a couple more suggestions further down in the thread of that link that might work based on the specifics of your case.
Thanks for your help. I read the article, it contains some interesting things. Problem is that I can't delete my lists because of saved historic data, but maybe the alternative hierarchy is the direction I'm looking for