[ZEPPELIN-583] SQL Interpretreter ,should have the functionality to handle 'ALL' .

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.5.5
• Component/s: Interpreters
• Labels: Interpreter Sql
• Assignee: Unassigned
• Reporter: pralabhkumar
• Created: 07/Jan/16 09:54
• Updated: 23/Jul/16 22:04

Description

Currently SqlInterpreter will create listbox ${startdate='2013-08-30'} using this. But we should be able to provide value 'ALL' . So for e.g

select col1
from
table1
where ${col2='a'|'a','b'}

will create list box with value a and b , and based on user selection ,query filter will be replaced by user selection. We should have 'ALL' in the list which should remove the condition

select col1
from
table1
where ${col2='a'|'ALL','a','b'}

If user selects 'ALL' query should get converted

select col1
from table1