GraphQl LightHouse Where条件不工作

Question

如何在查询中添加where条件？

projects: [Project!]! @all @orderBy(column: "id", direction: DESC)

我想要：

projects: [Project!]! @all @orderBy(column: "id", direction: DESC) @where('parent_id','=',0)

Answer 1

Adding a where condition was too easy but was not clear in lighthouse docs.

projects(query: QueryCondition): [Project!]!
        @all
        @orderBy(column: "id", direction: DESC)

input QueryCondition {
    parent_id: ID @eq
}

Answer 2

查看@ https://lighthouse-php.com/5/api-reference/directives.html#all指令上的scope参数并阅读有关https://laravel.com/docs/8.x/eloquent#query-scopes的内容。这就是你所需要的。@where指令只能在参数上传递。

Answer 3

您可以将@where与一个可选的Int放在一起，并使用@orderBy指令添加一个orderBy属性，如下所示：

projects(
    parent_id: Int @where(key: "parent_id")
    orderBy: _@orderBy(columns: ["id"])
): [Project!]! 
    @all