help wanted
Metriche repository
- Star
- (19.563 star)
- Metriche merge PR
- (Merge medio 5g 16h) (138 PR mergiate in 30 g)
Descrizione
Problem
Want to join same table twice, but the key must be the cube name
Related Cube.js schema
// how to avoid this ?
cube(`CalleeUsers`, {
extends: Users,
});
cube(`PhoneCallEvents`, {
sql: `SELECT * FROM public.phone_call_events`,
joins: {
// want to use the key as CallerUser, but CallerUser cube not exists
Users: {
toCude: Users, // maybe support specify the target cube in here ?
relationship: `belongsTo`,
sql: `${PhoneCallEvents}.caller_object_id = ${Users}.id`,
},
// above cube make this work
CalleeUsers: {
relationship: `belongsTo`,
sql: `${PhoneCallEvents}.callee_object_id = ${CalleeUsers}.id`,
},
},
}
)
New to cubejs, don't know if there is a way to handle join same table twice.