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

**URL:** <https://forum.radsystems.io/t/list-field-master-detail-error-viewing-record-value-instead-of-id-in-list-page/1380>\
**Category:** NodeRad Vue\
**Created:** [January 31, 2023, 7:19pm UTC](https://forum.radsystems.io/t/list-field-master-detail-error-viewing-record-value-instead-of-id-in-list-page/1380 "2023-01-31T19:19:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![haniyasin](https://forum.radsystems.io/letter_avatar_proxy/v4/letter/h/4da419/32.png) [@haniyasin](https://forum.radsystems.io/u/haniyasin)\
**Post date:** [January 31, 2023, 7:19pm UTC](https://forum.radsystems.io/t/list-field-master-detail-error-viewing-record-value-instead-of-id-in-list-page/1380/1 "2023-01-31T19:19:10Z")

</div>

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

 ![image](https://forum.radsystems.io/uploads/default/original/1X/496bc6d0081f0c6b68b6b550da89555ae5b01532.png)

 ![image](https://forum.radsystems.io/uploads/default/original/1X/b30ef25a9349b7a505894880584021e567b1dfaf.png)

 ![image](https://forum.radsystems.io/uploads/default/original/1X/61b097e5ef428d54d50a1732dadaae2f7ccfb368.png)  
[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  
}

---

<div class="post-metadata">

**Author:** ![willvin](https://forum.radsystems.io/user_avatar/forum.radsystems.io/willvin/32/7_2.png) [@willvin](https://forum.radsystems.io/u/willvin)\
**Post date:** [January 31, 2023, 9:15pm UTC](https://forum.radsystems.io/t/list-field-master-detail-error-viewing-record-value-instead-of-id-in-list-page/1380/2 "2023-01-31T21:15:26Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![haniyasin](https://forum.radsystems.io/letter_avatar_proxy/v4/letter/h/4da419/32.png) [@haniyasin](https://forum.radsystems.io/u/haniyasin)\
**Post date:** [January 31, 2023, 9:58pm UTC](https://forum.radsystems.io/t/list-field-master-detail-error-viewing-record-value-instead-of-id-in-list-page/1380/3 "2023-01-31T21:58:34Z")

</div>

> [@willvin](#):
>
> 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