Comment on page
More rule options
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.



Last modified 3mo ago