id
field returned. select user_id as id from users
if you want to deduplicate on a field called user_id
. You may write select created_at as id from users
if you want to deduplicate based on time stamp. You may even write select (user_id || current_date) as id from users
if you don't want to alert on the same user twice in the same day, but you want to alert on them again the next day. <@MEMBERID>
or <@username>
(with the < > brackets) into the template.LIMIT 1000
to your queries to limit the rows returned from your data. LogicLoop automatically cuts off queries that run for longer than 15 minutes in order to protect both your database and ours from being overloaded. We also recommend running your queries only as frequently as your need e.g. every day instead of every minute. select * from users where category in ({{ categories }})
. In your parameter's configuration, you can select it to automatically populate with values from another query.JSON_EXTRACT
function to extract individual data points from nested lists and dictionaries returned from your complex APIs. select * from query_12 joins cached_query_12 where query_12.status != cached_query_12.status
where query_12
is the first rule that you wrote with the original data.