How to join the tables on the custom fields in Sequelize JS

[Alexey Prokoptsev]

HI.I have some difficulty with usage sequelize.js. There are the following data model (simplified):
  

var Organization = sequelize.define('organization', {
  organizationRegId: {
    type: Sequelize.STRING(250),
    field: "organizationregid",
  }
});

var Person = sequelize.define('person', {
  organization: {
    type: Sequelize.STRING(250),
    field: "organizationid",
  }
});

Need to get all users whose identifier (organizationregid) intersects with the organization identifier in the organization (organizationid).
In sql query looks like this:
   

SELECT * FROM persons AS p LEFT JOIN organizations AS o ON p.organizationid = o.organizationregid;

I can't change data schema.
I'm experimented with hasMany, but failed.

[Mick Hansen]

Please add your association setup aswell.
Is organizationregid not the primary key? 
hasMany only supports mapping from a foreign key to a primary key, not from a foreign key to an arbitrary column

--

Mick Hansen

@mhansendev
mhansen.io

[Alexey Prokoptsev]

Problem is that the models are not related directly(If I understand you correctly). I need to attach organizations to the person which person.organizationid equal organization.organizationregid.

Yes, organizationregid isn't the primary key

воскресенье, 6 декабря 2015 г., 0:28:52 UTC+3 пользователь Mick Hansen написал:

[Mick Hansen]

Sequelize does not support non primary key relations for hasMany.

So if your two models are not related by a primary key and they need to be 1:M you'll have to do it manually at the moment.

[Alexey Prokoptsev]

Ok.

Could you show an example for  manually query?

воскресенье, 6 декабря 2015 г., 16:09:59 UTC+3 пользователь Mick Hansen написал:

[Mick Hansen]

First query the organization, then query for persons with a where based on values from that organization.