How can I do an optional where clause in building the query?

[laukaichung]

I'm stuck at building a query. Would you please tell me how to do an optional where clause? The where() clause doesn't return the table instance.

  let table = db.tournaments;
    if (value) {
      table = table 
        .where("value")
        .equals(value)
    }
    return table 
      .offset(getOffset(page, itemsPerPage))
      .limit(itemsPerPage)
      .reverse()
      .toArray();

[dfahlander]

const collection = value
  ? table.where('value').equals(value)
  : table.toCollection();

return collection
    .offset(getOffset(page, itemsPerPage))
    .limit(itemsPerPage)
    .reverse()
    .toArray();