Prompts/Filter options

[NoobieRhyme]

Hi! May I ask question on the Prompt/Filter capabilities:

1. I have a prompt that a user can select one of the listed elements. Is it possible to have a filter that an attribute can apply comparison filter between the attribute and selected element?
For example I have a list of levels, (1, 2, 3, etc )
Then I want a filter something like:
Attribute1 > selected level

2. In a filter/prompt, is it possible to have a dynamic operator? The user selects operator (Greater than, less than, etc) and value criteria?

Thanks!

 

[NoobieRhyme]

Select x1.column1 from Table1 x1
where x1.column1 >
(Select x2.column1 from Table x2
where x1.column1 = 5)

============================================

the last clause parameter "x1.column1 = 5"
is the result of a prompt entry.

but is it possible that the the prompt uses the table x2 instead of x1? so im expecting a
"x2.column1 = 5" in the last clause.

How? please. Thanks!