Graphql - second level nested relationships always return empty array

[dankostov]

Describe the bug
I saw that similar bug have existed before, this one is related to many-to-many (bi-directional) relationship only.

Objects located deeper than 2 levels with many-to-many relationship always return empty array when querying using GraphQL.

Steps to reproduce the behavior
Example of graphql:

query {
 building(id:1) {
 	apartments {
     name
      rooms {
      name
     }
   }      
 }   
}

Actual Result:

{
 "data": {
   "building": {
     "apartments": [
       {
         "name": "Apartment 1",
         "rooms": []
       }
     ]
   }
 }
}

JSON models:

{
  "connection": "default",
  "collectionName": "buildings",
  "info": {
    "name": "building",
    "description": ""
  },
  "options": {
    "increments": true,
    "timestamps": [
      "created_at",
      "updated_at"
    ],
    "comment": ""
  },
  "attributes": {
    "name": {
      "type": "string"
    },
    "rooms": {
      "collection": "room",
      "via": "buildings",
      "dominant": true
    },
    "apartments": {
      "collection": "apartment",
      "dominant": true,
      "via": "buildings"
    }
  }
}

{
  "connection": "default",
  "collectionName": "apartments",
  "info": {
    "name": "apartment",
    "description": ""
  },
  "options": {
    "increments": true,
    "timestamps": [
      "created_at",
      "updated_at"
    ],
    "comment": ""
  },
  "attributes": {
    "name": {
      "type": "string"
    },
    "rooms": {
      "columnName": "rooms",
      "collection": "room",
      "via": "apartments",
      "dominant": true
    },
    "buildings": {
      "collection": "building",
      "via": "apartments"
    }
  }
}

{
  "connection": "default",
  "collectionName": "rooms",
  "info": {
    "name": "room",
    "description": ""
  },
  "options": {
    "increments": true,
    "timestamps": [
      "created_at",
      "updated_at"
    ],
    "comment": ""
  },
  "attributes": {
    "name": {
      "type": "string"
    },
    "buildings": {
      "collection": "building",
      "via": "rooms"
    },
    "apartments": {
      "collection": "apartment",
      "via": "rooms",
      "columnName": "apartments"
    }
  }
}

Expected behavior
It should return the rooms as well.

System

• Node.js version: v12.12.0
• NPM version: 6.11.3
• Strapi version: 3.0.0-alpha.26 / 3.0.0-beta.17.1
• Database: sqlite
• Operating system: Ubuntu

[derrickmehaffy]

@dankostov due note that Alpha is no longer supported: 3.0.0-alpha.26

[dankostov]

It's happening on 3.0.0-beta.17.1 as well.

[alexandrebodin]

@dankostov Can you share your three models as json plz

[dankostov]

@alexandrebodin I have updated the description, including the models as you requested.
Is it possible this to be graphql client issue, am i querying it in the right way?

[dankostov]

@alexandrebodin The issue is also happening for the "has many" relationship (the last one).