Example Workflows
      Back to home
      1. SUPPORT CENTER
      2. Workflow Automation
      3. Example Workflows

      Update Issues Information (Workover LPO Calculation)

      ResNet Dashboard Overview


      Welcome to ResNet! In this module, we’ll walk through setting up a workflow that automatically updates an issue with additional data from SQL after it’s created. This is useful for adding financial values, production metrics, or other key information to new issues.

      Let’s get started!

      Step 1: Setting the Trigger for Issue Creation

      Navigating to the Workflow Editor


      First, we need to define the trigger event.
      • Select Issue Created as the trigger.
      • This ensures the workflow runs whenever a new issue is created in ResNet.
      Since the trigger doesn’t provide all the details we need, we’ll pull in more information next.

      Step 2: Retrieving Issue Details

      Using the List Issues Component

      To get all the necessary details about the newly created issue:
      • Add the List Issues Component.
      • Filter by Issue ID from the trigger to retrieve full issue details.
      This allows us to access important data fields, such as the campaign ID and asset information.

      Step 3: Filtering for Workover Campaigns

      Adding a Branch Component

      Now, we’ll filter the issue to check if it belongs to a Workover Campaign.
      • Use a Branch Component to create conditional logic.
      • Apply a filter where Campaign Name contains “Workover”.
      If the issue is part of a workover campaign, we’ll proceed with updating it using SQL data.

      Step 4: Querying SQL for the LPO Value

      Adding a SQL Query Component
      Now, let’s retrieve the LPO value from an external SQL database.
      • Add a SQL Query Component.
      • Filter the SQL table where Well ID matches the Asset ID from the issue.
      • This ensures we pull the correct LPO value for the asset linked to the issue.
      Once retrieved, we’ll store this value to update the issue.

      Step 5: Updating the Issue with the LPO Value

      Adding the Update Issue Component

      Now, let’s stamp the LPO value onto the issue.
      • Add the Update Issue Component.
      • Use the Issue ID to ensure the correct issue is updated.
      • Reference the LPO value from the SQL query and store it in a custom field on the issue.
      This step ensures that every new issue includes the most up-to-date LPO data automatically.

      Recap & Next Steps


      That’s it! You’ve successfully set up a workflow that automatically updates issues with SQL data in ResNet.
      ✅ Triggers when a new issue is created
      ✅ Filters for Work over Campaigns
      ✅ Queries SQL for relevant asset data
      ✅ Updates the issue with the LPO value
      Need more help? Check out our support documentation or reach out to our team. Happy automating!