Sort associated objects and associated objects

Sort associated objects and associated objects

1. Question Description:

Object A is associated with multiple objects B. You want to sort multiple associated objects B.

 

2. Solution:

2.1 A sorting field (such as ordernum) is required in the join relationship table. You can use the number of milliseconds in the current System time as the serial number (Long currentTimeMillis = System. currentTimeMillis ();). Because it is of the long type, there are different sizes.

2.2 When changing the order between multiple objects, such operations as moving and moving down are performed, the ordernum values of these objects can be exchanged.

2.3 sorting BY odernum (select a. * from asset a, objectgrouprobject ogro where a. ASSETID = OGRO. objectid and ogro. OGID = 20160401123045006 order by ogro. ORDERNUM)