Hello, how to pass 'is not null' through prompt into a direct database request using presentation va

Question

how to pass 'is not null' through prompt into a direct database request using presentation variable?

i am trying the below format which is working for other operators like '<','>' and user can input values which will passed through another presentation variable but is not working for 'is not null'

and column1 '@{p_variable}{is not null}' DECODE('@{p_variable1}','',column1,'@{p_variable1}')

Any help is much appreciated.

Gianni Ceresa · Answer

And my reply will still be the same...

You can decide to ignore 95% of what the product is by using a DDR, but at some point you either follow the product rules or just don't use the product.

Sindhu-Oracle · Answer

My question is, i have a variable prompt through which i need to pass 'is not null' for a quantity column in direct database request. How do i do it?

Gianni Ceresa · Answer

If you compare '<' or '>' to IS NOT NULL : what is the operator and what is the value? '<' or '>' == IS [NOT] , value == NULL (it isn't exactly that because IS [NOT] NULL is an unary operator, but it gives you an idea of the behavior of your variable and the default value). Your variable is replaced in the query, what does the SQL looks like if the variable has a value? column1 42 , how can this thing be a valid SQL? You have to think at what the variables are replaced with, not just randomly put them there hoping that the database will guess what you had mind receiving a column and a value without any operator.