[BUG] how to join multiple table.

[ericfem]

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Dependencies Version (please complete the following information):

• Laravel Version: [e.g. 7.27.0]
• Nova Version: [e.g. v3.8.4]
• Nova-ChartJS Version: [e.g. v0.3.2]

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context Add any other context about the problem here.

[ericfem]

how to join multiple table in novajs chart. is there a feature of this kind? It can only join 1 table.

[alexrinaldi]

I am joining the request, is there a way to join multiple tables?

[ericfem]

any updates or can help us with this issue?

[BadreddineZatout]

I am joining the request, is there a way to join multiple tables?

can you show me how are you joining the request?

[jigar-dhulla]

I am joining the request, is there a way to join multiple tables?

can you show me how are you joining the request?

This is how I am trying.

Looking at source, don't think calling multiple join() is acting like addJoin().

(new DoughnutChart())
    ->model('app\model\SomeModel')
    ->join('table_1', 'table_1.id', '=', 'some_models.table_1_id')
    ->join('table_2', 'table_2.id', '=', 'table_1.table_2_id')
    ->options([
        'queryFilter' => array(
            [
                'key' => 'table_2.table_2_attribute',
                'operator' => '=',
                'value' => 'some_value',
            ]
        )
    ])