How can i sort a list of incidents on the basis of "state" field but with my choice of field to be on the top and bottom.

[priya0895]

I want to sort the list of incident on the basis of state where "On hold" is followed by "New" is followed by "In progress" without even changing the values of choices.

[staceyrocheleau]

I don't see how you can do this on the state field itself as you can sort it by state but not say which is the top/bottom if that value is out of order.

You could add another field to set some kind of ordering value based on state. Set this field when the state changes or use a calculated field. Then sort by that.

For instance, use the state's number value but if it's <your top state> put -5000 in that field and if it's your bottom value put 5000. Then sort by this field. Just a thought.

[dvp]

In incident list view you can group by state...

[priya0895]

I dont want to group the incidents on the basis of "state" field they are sorted on the basis of state field as shown in below snap. Now i wish to sort them such that "Inprogress" incidents are followed by "New" incidents . I cannot even change the value of choices of state field.s.

[vandana2]

You can create another field like Index and assign the value in that field based on state.suppose on hold then setvalue of oder field as 0,New as 1 ,and Inprogress by 2 and then use the method orderby(index) to sort the records.