count api can be used to count records in a table. You can use where to filter results similar to select.

Sql

Select count(*) From Table_Name;
Where
    Column1=some_value
and
    Column2=some_another_value;

JsStore

const results = await connection.count({
    from: "Table_Name",
    where: {
        column1: some_value,
        column2: some_another_value
    }
});
// results will be a number
console.log(results);

Example