public async Task<IEnumerable<Filter>> GetFiltersAsync(string tenant, string filterName)
{
using (var db = DbProvider.GetDatabase(this.Database))
{
var sql = new Sql("SELECT * FROM config.filters");
sql.Where("object_name = @0", this.FullyQualifiedObjectName);
sql.And("LOWER(filter_name)=@0", filterName.ToLower());
return await db.SelectAsync<Filter>(sql).ConfigureAwait(false);
}
}