More rule options

Advanced Scheduling

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.

Parametrize a rule

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.

Query-Based Parameters

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.

Visual Query Builder

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.

Tag a rule

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.

Export your query data

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.

Add a rule to your favorites

You can add a rule to your favorites section by clicking on the little star button next to your rule.

Archive a 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.

Rule Filtering

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.

Filter by Data Source

You can see all rules that run on the same data source.

Filter by Destination

You can see all rules whos action is sent to the same destination.

Last updated