params.sort =
    params.sort in ['id','name'] ? params.sort:'name'
params.order =
    params.order in ['asc','desc'] ? params.order:'asc'
String sql = """
    SELECT NEW MAP(c.id as id, c.name as name) FROM Customer c
    WHERE c.partner.id = :id
    ORDER BY c.$params.sort $params.order
""".stripMargin()
def customers = Customer.executeQuery(
    sql, [id:params.long('id')],
    [max:params.long('max'),offset:params.long('offset')]
)