Add ORDER BY to array queries

[p-a-s-c-a-l]

Add ORDER BY clause to all queries dealing with arrays to make sure that the order of array items is always the same among recurring requests to the same meta object. See e.g. ObjectFactory:799

From the documentation of SELECT:
"If the ORDER BY clause is specified, the returned rows are sorted in the specified order. If ORDER BY is not given, the rows are returned in whatever order the system finds fastest to produce."

[p-a-s-c-a-l]

Possibilities for ordering n-m arrays (ObjectFactory: 685)

• by primary key of array table: arrayMetaClass.getPrimaryKey()
• by id of array element: arrayMetaClass.getMemberAttributeInfos() -> find Attribute with with mai.IsForeignKey() == true.

[p-a-s-c-a-l]

Possibilities for ordering n-m arrays (ObjectFactory: 799)

• order by detailClass.getPrimaryKey()

[ci-cismet-de]

Integrated branch 'feature/169-sort-arrays (eebf651)' into 'dev (c1f8474)' -- Build 345

[p-a-s-c-a-l]

done