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

knex muliple like query

Restu Wahyu Saputra answered on April 4, 2021 Popularity 1/10 Helpfulness 1/10

answer knex muliple like query

knex muliple like query

Comment

public async getFilteredItems(searchCriteria): Promise<any[]> {
    const table = 'items';
    const columns = ['itemName', 'itemType', 'category'];
    const qb = (query) => {
      for (const col of columns) {
        query.orWhere(`${table}.${col}`, 'like', `%${searchCriteria[col]}%`);
      }
    }
    return await knex(table).where(qb);
}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: javascript

Link to this answer
Share Copy Link

Contributed on Apr 04 2021

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

knex muliple like query

Contents

More Related Answers

knex muliple like query

Grepper

Documentation

Social

Legal

Contact

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