While joining two tables if some columns have same name then I am not able to select all column names (Only all unique column names are displaying in the output).

[shivsharma396]

While joining two tables if some columns have same name then I am not able to select all column names (Only all unique column names are displaying in the output).

[o1lab]

Having multiple keys with same name in an object wouldn't work.

Fixed Output will be in the lines of -

Expected Output:
[{
u_id: 1,
u_name : "xxx",
c_id: 1,
c_name : "city1"
},{
u_id : 2,
u_name : "yyy",
c_id: 2,
c_name : "city2"
}]

where alias for tables' getting joined - u and c will be appended with _ to each column name.

[o1lab]

@shivsharma396 Commit 5a9b6f4 has the fix and this will go in next release of npm.

Query:

/api/xjoin?_join=u.user,_lj,c.city&_on1=(u.city_id,eq,c.id)&_fields=u.id,u.name,c.id,c.name

Response:

[{
u_id: 1,
u_name : "xxx",
c_id: 1,
c_name : "city1"
},{
u_id : 2,
u_name : "yyy",
c_id: 2,
c_name : "city2"
}]

With this commit, _fields query param will be mandatory wherein earlier all fields of tables in join were getting selected.

[o1lab]

Solution in 0.4.4