Q&A BY TAG 'baseview created from query'
On base views created from query with parameters-how can we pass the parameters from a subquery in where statement
answered
14-06-2022 05:57:06 -0400
I have created a base view from query which contains parameters that I need to pass in order to get the result set. Base view name is bv_root_table. Parameter for the base view that is required that we pass is AccountID field. I am trying to execute a...
Answers:
3
Invalid query in create base view from query View without search methods baseview created from query Parameter Subquery
Base view gets created from query, however, cannot execute it.
answered
02-06-2022 19:59:32 -0400
I am able to create a base view from query, and do not get any error messages when creating it, given the instructions. However, when I attempt to execute it, I get following error message. Code is fine, and it runs with no issues and returns results, ...
Answers:
1
Related to:
Invalid query error using Create base view from query
Create Base View from query
answered
19-07-2019 01:20:22 -0400
Hello, When creating a base view from query, I am always successful when creating a base view from query when I do a straight select with condititions. However I noticed when I try to put in a query where I create temp tables it does not work. Is there...
Answers:
1
Joining View Created From Stored Procedure to View Created from "Create from query" option - Not Working
answered
17-07-2019 09:46:41 -0400
Hello, Can a view created from a stored procedure be joined with a view created from the "Create from query" option? I have a report that runs perfectly now. The report is generated from a view created from a stored procedure joined to a view created t...
Answers:
5
How to get list of base views which are created from query?
answered
04-04-2019 07:21:07 -0400
I need to fetch list of all baseviews which are created from query. Kindly suggest how can we get the list in Denodo 6.0
Answers:
3