You can translate the question and the replies:

Cu

Can joins be dynamically added to a live query through a custom policy using the condition parameter ? Or are the contents of the condition parameter always added to the end of the currently executing query's WHERE clause? Can somone change the topic of this post to "Joins in a Custom Policy"? I can't edit the topic.
user
20-03-2024 16:18:11 -0400
code

1 Answer

Hi, The condition parameter for custom policies needs to be evaluated per row returned, and whether that row meets the condition is either true or false. A join clause doesn't return a boolean, making it incompatible with the condition parameter. Once the condition parameter is either met or not met for a row, a filter is applied accordingly. The options for the filter to be used revolves around rejecting or masking rows. Adding a join is not included in the available options for filters. For more information on the parameters used for [Custom Policies](https://community.denodo.com/docs/html/browse/6.0/vdp/developer/custom_policies/custom_policies), you can view the [Developing a Custom Policy](https://community.denodo.com/docs/html/browse/6.0/vdp/developer/custom_policies/developing_a_custom_policy) page of the Developer Guide. Hope this helps!
Denodo Team
21-03-2024 15:59:53 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here