Pagination directive + order results about lighthouse HOT 6 CLOSED

I'll add this to the docs, but you can only have 1 resolver directive on a field (there are resolver directives that "resolve" a field and middleware directives that "manipulate" a field).

As for filtering/ordering, you can add scopes to the hasMany and pagination directives like so:

type User {
    posts(status: PostStatus): [Posts!]! @hasMany(scopes: ["myStatusScope"])
}

type Query {
    posts(order: PostOrder): [Post!]! @pagination(scopes: ["myModelScope"]
}

Note: You'll get passed the args array to your scope

from lighthouse.

Ok, I think I found the issue:
as soon as I change the scope function name to something else than scopeOrderBy (and update schema.graphql accordingly), things started working. Maybe there's already a built-on scope since I even ran into an endless loop when trying things out?

Seems like the laravel documentation is also not clear on this...

Doesn't work:

public function scopeOrderBy($query, $args) {
  ..

Works:

public function scopeOrderAndFilter($query, $args) {
  ..

from lighthouse.

Excellent, was missing the scope.

extend type Query {
  posts: [Post!]! @paginate(type: "connection", model: "Post", scopes: ["filterAndOrder"])
}

Thanks again!

from lighthouse.

@kikoseijo can you explain a little more how you managed to get sorting with scopes working?

I've been fruitless in trying to allow sorting to be passed as an argument by graphql.
I added the orderBy argument and scope option to the paginator directive, like so

images(orderBy: String): [Image!]! @paginate(type: "relay", model: "Image", scopes: ["orderBy"])

However, as soon as I try adding an orderBy clause to the query (see code below) it doesn't return any results anymore (which seem logical from the Laravel scopes intention to filter results, not to sort)

in app/Models/Image.php

    /**
     * @param $query \Illuminate\Database\Eloquent\Builder
     * @param $args
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeOrderBy($query, $args) {
        $orderBy = $args['orderBy'] ?: 'createdAt_DESC';
        @list ($orderField, $orderDirection) = explode('_', $orderBy);
        $orderDirection = $orderDirection ?: 'DESC';
        return $query->orderBy(snake_case($orderField), strtolower($orderDirection));
    }

Thanks again! Maybe this question should also be listed in #106 ?

from lighthouse.

Reserved word?

from lighthouse.

@kikoseijo Yes, as you can do Model::orderBy('some_attribute') on all Eloquent models I think.

from lighthouse.