mssql Connector - build models from source: Only objects of a "dbo" owner are returned.

[jgcoding]

How does one get anything other than a "dbo" "owner" object to be included in the results (see image attached) I have tried: 1) "owner": "scada" 2) "schema": "scada" 3) "options": { "all": true } 4) "owner": "dbo" --(which in SSMS shows all schema")

[nasihere]

• I have added my patch to retrieve my other schema tables. I have changed my node_module packages. If you want to use other than 'dbo' schema then override 'owner' variable in node_modules\loopback-connector-mssql\lib\discovery.js. See my below changes Step 1: Open discovery.js from node modules Step 2: Look for queryTables Step 3: change owner variable to your desired schema name Step 4: run SLC arc or SLC loopback:model

Example function queryTables(options) { var sqlTables = null; var owner = options.owner || options.schema; owner = "Evare"; //override owner variable with your schema name or hardcode the value if (options.all && !owner) { sqlTables = paginateSQL('SELECT \'table\' AS "type", table_name AS "name", table_schema AS "owner"'

• ' FROM information_schema.tables', 'table_schema, table_name', options); } else if (owner) { sqlTables = paginateSQL('SELECT \'table\' AS "type", table_name AS "name", table_schema AS "owner"'
• ' FROM information_schema.tables WHERE table_schema=\'' + owner + '\'', 'table_schema, table_name', options); } else { sqlTables = paginateSQL('SELECT \'table\' AS "type", table_name AS "name",'
  • ' table_schema AS "owner" FROM information_schema.tables WHERE table_schema=schema_name()', 'table_name', options); } return sqlTables; }

Waiting to get fixed from Strongloop team soon. so i don't need to touch that variable whenever i need to generate or regenerate models.

Thanks Nasir

[cognitus]

any news?