You can translate the question and the replies:

List all interfaces with field names

We're looking to get a list of all our interfaces, with field names, and preferably attributes (ex. data type, max length). The end goal is to allow report developers to be able to search for all interfaces which contain specific field names. Is this possible?
user
05-12-2019 17:35:48 -0500

2 Answers

Hi, To get a list of all my interface views with the field names and their attributes, I made use of the Denodo's [predefined stored procedures](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/use_of_stored_procedures/use_of_stored_procedures). In particular, I used: * [GET_VIEWS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) to get the list of interface views * [GET_VIEW_COLUMNS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_view_columns) to get the relevant field names and their attributes What I did was first create two views with the following queries: ``` SELECT name FROM GET_VIEWS() WHERE view_type = 2; SELECT view_name, column_name, column_vdp_type, column_size FROM GET_VIEW_COLUMNS(); ``` Then, I created a [join view](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views) of those two views with the JOIN condition "<view1>.name = <view2>.view_name" and removed any unnecessary columns. Upon executing the join view, a list of all interfaces and their field names and attributes will be returned. Hope this helps!
Denodo Team
06-12-2019 13:04:42 -0500
Very helpful, I was able to get what I needed using GET_VIEW_COLUMNS. Thanks!
user
09-12-2019 12:12:35 -0500
You must sign in to add an answer. If you do not have an account, you can register here