You can translate the question and the replies:

vql shell to return all the views under some folder

Do we have vql shell that can return all the object name under one folder, including view, associations or folder? The purpose is to get all the object under one folder by script, such as python script. Thanks.
user
06-08-2020 11:22:38 -0400

1 Answer

Hi, I use the predefined VQL stored procedure, [GET_ELEMENTS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/storedprocedures/predefinedstoredprocedures/getelements), for retreiving information about the elements of the server. In the VQL shell, the below query works fine for me, `select* from get_elements() where folder= '<foldername>'` Please note that for the procedure to return the results, the user has to have CONNECT privilege over the database and METADATA privilege over the elements. You could also create a VQL script by modifying the command based on your use case. Hope this helps!
Denodo Team
10-08-2020 05:09:32 -0400
You must sign in to add an answer. If you do not have an account, you can register here