https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table<p>I've noticed that if I use the persistence API to create a database table the order of the table columns is not the same as in the persistence data-class. Is it possible to keep the field order in a data-class to a database table?</p>enFri, 06 Jun 2014 13:03:01 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table#755<p>I think there was a misunderstanding in my question. It is not the target to have the object in a certain order. The objective was that the columns within the database are in a certain order.</p>Nikel WeisFri, 06 Jun 2014 13:03:01 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table#755https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table#754<p>You still need to use ORDER BY for certain queries because it is not guaranteed that your query result is in the very order of your database. So you need to manually ensure the order of your results, else you get a bug that is hard to pin down.</p>Daniel OechslinFri, 06 Jun 2014 09:59:19 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table#754https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table#753<p>Thanks for your reply. That would be a possibility if the database should only be created via persistence - so +1 for that. But it is also possible to do it the other way around. :)</p>Nikel WeisFri, 06 Jun 2014 08:49:32 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table#753https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/752<p>Another solution is to create your database in SQL first and then create your persistence data clases accordingly to the SQL-Database. So it is possible to apply a certain order.</p>Nikel WeisFri, 06 Jun 2014 08:48:31 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/752https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/731<p>The only solution I can think of is if you sort your data-class alphabetically and you add the ORDER BY attribute to your database query.</p>Daniel OechslinMon, 02 Jun 2014 12:47:57 -0400https://answers.axonivy.com/questions/650/is-it-possible-to-apply-field-order-of-a-persistent-data-class-to-database-table/731