Query Results

Sometimes you want to do analytics on top of your rule results, or to combine data stored in separate databases. In LogicLoop, you can create rules from the results of other rules. These are called meta rules.
LogicLoop stores the latest result from each rule’s queries in an in-memory database. You can see a video example of how to combine data from different rules here, so you can combine your Google Sheets with a production database, or your warehouse with an API data source. Simply add Query Results as a new Data Source, and just give it a name that you’ll use from the dropdown in your rule.
Then, write your rule using SQLite query syntax. You access the results of your other rules as "tables" aliased as query_ followed by the query id you can get from the rule’s URL.
The rule shown here has a query ID of 12
This will re-run the query defined in that rule. If you want to speed up performance and use the last result of the query instead, you can use the alias cached_query_xx. You can also combine data from different sources by joining query results.
This meta-rule allows you to combine the results of query_12 and query_10
LogicLoop cannot query rules that use parameters. You’ll see "Error running query: Failed loading results from query id xx". You can remove parameters to fix this issue.
Last modified 8mo ago