objectionjs column reference is ambiguous

I try to make a query with a join relation with objection.js.

Here is the datastructure:

Here is the query:

Titres.query()
      .skipUndefined()
      .whereIn('typeId', typeIds)
      .whereIn('domaineId', domaineIds)
      .whereIn('statutId', statutIds)
      .joinRelation('demarches.etapes.substances')
      .where('demarches:etapes:substances.id', substances)
      .eager('[domaine, demarches.[type, etapes.substances.domaine]]')

This makes an error: column reference \"domaine_id\" is ambiguous

How is it possible to make it work?

Solution

prefix the conflicting table: whereIn('titres.domaineId'

Knex timeout - what is the best approach to fix it?
How to nested map for res.json() in express
sqlite3 update query refreshes electron renderer process
KNEX Undefined binding(s) detected when compiling SELECT query
Using knex's onConflict().merge() is creating duplicate rows in my db?
Knex asking for install sqlite3 but I'm using mysql database
Building knex innerJoin with Postgres JSONB "?" operator?
When synth or deploy with AWS CDK getting bundling error related to knex
Error when launching signed and notarized app - JavaScript error occurred in the main process
Timeout acquiring a connection when streaming results using Express
Knex insert gives error: syntax error at or near "("
Knex vs. mysql2 based on performance, stability, and ES8+ support
Cloud SQL with Firebase Functions V2
How to Ignore error in batch insert Postgresql
How do I reset query part with knex.js
Knex returns DATETIME fields applying offset of my machine timezone
How do I GROUP BY the first expression of a UNION ALL query in Knex.JS?
Knex: Rollback specific migration?
showing error [symbol.iterator()] in ts generics in knex query
Array not being passed to query in knex
where to destroy knex connection
How to run knex migrations from Dockerfile or docker-compose
Knex migration in postgres Heroku - Error: Unable to acquire connection
Knex tries to use sqlite3 when already using mysql2
How can I view the query `knex` builds?
Can't mock/stub knex methods
Use one combined property in knex to query two separate columns in PostgreSQL
Query using Knex - withGraphFetched and where clause
Knex transactions having queries on multiple table?
Knex migrate:make fails when using TS and ESM modules