Define Tree Depth

[raydirty]

Issue type:

[x] question
[ ] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[ ] mssql
[ ] mysql / mariadb
[ ] oracle
[x] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)

Steps to reproduce or a small repository showing the problem:

Linking to the official documentation about Trees.

Is it possible to limit the depth in a recursive tree hierarchy?

For example something like that:

const manager = getManager();
const trees = await manager.getTreeRepository(Category).findTrees({limit: 1});

and then the response would look like this:

[{
    "id": 1,
    "name": "a1",
    "children": [{
        "id": 2,
        "name": "a11"
    }, {
        "id": 3,
        "name": "a12"
    }]
}]

This could be helpful to "paginate" trees and to improve the performance of APIs.

[johanneslumpe]

I am also interested in this. Right now the closure table strategy does not store the tree depth in the table, so without code changes to how the strategy is implemented this probably isn't possible.

[guiaramos]

Any workaround for this?