More rule options

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.
Another useful functionality of parameterization is being able to pull from another query a list of values. 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.

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.