You can translate the question and the replies:

Can I return join conditions and filter conditions programmatically?

For example, I can use a predefined stored procedure such as column dependencies to get a field calculation expression. Are there are any stored procedures that provide access to the join conditions and where clause conditions in the dependencies of a view? It appears at least the join condition could be accessed because the administration tool will display the join condition in a tooltip when displaying the data lineage view. I have been unable to find a predefined stored procedure that provides join conditions or filter conditions so far. Thanks in advance for any help.
user
20-10-2022 20:24:38 -0400
code

2 Answers

Hi, As far as I read the user manuals, you can confirm view_type, dependency_type, etc by using [VIEW_DEPENDENCIES](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/stored_procedures/predefined_stored_procedures/view_dependencies#view-dependencies) stored procedure. In view_type and dependency_type, you can confirm whether the view is JOIN type. But I don’t think there is a stored procedure that you can confirm the details of join conditions and where clause conditions. If you want to confirm them, you need to access the configuration page of each view in the Virtual DataPort Administration Tool. Hope this helps!
Denodo Team
21-10-2022 04:43:13 -0400
code
Thanks for confirming. Would love to see it as a future enhancement.
user
21-10-2022 12:42:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here