More rule options
Last updated
Last updated
When configuring rule schedules that occur more frequently than daily, you have the flexibility to customize the specific days of the week and the time range during which you want the rule to automatically run. This feature enables you to schedule rules to run frequently, but restricts their execution to specific business operating hours.
Not everyone on your team knows SQL? LogicLoop helps you write the queries and parametrize them so your teammates can pull business levers without knowing how to write SQL.
Parameters can be dropdown lists, dates and plain text values.
To add a parameter, click the curly braces at the bottom of your query editor or press Cmd + P. Alternately, you can just type double curly brackets to insert a parameter into your query.
The Add Parameter modal will now let you define the keyword, title and type of the parameter.
Another useful functionality of parameterization is being able to pull from another query a list of values. Dropdown lists can be tied to the results of an existing query. Just click Query Based Dropdown List under Type in the settings panel. Search for your target query in the Query to load dropdown values from bar.
If your target query returns more than one column, LogicLoop uses the first one. If your target query returns name and value columns, LogicLoop populates the parameter selection widget with the name column but executes the query with the associated value.
For example, let's say in your query you want select users who fall into a few whitelisted categories that you have defined in GSheets. You can write a query like: select * from users where category in ({{ list_of_categories_from_gsheets }}). In your parameter's configuration, you can select it to automatically populate with values from another query that retrieves the list of categories from GSheets.
Users who don't know SQL can use LogicLoop's Visual Query Builder to query for data just by choosing a few drop down filters. If your database is Postgres, MySQL, Redshift, Snowflake, or BigQuery, the option to use the Visual Query Builder will automatically show up in the top right corner of your query's page.
It can be very useful to group rules by function. You can tag a rule by going to the edit rule page and hovering to the right of the rule name, you should see + Add tag.
You should see a popup that lets you add multiple tags or create them.
Now you can filter by tags in the main rules listing page.
You can export data returned from a query as a CSV, TSV, or Excel file by clicking on the three dots at the bottom left corner of your query.
You can add a rule to your favorites section by clicking on the little star button next to your rule.
If you want to delete a rule because you don't need it anymore, simply go to the top right corner of your rule and hit Archive. Archived rules will no longer run.
The LogicLoop Rules page supports filtering for convenient navigation and analysis of your workspace. Rules can be filtered by author, run schedule, and action status.
You can see all rules that run on the same data source.
You can see all rules whos action is sent to the same destination.
