Opened 14 years ago
Closed 14 years ago
#1504 closed enhancement (fixed)
Add support for LIKE expressions to JEP parser
Reported by: | Nicklas Nordborg | Owned by: | Nicklas Nordborg |
---|---|---|---|
Priority: | minor | Milestone: | BASE 2.16 |
Component: | web | Version: | |
Keywords: | Cc: |
Description
It would for example be useful to create filters like: rep('symbol') == 'BRCA%'
.
But since the parsing of operators in JEP is rather fixed we probably have to define a custom function: like(rep('symbol'), 'BRCA%')
Change History (2)
comment:1 by , 14 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:2 by , 14 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
I think it would be possible to detect if a '%' is present in the right-hand argument in the filter string and then use LIKE in the SQL expression instead of ==. It will break existing expressions that search for an explicit '%' but they could be re-written as:
'BRCA%' == rep('symbol')