You can translate the question and the replies:

How to search for / list in Denodo columns (of a view) that make use of a certain function?

How can I search for / list in Denodo all columns (of a view) that make us of a certain function? For example, I would like to list all columns that make use of "getdaysbetween"?
user
23-03-2021 05:17:27 -0400

1 Answer

Hi, You could develop a **[Custom Stored Procedure in Java](https://community.denodo.com/docs/html/browse/8.0/en//vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures)** using the Denodo4E Plugin such that it returns the list of columns in the Denodo views that uses the specific function. Once the stored procedure is created, you can import the jar file into the Virtual DataPort Server using the** ‘File -> Extensions Management’ **option available in the Virtual DataPort Administration Tool. You could refer to the Custom Stored Procedure samples available under the directory **“<DENODO_HOME>\samples\vdp\storedProcedures’’** and take a look at the README file for testing it. Hope this helps!
Denodo Team
25-03-2021 08:37:01 -0400
You must sign in to add an answer. If you do not have an account, you can register here