D
My db is a legacy one , and it has some error data
Size: a a a
2021 April 16
D
I have to avoid those
D
And hence giving it in where condition
YZ
it was expect result with this value
D
Still it fetches me data with the value '0000-00-00 00:00:00'
D
Even I have given it as not equal to
YZ
try use connection.not()
D
Found the reason for that
D
For the column disabled_at , in the models I have mentioned it's datatype as date
D
And hence sequelize isn't allowing me to manipulate the error date
D
So I changed it to datatypes.string , so now it fetches as a string
D
And allows me to check the condition too
YZ
but you will get as string
KG
Всем привет. Нужна помощь с SQL. Есть таблица билетов, с полем владельца ownerId. Как можно составить запрос, чтобы по id билета вытащить владельца и найти все остальные билеты этого владельца
KG
в одном запросе
2021 April 18
HS
HS
это асинхронная библиотека?
YZ
добрый день, да
HA
Hello guys, how to get attributes of attributes table pivot?
HA
"insumos": [
{
"id": 7,
"compra_id": 4,
"insumo_id": 1,
"quantidade": 4,
"valor_unitario": 33
},
{
"id": 8,
"compra_id": 4,
"insumo_id": 2,
"quantidade": 4,
"valor_unitario": 210
}
]
{
"id": 7,
"compra_id": 4,
"insumo_id": 1,
"quantidade": 4,
"valor_unitario": 33
},
{
"id": 8,
"compra_id": 4,
"insumo_id": 2,
"quantidade": 4,
"valor_unitario": 210
}
]