Breaking News: Grepper is joining You.com. Read the official announcement!

sequelize relation where

Restu Wahyu Saputra answered on March 8, 2024 Popularity 6/10 Helpfulness 2/10

answer sequelize relation where

related sequelize where relationship

sequelize relation where

Comment

if (query?.search) {
    queryParams = Object.assign(queryParams, {
        [Op.or]: [{
                ['$transaction.topup.address$']: {
                    [Op.iLike]: `%${query.search}%`
                }
            },
            {
                ['$transaction.remittances.address$']: {
                    [Op.iLike]: `%${query.search}%`
                }
            },
            {
                ['$transaction.payment.address$']: {
                    [Op.iLike]: `%${query.search}%`
                }
            },
        ],
    })
}

const callbacks: Callback[] = await this.callbackService.findAll({
    where: {
        partnerId: user.partnerId,
        ...queryParams
    },
    attributes: ['createdTime', 'transactionId', 'status', 'responseData'],
    include: [{
        model: Transaction,
        include: [{
                model: Topup,
                attributes: ['address']
            },
            {
                model: Remittances,
                attributes: ['address']
            },
            {
                model: Payment,
                attributes: ['address']
            },
        ],
    }, ],
})

Popularity 6/10 Helpfulness 2/10 Language typescript

Source: Grepper

Tags: relation typescript where

Link to this answer
Share Copy Link

Contributed on Mar 19 2024

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

Closely Related Answers

sequelize where relationship

Comment

		let merchants: Merchant[] = await this.merchantService.findAll({
			where: { 'partnerId': user.partnerId, ...queryParams, '$merchantDetail.brandname$': 'KPK' },
			offset,
			limit,
			order: [['createdtime', order]],
			include: [
				{
					model: Partner,
					attributes: ['id', 'code'],
					include: [{ model: User, attributes: ['status'] }],
				},
				{
					model: MerchantDetail,
					attributes: ['id', 'companyName'],
				},
				{
					model: Account,
					attributes: ['id', 'number'],
				},
			],
		})

Popularity 6/10 Helpfulness 2/10 Language typescript

Source: Grepper

Tags: relationship where typescript typescr

Link to this answer
Share Copy Link

Contributed on Mar 08 2024

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

sequelize where relationship

Comment

return Book.findAll({
    where: {
        '$Authors.lastName$': 'Testerson'
    },
    include: [
        {model: Author, as: Author.tableName}
    ]
});

Popularity 6/10 Helpfulness 1/10 Language typescript

Source: stackoverflow.com

Tags: typescript relationship where type

Link to this answer
Share Copy Link

Contributed on Mar 08 2024

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

sequelize relation where

Contents

More Related Answers

sequelize relation where

Closely Related Answers

sequelize where relationship

sequelize where relationship

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.