public List selectFields()

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"));
  }