in src/it/java/com/epam/digital/data/platform/restapi/core/impl/queryhandler/TestEntityM2MQueryHandler.java [36:58]
public List<SelectFieldOrAsterisk> selectFields() {
return Arrays.asList(
DSL.field("id"),
DSL.field("name"),
DSL.field(
DSL.select(
DSL.coalesce(
DSL.jsonArrayAgg(
DSL.jsonObject(
DSL.field("id"),
DSL.field("person_pass_number"),
DSL.field("consent_date"),
DSL.field("person_gender"),
DSL.field("person_full_name"))),
DSL.jsonArray()))
.from("test_entity")
.where(
DSL.field("id")
.eq(
DSL.any(
DSL.array(DSL.field("test_entity_m2m.entities"))))))
.as("entities"));
}