How to sort the Subcategory by name

akshaybhardwaj
Mega Guru

Hi All,

I want to sort the subcategory choice list by name ,i got there is a sequence field in the choice table but we are having 200 subcategory so is there any other way i can do this?

Thanks in Advance

find_real_file.png

Thanks & Regards,

Akshay

6 REPLIES 6

Manoj Kumar16
Giga Guru

Apart from sequence there is another field called Dependent value in the list. if this field does not appear in the list then add it to the list layout. Subcategories are dependent on categories. like if you do a show matching with 'request' as the dependent field then you will get-Password reset, Password Expired and Account locked. Now if you set the sequence on alphabetical order then job would get easier to set the sequence of 200 subcategories.



Please mark it helpful or Correct if it helps.


If I am not wrong by doing this also i had to change the sequence only.Suppose if in future if i got again some subcategory for category then again   i had to set their sequence.Is there not any other way we can do it which will not create any maintainance problem.



BR,


Akshay


a_anshu
Giga Expert

Hi Akshay,


I just thought of an idea how you can do it.



Export the choice list to an xml file -> then sort it by name -> there you can easily change the sequence -> make an import set -> and   import it by using transform map.



Otherwise before entering the choices in the choice list, you could have written a script to auto populate the sequence form as per the name.



Hope it helps,


Abhinav Anshu


a_anshu
Giga Expert

Hi Akshay,



For once when you have already inputted the value, do it by exporting and importing, and then what you can do for future reference is that you can make the sequence field a script type and then you can write a script that dynamically fill in values in the sequence field based on its alphabetical order. I hope it can be done.



Hope it helps,


Abhinav Anshu