Javers query returning empty results

191 Views Asked by At

In my Mysql DB, I have the audit tables:

global_id_pk|local_id|fragment|type_name                                         |owner_id_fk|
------------|--------|--------|--------------------------------------------------|-----------|
           1|3014    |        |de.cc.carorderprocess.models.Car    |           |



snapshot_pk|type   |version|state |changed_properties                                   |managed_type                        |global_id_fk|commit_fk|
-----------|-------|-------|------|-----------------------------------------------------|------------------------------------|------------|---------|
          1|INITIAL|      1|......|.....................................................|de.cc.carorderprocess.models.Car    |           1|        1|
          5|UPDATE |      3|......|[¶   "modifyDate",¶  "nameCar"¶]      |de.cc.carorderprocess.models.Car    |           1|        3|
          6|UPDATE |      4|......|[¶   "modifyDate",¶  "modelCar"¶]    |de.cc.carorderprocess.models.Car    |           1|        4|

But when I do in my controller:

Javers javers = JaversBuilder.javers().build();

QueryBuilder jqlQuery = QueryBuilder.byClass(Car.class);
List<CdoSnapshot> snapshots = javers.findSnapshots(jqlQuery.build());
logger.info(javers.getJsonConverter().toJson(snapshots));

Car car2 = carRepo.findById(3014l).get();
jqlQuery = QueryBuilder.byInstance(car2);
Changes changes = javers.findChanges(jqlQuery.build());
logger.info(javers.getJsonConverter().toJson(changes));

For both things, I get empty arrays

1

There are 1 best solutions below

0
On

try

queryBuilder jqlQuery = QueryBuilder.byClass(Car.class);
List<CdoSnapshot> snapshots = javers.findSnapshots(jqlQuery.build());
logger.info(javers.getJsonConverter().toJson(snapshots));

car car2 = carRepo.findById(3014l).get();
jqlQuery = QueryBuilder.byInstance(car2);
Changes changes = javers.findChanges(jqlQuery.build());
logger.info(javers.getJsonConverter().toJson(changes));