assertj-db icon indicating copy to clipboard operation
assertj-db copied to clipboard

Sort Changes by the specified field other than the primary key

Open Sergey-citc opened this issue 3 years ago • 1 comments

According to documentation, changes sorted by primary key and if there are no primary key by the values of the row (for a modification). My table has a primary key, but it doesn't fit because it has a type UUID. So the changes is sorted randomly.

Is there any function to set sorting on any other field? If not, can you add?

I tried like below code, it doesn't work:

Table(dataSource, "table_name", arrayOf(Order.asc("created")))...

Sergey-citc avatar Nov 14 '22 12:11 Sergey-citc

Hello,

You can do something like that:

// Get the data from "members" table and order on "name" column in ascending order
Table table = new Table(source, "members", new Order[] { Order.asc("name") });

clemstoquart avatar Jan 02 '23 15:01 clemstoquart