In order to retrieve all the derived views from all the folders with the requirements below:
* Providing the partial name of the folder in the where condition.
* Using generic search instead of mentioning the folder number.
I could specify the** "where"** condition for the folder column with the **'like'** operator in the **"GET_VIEWS"** predefined stored procedure as mentioned in the below example:
select name from GET_VIEWS() where folder like '%derived%'
By executing the above query, I was able to retrieve all the derived views from all the folders in the Virtual DataPort Administration Tool. For more information about the like operator and the GET_VIEWS stored procedure, you can take a look at the [Comparison Operators](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/language_for_defining_and_processing_data_vql/comparison_operators/comparison_operators#comparison-operators), [GET_VIEWS](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_views#get-views) sections in the Virtual DataPort VQL Guide.
Hope this helps!!