question How to sort the Subcategory by name in ITSM forum

How to sort the Subcategory by name

akshaybhardwaj — Thu, 07 Apr 2016 12:22:51 GMT

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

Thanks & Regards,

Akshay

Re: How to sort the Subcategory by name

Manoj Kumar16 — Thu, 07 Apr 2016 12:38:02 GMT

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.

Re: How to sort the Subcategory by name

a_anshu — Thu, 07 Apr 2016 13:19:11 GMT

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

Re: How to sort the Subcategory by name

akshaybhardwaj — Fri, 08 Apr 2016 11:18:40 GMT

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

Re: How to sort the Subcategory by name

a_anshu — Fri, 08 Apr 2016 12:29:51 GMT

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

Re: How to sort the Subcategory by name

jyothikalaadurt — Tue, 12 Apr 2016 07:15:43 GMT

Hi Akshay,

As per my experience, If u have dependent value, then remove sequence value and check, it will work. By default subcategories will come in alphabetical order.

I have tried its working fine.

Re: How to sort the Subcategory by name

akshaybhardwaj — Tue, 12 Apr 2016 07:22:15 GMT

Thanks Jyothi

For work around its fine like it takes sequence on its own but not everytime we can clear the sequence.