Share clauses between queries?
A number of my reports share WHERE clauses to blacklist certain data from the reports. These blacklists are somewhat dynamic and it becomes real hairy to ensure each report is updated if it changes.
I can't seem to find a way to either:
a) Share a query between reports
b) Share a liquid definition between queries, across reports
Does anyone have a suggestion on how I can deduplicate text/logic in my queries across multiple reports?
Definitions does somewhat what I want to do. I'd have to restructure some queries so that they're doing a subselect from a centralized query which has been blacklisted already. https://help.modeanalytics.com/articles/definitions/
But it would be neat to have a Definitions-like feature which worked with Liquid to be able to insert partial queries and not full SELECTsReply
Javier Berlana the workaround I'm using, which is not performant, is to create a query in a definition which can be used as a join.
It works because my main deduplication is around creating a blacklist of records I do not want to be included in subsequent queries. My definition returns a whitelist of related records, then I query a separate table and join on to the definition.
So, to my knowledge, there still isn't really a solution to simply templating your queries across reports.Reply