CMDBuild Forum

order Lookup List

Old Versions
#1

Hi 

 

I've a big lookup list, and I want to order it by Code or By description.

 

I've  tried to use Code -> SortAscending but It seems not working at all.

 

Any hint?

 

thanks in advance

 

 

#2

You can sort them manually through "drag and drop", or if they are so many you should write a SQL command that writes the "Number" column according to the order you are interested in.

CMDBuild Team

 

 

 

#3
It's really uncomfortable to sort manually lookup values, and I can't directly modify data on postgresql db.
 
I've tried order lookUp values using webservices via Lookup class:
 
org.cmdbuild.services.soap.Lookup.setPosition(int position)

It seems working correctly.
 
What happen if I set different lookup values with same position?
 
thanks