List Field Master Detail error (viewing record value instead of ID in list page)

V. 8.1.8
Description: when creating node or nodets project with quasar vue (did not test with other frameworks)
Table1 : users (id, name, password ,…department_id)
Table2 departments (id, name)
in list page of users => Field deoartment_id properties creating a master detail relation users.department_id=departments.id , detailpage view, displaytext departments.name


[nodemon] starting node app.js
Server is up and running on port: 8060
Executing (default): SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;
Executing (default): SELECT count(users.id) AS count FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id;
Server Request Error DatabaseError [SequelizeDatabaseError]: SQLITE_ERROR: ambiguous column name: id
at Query.formatError (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:403:16)
at Query._handleQueryResponse (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:72:18)
at afterExecute (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:238:27)
at Statement.errBack (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sqlite3\lib\sqlite3.js:14:21) {
parent: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;’
},
original: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;’
},
sql: ‘SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;’,
parameters: undefined
}
Executing (default): SELECT count(users.id) AS count FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id;
Executing (default): SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;
Server Request Error DatabaseError [SequelizeDatabaseError]: SQLITE_ERROR: ambiguous column name: id
at Query.formatError (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:403:16)
at Query._handleQueryResponse (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:72:18)
at afterExecute (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sequelize\lib\dialects\sqlite\query.js:238:27)
at Statement.errBack (C:\Users\haniy\OneDrive\Documents\RadSystems\NodeRad Projects\masterdetail\nodejs-express-api\node_modules\sqlite3\lib\sqlite3.js:14:21) {
parent: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;’
},
original: [Error: SQLITE_ERROR: ambiguous column name: id] {
errno: 1,
code: ‘SQLITE_ERROR’,
sql: ‘SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;’
},
sql: ‘SELECT users.id, users.username, “departments”.“name” AS “departments_name”, users.department_id, users.email, users.phone, users.image FROM users AS users INNER JOIN departments AS departments ON users.department_id = departments.id ORDER BY id desc LIMIT 0, 10;’,
parameters: undefined
}

Configure an order by on the page, using the fields that exist in the joined table, or you make sure you don’t have a dupplicate field on the two table you are joining.

no duplicates, but as you suggested setting order by department_id on the users list page did the trick