i have two tables user and status

i manage to do association between them and it works but how to insert with association?

anybody?

Без него писать самому... Долго получится.

можно сделать форк с исправлением и его юзать пока в основной не поправят

ну ли ждать) но обычно эт не быстро

Да. Но этот баг обходится дополнительным кодом в проекте.

i have this associations between status table and user... and i want to print statusName and not Id

Google it pls

Hello, I am trying to get Company list, my problem is about taking included CopmanyType neme as language compatible. For this I created an query it works.  Is there any way to include this query instead of included CopmanyType that showed at photo as procedure ?

Is my system right or could you recommend me any other better way?

This is my sample query that if there is no "de" on "Translates" table then taking default language that "en" from "CompanyTypes" table.

SELECT
ctt.IDX,
ctt.TypeName,
ctt.LanguageCode
FROM (
SELECT
   ct.IDX as IDX,
   ct.TypeName AS TypeName,
   "en" AS LanguageCode,
   1 as Priority
FROM CompanyTypes AS ct

UNION ALL

SELECT
   ct.IDX as IDX,
   t.Translated AS TypeName,
   t.LanguageCode AS LanguageCode,
   2 as Priority
FROM CompanyTypes AS ct
INNER JOIN Translations AS t ON LOWER(t.English)=LOWER(ct.TypeName)

ORDER BY IDX, Priority DESC
) AS ctt
where LanguageCode = "en" OR LanguageCode = "de"
GROUP BY ctt.IDX

sequelize is a model way. as for better to use more simple queries that one big. I don't understand why u use wrapper for query and your question

For example I am trying to get companies; like
Copmanies.find({
include: [
    association: 'CompanyTypesTranslated',
    where:{
         LanguageCode:"de"
    }
]
});

It will include CopmayTypes, if there is some columns not translated yet then will get "english" one as default.

what the question?

i don't understand what "translated" is it. i don't know ur business logic

can you make your question more concrete?

HI,.. i need some help with sequelize....
I have 3 tables
User
Book
UserBooks (it's a relation betwen  User and Books)
I need to know wich books is not related to a given userId

U can use association as in pinned message

using association, i just got books related to the user...