If you have a templated filter in a derived table and you reference that table in another derived table, can you pass the filter value through?

Knowledge Drop

Last tested: Jan 10, 2019
 

No, you would have to create the templated filter in your new derived table. The DT doesn’t “store” the templated filter, it’s just part of the sql.

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: