Bug 160113 - [filters] Define a query language for filters, e.g. OQL
Summary: [filters] Define a query language for filters, e.g. OQL
Status: NEW
Alias: None
Product: Target Management
Classification: Tools
Component: RSE (show other bugs)
Version: unspecified   Edit
Hardware: PC All
: P3 enhancement (vote)
Target Milestone: Future   Edit
Assignee: Michael Scharf CLA
QA Contact: Martin Oberhuber CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-10-06 22:43 EDT by Michael Scharf CLA
Modified: 2007-07-25 07:48 EDT (History)
0 users

See Also:

Attachments
Screenshot showing generic filters in Thunderbird (18.08 KB, image/gif)
2007-07-25 07:48 EDT, Martin Oberhuber CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Scharf CLA 2006-10-06 22:43:12 EDT 
A query language for filters would be helpful I'd suggest to use SQL syntax. This is well known and a well know standard. It would fit well into the "Tables" of RSE. The simple "Subset" semantics could be easily mapped to SQL.

I have a written small library (<3000 lines of code) that implements SQL (actually OQL) expressions. It is very easy to use. 

If there's interest, we could contribute it to RSE.
Comment 1 Martin Oberhuber CLA 2006-10-18 10:39:30 EDT 
Michael, it would be great if you'd consider contributing the OQL library.
Comment 2 Martin Oberhuber CLA 2007-07-25 07:48:33 EDT 
Created attachment 74547 [details]
Screenshot showing generic filters in Thunderbird

A UI for preparing filters in the generic filtering language could be like the one provided by Thunderbird if you do View > Customize... Add (see attached screenshot):
Query conditions can be combined by AND and OR, each condition can select one field to check, and available checks are defined by the type of each field (is, contains, matches, ...)

This UI is simple to use and understand yet very powerful.