--- title: Update Issues Information (Workover LPO Calculation) description: Update Issues Information (Workover LPO Calculation) --- [Skip to content](https://support.resnet.ai/migration/update-issues-information-workover-lpo-calculation#main-content) English Show submenu for translations ![](https://support.resnet.ai/hs-fs/hubfs/primary_logo%20(1).jpg?width=6782&height=2762&name=primary_logo%20(1).jpg) Open main navigation Close main navigation - English Show submenu for translations - Contact us Contact us How can we help you? - There are no suggestions because the search field is empty. 1. [SUPPORT CENTER](https://support.resnet.ai/migration?hsLang=en) 2. [Workflow Automation](https://support.resnet.ai/migration/workflow-automation?hsLang=en) 3. [Example Workflows](https://support.resnet.ai/migration/workflow-automation?hsLang=en#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! - [ResNet For Field](https://support.resnet.ai/migration/resnet-for-field?hsLang=en) - [ResNet For Office](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#main-content) - [Admin](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#admin) - [Home](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#home) - [Assets](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#assets) - [Issues](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#issues) - [Campaigns](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#campaigns) - [Resources](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#resources) - [Field Dispatch Console](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#field-dispatch-console) - [Gamification](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#gamification) - [Routes](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#routes) - [User Groups](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#user-groups) - [Credentials](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#credentials) - [Forms](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#forms) - [Admin Panel](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#admin-panel) - [Filtering](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#filtering) - [Custom Fields](https://support.resnet.ai/migration/resnet-for-office?hsLang=en#custom-fields) - [Integrations](https://support.resnet.ai/migration/integrations?hsLang=en) - [Release Notes](https://support.resnet.ai/migration/release-notes?hsLang=en#main-content) - [Feature Releases](https://support.resnet.ai/migration/release-notes?hsLang=en#feature-releases) - [FAQs](https://support.resnet.ai/migration/faqs?hsLang=en) - [Onboarding](https://support.resnet.ai/migration/onboarding?hsLang=en#main-content) - [Office](https://support.resnet.ai/migration/onboarding?hsLang=en#office) - [Field](https://support.resnet.ai/migration/onboarding?hsLang=en#field) - [Workflow Automation](https://support.resnet.ai/migration/workflow-automation?hsLang=en#main-content) - [Build Integrations](https://support.resnet.ai/migration/workflow-automation?hsLang=en#build-integrations) - [Ready-to-use-components](https://support.resnet.ai/migration/workflow-automation?hsLang=en#ready-to-use-components) - [Example Workflows](https://support.resnet.ai/migration/workflow-automation?hsLang=en#example-workflows) - [Documentation](https://support.resnet.ai/migration/documentation?hsLang=en) [![](https://support.resnet.ai/hs-fs/hubfs/primary_logo%20(1).jpg?width=6782&height=2762&name=primary_logo%20(1).jpg)](https://support.resnet.ai/?hsLang=en) [mailto:email@email.com](mailto:email@email.com) Copyright © 2026, ResNet AI