Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page
  • May 31, 2024 (2.19.9)
  • April 29, 2024 (2.19.6)
  • Apr 15, 2024 (2.19.5)
  • Apr 1, 2024 (2.19.3)
  • Mar 18, 2024 (2.19.1)
  • Mar 4, 2024 (2.18.7)
  • Feb 19, 2024 (2.18.5)
  • Feb 12, 2024 (2.18.4)
  • Jan 19, 2024 (2.18.1)
  • Dec 28, 2023 (2.17.6)
  • Nov 17, 2023 (2.17.0)
  • Oct 13, 2023 (2.16.7)
  • Sep 29, 2023 (2.16.6)
  • Sep 7, 2023 (2.16.4)
  • Aug 18, 2023 (2.16.2)
  • Aug 6, 2023 (2.16.1)
  • July 6, 2023 (2.15.6)
  • June 15, 2023 (2.15.3)
  • May 25, 2023 (2.15.0)
  • April 27, 2023 (2.14.6)
  • April 21, 2023 (2.14.4)
  • April 4, 2023 (2.14.0)
  • March 30, 2023 (2.13.4)
  • March 21, 2023 (2.13.3)
  • March 9, 2023 (2.13.0)
  • Feb 20, 2023 (2.11.0)
  • Jan 18, 2023 (2.10.0)
  • Sept 1, 2022 (2.9.3)
  • June 30, 2022 (2.7.4)
  • May 24, 2022 (2.7.0)
  • May 2, 2022 (2.6.0)
  • Mar 2, 2022 (2.5.0)
  • Feb 7, 2022 (2.4.0)
  • Jan 4, 2022 (2.3.0)
  • Dec 29, 2021 (2.2.0)
  • Nov 3, 2021 (2.1.0)
  • Oct 18, 2021 (2.0.0)
  • Oct 5, 2021 (1.11.0)
  • Sept 3, 2021 (1.10.0)
  • Aug 20, 2021 (1.9.0)
  • Aug 10, 2021 (1.8.0)
  • Aug 5, 2021 (1.7.0)
  • July 12, 2021 (1.6.0)
  • June 28, 2021 (1.5.0)
  • May 26, 2021 (1.3.0)
  • May 19, 2021 (1.2.0)
  • May 7, 2021 (1.1.0)

Was this helpful?

Changelog

PreviousGroups & PermissionsNextFAQs

Last updated 11 months ago

Was this helpful?

May 31, 2024 (2.19.9)

now available in Case Management

Test connections

Trigger actions

April 29, 2024 (2.19.6)

Added Microsoft Teams as

Attach CSV of query results to

moved to sidebar

Apr 15, 2024 (2.19.5)

Support for grouped tickets

Added on Rules page

UX Filtering improvements

Apr 1, 2024 (2.19.3)

Display below any destination

Added on Rules page

Mar 18, 2024 (2.19.1)

Mar 4, 2024 (2.18.7)

Feb 19, 2024 (2.18.5)

Run SQL generated by AI

Feb 12, 2024 (2.18.4)

Added action failure notification

Jan 19, 2024 (2.18.1)

Rule run and action count stored and displayed on homepage

Dec 28, 2023 (2.17.6)

Nov 17, 2023 (2.17.0)

Upgrade default AI Query Helper to gpt3.5

Add in-app data source customer support

Oct 13, 2023 (2.16.7)

Sep 29, 2023 (2.16.6)

Sep 7, 2023 (2.16.4)

Aug 18, 2023 (2.16.2)

Aug 6, 2023 (2.16.1)

July 6, 2023 (2.15.6)

June 15, 2023 (2.15.3)

May 25, 2023 (2.15.0)

April 27, 2023 (2.14.6)

Various UX Improvements (Home page, AI Query Helper, Schedule, Email)

April 21, 2023 (2.14.4)

April 4, 2023 (2.14.0)

March 30, 2023 (2.13.4)

March 21, 2023 (2.13.3)

March 9, 2023 (2.13.0)

Feb 20, 2023 (2.11.0)

Jan 18, 2023 (2.10.0)

You can now specify parameters in either UPPER_CASE or lower_case in action templates. Previously we required all parameters to be UPPER_CASE.

Sept 1, 2022 (2.9.3)

Additionally, you can choose to "Group items with the same entity ID into a single ticket". This means that if the same user triggers multiple alerts, instead of creating a new ticket for each alert, the alerts will all be grouped into one ticket under "Additional Rules Flagged"

June 30, 2022 (2.7.4)

You can now re-alert on duplicate items after a period of time. For example, let's say you have an alert that runs every hour, but you only want it to alert your team for the same issue at most once per day. You can turn on the deduplication & include a 1 day time period so that it does not alert multiple times in one day, but will alert again the next day.

May 24, 2022 (2.7.0)

Users who don't know SQL can now 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.

May 2, 2022 (2.6.0)

When you sign up for LogicLoop, we now pre-load your account with a sample database and a few rules to help you get started quickly.

Mar 2, 2022 (2.5.0)

You can now view the edit history of a query. While viewing a rule, click on the three dots menu button at the top right corner, and select 'View Edit History'.

Feb 7, 2022 (2.4.0)

Jan 4, 2022 (2.3.0)

To create a Ticket Action, first go to the 'Queues' tab on the left navbar and click on 'Settings' to configure your Ticket Actions. You will be able to select from the same actions you've set up under Action Destinations.

Next, you can click on any of your tickets and click 'Take Action' to execute the action on that ticket.

Dec 29, 2021 (2.2.0)

You can now write to Google Sheets as an action. First, create a Google Spreadsheets Action Destination.

Next, attach an Action Subscription to your rule that will write to a specific Google spreadsheet. All you have to do is paste in the URL of your Google sheet and specify which tab number you wish to write to. When you rule runs, it will write all the rows returned from your SQL query into the spreadsheet.

Nov 3, 2021 (2.1.0)

You can now write a query that refers to a list of items returned from another query. In this example below, we retrieve all api_calls whose id belongs to a list of whitelisted ids defined by another query.

To make this happen, just insert a parameter into your query using curly brackets like {{ param }} and then in the parameter's settings choose 'Query Based Dropdown List', select the query you want to pull from, and choose to automatically select all values.

Oct 18, 2021 (2.0.0)

You can now choose to receive an email notification if there has been an error running a query you wrote. To enable this feature, an admin must first go to Settings > General and turn on email query owners when scheduled queries fail.

Oct 5, 2021 (1.11.0)

You can now set up your LogicLoop queries to trigger PagerDuty alerts. Simply create a PagerDuty action destination type, enter your PagerDuty service integration key, and set up your query to trigger a PagerDuty action.

Sept 3, 2021 (1.10.0)

You can now set a rate limit on your action to prevent it from triggering downstream actions too quickly. This comes in handy if your rule returns a large number of rows and your action triggers something like a Twilio or Slack API that has a rate limit.

Aug 20, 2021 (1.9.0)

You can now take action on up to 1000 rows per rule run. Previously, we capped the maximum number of rows you can action upon at 500.

You can now include a CSV file of your query results in email destinations.

For API JSON based sources, you can now enter a custom Authorization header when you're configuring the source:

Aug 10, 2021 (1.8.0)

In this update, you can now dedup your queries so that actions are not taken on rows whose id field has been seen before. All you have to do is turn on the toggle that says Deduplicate under your action settings:

In order to enable this feature, your SQL query must return an idfield. A clever way of doing so is by naming whichever column you wish to designate as the identifier as id in your SQL query e.g.select user_id as id from accounts

Aug 5, 2021 (1.7.0)

In this update, you can now see a history of all actions that your rule has taken. Just go to your action and under history, you can click View Action Logs to see all the actions that were associated with each rule run, as well as its payload and any errors. In order to enable this feature, go to Settings > General and turn on Record and show history of rule runs under Logs.

July 12, 2021 (1.6.0)

In this update, you can now see a history of every single time your rule ran. Just go to your action and in the history section you will see a log of every rule run with information on: when it ran, what its status was, how it was triggered, and what conditions it ran under.

In order to enable this feature, go to Settings > General and turn on Record and show history of rule runs under Logs.

June 28, 2021 (1.5.0)

In this update, you can now write to your Postgres or MySQL database an action. That means you can insert, update, or delete database rows as a result of your rule run.

You can also now use Firebase as an action destination. If you want the result of your rule run to send your customers push notifications, all you have to do is enter your Firebase credentials and hook it up as an action destination!

May 26, 2021 (1.3.0)

In this update, you can now specify the To: field when you configure an email subscription. Previously, you could only hardcode the To: field once when you create the email destination, but now you can configure emails to be sent to different recipients (e.g. each of your customers) by embedding their email in the To: field.

May 19, 2021 (1.2.0)

May 7, 2021 (1.1.0)

Create actions for each row returned

Instead of triggering one action for the entire result of your rule run, you may want to trigger a separate action for each row. For instance, you may want one Slack message per customer that needs attention, or you may want to call an API endpoint for each new customer returned. Now, you can trigger actions for each row in your Trigger preferences.

Customize templates for each action

You may want to send different content in your Slack message and an email alert on the same query. Now, you can customize data sent to each downstream action. You can embed query specific data into your notifications by injecting special variables in curly braces.

Advanced webhook support

Invoke more powerful downstream APIs with advanced webhook configurations. Set authorization headers, method type, individual URLs per row returned, headers and JSON payloads.

Enabled as a

Display below any data source

Column type support added to

Extended descriptions for what should be fixed

Support verifying destination connections with

Add ACTION_LOG_URL to built-in

Show query results in

Form-based input for

Expand with Custom Details

Added more : Snowflake, Microsoft SQL Server, BigQuery, sqlite, Redshift, Databricks, RDS mySQL

now available in

Increased channel limit for

Expanded data available in

Support for live

Support SSL file upload

Add as data source

Add run logs table to

Add scheduling to

Add Query Optimizer to

Support Athena in

Added button to insert into

Increased channel limit from 1000 channels to 10,000 channels

Added database schema retrieval API for

Added database schema update API for

Added database schema creation API for

Support table selection from data schema for

Multiple new AI models are avilable in the (gpt-4, gpt-3.5-16k, Anthropic Claude)

Additional UI filtering for , including author

Additional UI filtering for , including creating rule

Ticket row data is now available in

Google Sheets added as an Auth Integration

Add Batch Assign to

Add support for Oracle SQL to the

Additional UI filtering for , including searching by rule name and assignee

Additional UI filtering for , including run schedule and action status

[BETA]

Query Editor added to

released

Query Fixer added to

Additional data sources supported by

Query Explainer and Query Generator added to

Added to Ticket Action

Support empty field state for

Added common destinations.

We support .

Ticket comments are available in your .

We now support for tickets. Track specific criteria across your case management.

Your own LogicLoop data can now be . You can to track the success of your workflow and escalate any unresolved issues.

You can now together in actions. Create an action subscription to trigger a rule and pass your results as parameters.

You can now batch archive tickets. Instructions on how to do so can be found .

You can now associate an entity ID to generated by LogicLoop rules. This is helpful if a single user can generate multiple alerts and you want a way of associating all the alerts to a single user. Entity IDs are searchable so you can search up all tickets that belong to the same entity.

LogicLoop now provides autocomplete suggestions for when editing or subscriptions. The parameter options will automatically appear below once you type the opening curly braces.

There is now a new home screen with step by step instructions to help you get started with LogicLoop. In addition, check out our and .

You can now write to DynamoDB as an . That means you can have your rule insert or update database rows each time it runs.

You can now take actions on your tickets! For workflows that involve a human in the loop, you may want to first schedule a LogicLoop rule that whenever the rule is triggered. Afterwards, a human can follow up on that ticket and manually execute an action on it e.g. Approve or Deny a user.

We've introduced a more user friendly Webhook Builder action destination type to allow you to construct a webhook request. In addition, a technical user on your team can set up a webhook endpoint once, which your non-technical user can then plug and play where ever necessary. .

In this release, we introduce LogicLoop’s case management system. You can create, assign, filter, and triage tickets under the Queues tab. You can also have your rule runs automatically generate tickets for triage. and read more .

In this release, we’re letting you take more custom and powerful actions on the results of your LogicLoop queries. .

Oracle
data source
AI Query Helper
templating parameters
Ask AI
PagerDuty destination
databases as destinations
Template parameters
Slack messages
Slack integrations
LogicLoop Data Source
MySQL data source
Azure MySQL
LogicLoop Data Source
Action Setup
AI Query Helper
AI SQL API
template parameters
action subscriptions
Slack integration
AI SQL generation
AI SQL generation
AI SQL generation
AI SQL generation
AI SQL generation API
Rules
Tickets
Case Analytics
service
Tickets
AI SQL Suite
Tickets
Rules
AI SQL API
AI Query Helper
Ask AI
AI Query Helper
AI Query Helper
AI Query Helper
Custom Fields
Destination
Custom Fields
webhook
LogicLoop data source
Custom Fields
a data source
chain rules
tickets
new demo
templates here
action
creates a ticket
More info here
You can watch a demo here
detailed documentation about the full feature here
You can watch a demo here
destination
AI SQL Copilot
template parameters
Ticket Attachments
Test Connection
toggling alert subscriptions
grouped by column
list of associated alerts
webhook destination
Slack alerts
action
Google Sheets data source
Example of what a failed query email looks like
A PagerDuty action
What the alert looks like in PagerDuty
AI Query Fixer
here
ticket action
list of associated rules
viewing subticket data
filter by destination
filter by data source
Advanced Scheduling