Categories
- All Categories
- Oracle Analytics Learning Hub
- 25 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hello, how to pass 'is not null' through prompt into a direct database request using presentation va
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.
Answers
-
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.
0 -
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?
0 -
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.
0
