Goal is to provide a simple DSL to users to ease data query in UI :
- UI would show text filter for each data property
- If valid, filter will fill a SQL query (join and where clause)
- Filter can apply to
Boolean,Number,Date,EnumandStringtypes
See this unit test for an example
Is available through this class
- Basic expressions :
is null, is not null, is true, is false, is empty, is not empty - Basic operators :
=, !=, >, >=, <, <= - List operators :
in, not in - String operators :
like, not like - Binary operators :
and, or
is true(< 10 or >= 123.456 or in (12, 13.14)) and not in (5.5, 555)like youpi% and != youpi0 or is emptyin (USER, GROUP) or is null>= 2012-09-01 and < 2012-10-01
- Currently only
JPAQueryis supported - Find a way to provide auto-completion to user
- Not sure
Enumdata type is really working, shouldStringbe converted toEnumin JPA parameters ?