queryBuilder.where("orders.status = :status", {
status: query.status,
}).andWhere(
new Brackets((qb) => {
qb.orWhere("orders.title LIKE :title", {
title: `%${query.name}%`,
}).orWhere("orders.description LIKE :description", {
description: `%${query.name}%`,
});
})
);
queryBuilder.where(
"orders.status = :status AND (orders.title LIKE :title OR orders.description LIKE :description)",
{
status: query.status,
title: `%${query.name}%`,
description: `%${query.name}%`,
}
);
const fruits = [
{id: 1, type: 'apple', price: 52},
{id: 2, type: 'apple', price: 76},
{id: 3, type: 'orange', price: 48},
{id: 4, type: 'orange', price: 52},
{id: 5, type: 'apple', price: 32},
{id: 6, type: 'pineapple', price: 52},
{id: 7, type: 'apple', price: 88},
{id: 8, type: 'pineapple', price: 66},
{id: 9, type: 'apple', price: 52},
{id: 10, type: 'pineapple', price: 88},
];
const newFruits = fruits.filter(({ type }) => type !== "apple");
console.log(newFruits);