Description Usage Arguments Value Examples
The following functin will make a connection to an Aries database. It will then take the user defined 'propnum' vector which contains one or more Aries Propnum to query. The function will then return a dataframe object which contains enertia codes linked to the specified ariespropnum and the associated production data. the data frame is returned in the same format as the Aries AC_PRODUCT table. the export variable can be set equal to TRUE to export the output to the users desktop.
1 2 3 4 5 6 7 8 | create_AC_Product_by_Enertia_Code(
propnum,
server = "extsql01",
database = "Aries",
user = Sys.getenv("USERNAME"),
overwrite = "Y",
export = FALSE
)
|
propnum |
a character vector. |
server |
a character vector. |
database |
a character vector. |
user |
a character vector. |
overwrite |
a character vector. |
export |
a boolean value |
A dataframe containing production data formated for the AC_PRODUCT table in Aries
1 | create_AC_Product_by_Enertia_Code(enertia_codes = c("0WHEZJ4SQ4ZJ", "YXK78QADR9BZ"), user = "user01", overwrite = "N", export = TRUE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.