You can translate the question and the replies:

How to query on different View?

I have 3 derived view **A**, **B** and **C**. I want to pass parameter from web services like **B** then the query agains **B** derived view. If I pass **C** then the query agains **C** derived view. This is possible in Denodo ??
user
09-07-2019 09:59:46 -0400

3 Answers

Hi, I could access derived views having same schema in my Denodo Virtual Data Port through REST with viewname as search method. First, I created a JDBC datasource with Denodo Virtual DataPort 7.0 adapter. Then, used the create from query option to create a base view. In this, I used viewname as interpolation variable. For eg:`select * from @viewname`.So that the view name can be passed at run time to display the data for that view. Once this base view was created, I published it as a web service and was able to access it dynamically by passing the viewname as input in search method. Since the schema of the base view is fixed at create time, this would only work for views with same schema and column names. Currently, I do not believe dynamic creation of view schema is available in Denodo Virtual DataPort. So If your derived views are having same schema it can be accessed by the above suggested way. For base view creation and publishing as web service you can refer to [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) and [Publishing REST Web Services](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/publication_of_web_services/publishing_rest_web_services/publishing_rest_web_services) section of Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
10-07-2019 07:53:26 -0400
I have one base view top of that I am creating 3 diffrent logic Derived view. I need somthing on Derived view not on Base view.
user
10-07-2019 09:24:37 -0400
Hi, It appears the question was answered on a different thread, you can follow the Denodo Community Q & A [How to query on different View using web services?](https://community.denodo.com/answers/question/details?questionId=9060g000000XeniAAC&title=How+to+query+on+different+View+using+web+services%3F) for latest updates. Hope this helps!
Denodo Team
17-07-2019 08:22:31 -0400
You must sign in to add an answer. If you do not have an account, you can register here