Creating dynamic 'andWhere' queries in TypeORM

Question

I'm trying to dynamically add a where clause to a query to filter an HTML table. I send an object to my API that contains filtered key-value pairs. It looks like this:

{Location: 'Seattle', Status: 'Active'}

Here's how I add each filter to the query:

const query = this.tableRepository.createQueryBuilder('myTable')
    .where('myTable.id = :id', {table_id})

varind=1
for (let key in myObj){
    var varname = 'searchVal' String(ind)
    const searchVal = myObj[key]
    query.andWhere(`row_value.row_data->> '${key}' ILIKE :${varname}`, {varname: `%{searchVal%`})
}

The error I keep getting is the following error: ERROR [ExceptionsHandler] syntax error at or near ":" QueryFailedError: syntax error at or near ":". I'm sure the error is triggered by the {varname: '%{searchVal}%'} at the end, but I don't know how to change it.

Answer 1

It's okay, I figured it out - I was a little silly just now.

I just need to change the last {varname: '%{searchVal}%'} to {[varname]: '%{searchVal}%'}.