Meziantou.Framework.SimpleQueryLanguage 1.0.1

Meziantou.Framework.SimpleQueryLanguage

Syntax inspired from KQL (specification)

Usage

record Person(string FullName, DateTime DateOfBirth);

var collection = new List<Person>(');

var queryBuilder = new QueryBuilder<Person>();

queryBuilder.AddHandler<string>("name", (obj, value) => obj.FullName.Contains(value, StringComparison.OrdinalIgnoreCase));
queryBuilder.AddRangeHandler<int>("age", (obj, value) => (DateTime.UtcNow - obj.DateOfBirth)..Contains(value, StringComparison.OrdinalIgnoreCase));

var query = queryBuilder.Build("name:sample query");
query.Evaluate(new() { StringValue = "sample" })

Supported syntax

• Logical operators NOT, AND, OR
• Priority using (, )
• AddHandler: supported operators: :
• AddRangeHandler: supported operators: :, <, <=, >, >=, .. (range)
• SetTextFilterHandler matches all non-bound filters
• Special values: today, yesterday, this week, this month, last month, this year, last year

Examples:

• name:john or name=john
• name:"john doe"
• name<>john or -name:john or NOT name:john
• (name:"john doe" OR name:jane) AND age>21
• created:"this week"
• age:13..19 (lower and upper bound are included)
• age>=21
• is_open:true free form text
• is_open:true AND NOT "free form text"