I’m writing an add-on query that takes into account data from a bunch of tables (14 when all is said and done, I think). Rather than just returning data from all the tables, it uses the data on one table to determine what data to join from the next table.
The way you have the query builder should work just fine, except that I’m 99% sure there’s a bug.
When I’m selecting data in this level of the query builder:
…it works fine if:
-The value is static (ex: 60)
-The value is an input (ex: input: duration)
But it does not work if I use a value from another joined table (ex: activity.duration).
I can select the value from a joined table–but it does not compute it. If it’s a #, it uses 0. If it’s text, it throws an error.
The filters I’m trying to use with dynamic table data are:
None of them work if I use a joined table value. They only work with a static value or an input value.