DTE PHP backend leftJoin not delivering joined table's label field content

florianarndt

Hey Allen,

I have an instance of DTE just like the example of https://editor.datatables.net/examples/simple/join.html.
It generates PHP calls from a model.

Just one thing is missing at this point: the JSON response only includes content of the FROM-table, LEFT JOIN fields are not included:

{
    "data": [
        {
            "DT_RowId": "row_2",
            "clients": {
                "id": "2",
                "name": "Client name",
                "street": "Some street",
                "house": "22",
                "zipcode": "40233",
                "city": "Düsseldorf",
                "country_id": "1"
            }
        }
...

Any ideas what that could be? Or do you need more info?

Thanks in advance!
Florian

florianarndt

Solved: I just realized I need to add Field instances for all fields, including those of referenced tables (which I forgot) ;-)