P# Training
      Back to home
      1. Datagration Knowledge Base
      2. Customer Training
      3. P# Training

      P# Lesson 1: Production History

      Exercise 1

      Create a script that pulls the oil production rate in bbl/d for all wells and the entire production history in a monthly time increment.

      Exercise 1 Solution

      Context "All Wells FromStartToEnd Monthly"

          Entity Set "All Wells"

          Scope "FromStartToEnd Monthly"

      End Context

      Entity Set "All Wells"

          EntitiesByType("Well")

      End Set

      Scope "FromStartToEnd Monthly"

          Between StartOf()

          And EndOf()

          Step Monthly

      End Scope

      Table "Production Data"

          Column "Oil Rate" in "bbl/d"

              "oil production rate" in "bbl/d"

          End Column

      End Table