GraphQL

Example of a simple search

 searchBooks
    filter: { and: [{ author: { pet: { name: { containsic: "ex" } } } }] } // and is optional if the list has only one Map element
 ) {
    data{
        title
        id
        genre
        author(join: RIGHT) { // Specifying the join type is optional
            id
            name
            pet(join: LEFT) {
                id
                name
            }
        }
    }
    currentPage // You can specify what paging information you want to be returned
    currentPageCount
    total
    totalPages
    pageSize
    }
 }

Example of a more complex search

query MyQuery {
    complexBooksSearch(filter: {title: {containsic: "lorax"}},
        paging : {page: 1, size: 10, sortOrders: [{ field: "Book.title", sortDirection: ASC }]},
        aggregates: {count: [Book_genre]},
        fields: [Book_id, Book_title, Book_genre]
    )
 }

Example of a count query

 query test{
    countBooks(
        filter: {and: [{author: {name: {contains: "ss"}}}, {title: {containsic: "lorax"}}]},
        clause: {distinct: true},
        fields: Book_title // The field to count on
    )
 } 

• Aggregates are not supported in the count query Since a Count query is already an aggregate query
• The fields parameter is optional and is used to specify the fields to be returned in the response
• The aggregates parameter is optional and is used to specify the fields to be aggregated
• The paging parameter is optional and is used to specify the paging information
• The clause parameter is optional and is used to specify the SQL clause to be used in the query
• For now only distinct is supported
• The filter parameter is optional and is used to specify the filter criteria
• Joins can't be used with aggregates
• Aggregates return a JSON object since the result shape is not known

Application independent part of the schema is located in the components-expression/src/main/resources/graphql folder.
Other Scalars can be added in the customScalars.graphqls file. Please follow the instructions in the file