Drill down function showing lists in incorrect format

jatinnayi
Occasional Contributor

Drill down function showing lists in incorrect format

Hi all,

 

Wanted to ask for a best solution of this question if possible.

 

I have a set of data which is populated by a subset. When I drill down into the data, the order of the lists are not in the order they should be. I have checked the list which shows the correct order. Is it possible to change the mappings/settings of the drill down options to show the lists in the correct order?

Screenshots attached below showing the correct order vs the incorrect order in the drill down function

 

 

19 REPLIES 19
usman.zia
Community Boss

Hi @jatinnayi,

 

Is the list you are using a numbered list? 

 

If it is then then the creation ID will display the order of how it shows in the drill down. 

 

Otherwise I would expect it to show in the correct order as in your hierarchy structure. 

 

Please can you explain which type it is.

 

Thanks,

 

Usman

jatinnayi
Occasional Contributor

Hi @usman.zia 

 

Thanks for your response. We are using a 'Composite Hierarchy List'. I'm not sure when I drill down why the list is changing order.

 

Thanks, Jatin.

JaredDolich
Moderator

@jatinnayi

@usman.zia hunch is the same as mine. You can tell if it's a numbered list by checking your General Lists tab. If the list is checked in the Numbered column, it's a numbered list. 

 

NumberedList.png

 


Jared Dolich
usman.zia
Community Boss

@jatinnayi 

Also could you show the formula for the cell that you are drilling down on? 

 

Thanks,

 

Usman

rob_marshall
Moderator

@jatinnayi ,

 

I believe @usman.zia is correct in that the sort or display is based off the internal address of the member which correlates to the order it was created, whether it is a numbered list or a "regular" list.

 

Rob

JaredDolich
Moderator

@rob_marshall , @usman.zia ,

This would be good for me to learn too.

Are you saying then to get the order corrected, the lists must be reloaded in the order you want them sorted?

 


Jared Dolich
usman.zia
Community Boss

@JaredDolich @rob_marshall 

 

List item order management is something that can be difficult to manage in models that are always growing. 

 

Has there been a best practices guide published on this? 

 

Thanks,

 

Usman

rob_marshall
Moderator

@JaredDolich @usman.zia ,

 

You have to be very careful, currently, when wiping a list and then recreating it because all of the data associated with that list will be wiped as well, so that is not feasible.  I need to see if this in idea exchange and if it is not, I will add it because I think think this is a big miss.

 

Rob

usman.zia
Community Boss

Thanks @rob_marshall  please be sure to share the link to idea and you'll have my support!