---CFC---
<cffunction name="getProduction2" access="remote" returntype="any">
<cfargument name="page" required="yes">
<cfargument name="pageSize" required="yes">
<cfargument name="gridsortcolumn" required="no">
<cfargument name="gridsortdirection" required="no">
<!--- Include/Exclude Arguments --->
<cfargument name="companyIncl" type="string" required="false" default="false">
<cfargument name="countryIncl" type="string" required="false" default="false">
<cfargument name="regionIncl" type="string" required="false" default="false">
<cfargument name="basinIncl" type="string" required="false" default="false">
<cfargument name="fieldIncl" type="string" required="false" default="false">
<cfargument name="waterCatIncl" type="string" required="false" default="false">
<cfargument name="waterDepthIncl" type="string" required="false" default="false">
<cfargument name="APICatIncl" type="string" required="false" default="false">
<cfargument name="APIGravityIncl" type="string" required="false" default="false">
<cfargument name="maturityIncl" type="string" required="false" default="false">
<cfargument name="statusIncl" type="string" required="false" default="false">
<cfargument name="sourceRockIncl" type="string" required="false" default="false">
<cfargument name="productionSystemIncl" type="string" required="false" default="false">
<cfargument name="gasQualityIncl" type="string" required="false" default="false">
<cfargument name="harshConditionIncl" type="string" required="false" default="false">
<cfargument name="processingIncl" type="string" required="false" default="false">
<cfargument name="recoveryCatIncl" type="string" required="false" default="false">
<cfargument name="operatedIncl" type="string" required="false" default="false">
<cfargument name="OECDCatIncl" type="string" required="false" default="false">
<cfargument name="EquityIncl" type="string" required="false" default="false">
<!--- Selector Arguments --->
<cfargument name="ProductionTypeSelector" type="string" required="false" default="">
<cfargument name="ProductionVolumeSelector" type="string" required="false" default="">
<cfargument name="ProductionUnitSelector" type="string" required="false" default="">
<cfargument name="PriceCaseSelector" type="string" required="false" default="">
<cfargument name="Country1" type="string" required="false" default="">
<cfargument name="Region1" type="string" required="false" default="">
<cfargument name="Basin1" type="string" required="false" default="">
<cfargument name="Field1" type="string" required="false" default="">
<cfargument name="waterCatSelector" type="string" required="false" default="">
<cfargument name="waterDepthLow" type="string" required="false" default="">
<cfargument name="waterDepthHigh" type="string" required="false" default="">
<cfargument name="APICatSelector" type="string" required="false" default="">
<cfargument name="APIGravityLow" type="string" required="false" default="">
<cfargument name="APIGravityHigh" type="string" required="false" default="">
<cfargument name="ProjectCertaintySelector" type="string" required="false" default="">
<cfargument name="StatusSelector" type="string" required="false" default="">
<cfargument name="SourceRockSelector" type="string" required="false" default="">
<cfargument name="ProductionSystemSelector" type="string" required="false" default="">
<cfargument name="GasQualitySelector" type="string" required="false" default="">
<cfargument name="HarshConditionSelector" type="string" required="false" default="">
<cfargument name="ProcessingSelector" type="string" required="false" default="">
<cfargument name="RecoveryCategorySelector" type="string" required="false" default="">
<cfargument name="OperatedCategorySelector" type="string" required="false" default="">
<cfargument name="OECDCategorySelector" type="string" required="false" default="">
<cfargument name="minYear" type="string" required="false" default="2009">
<cfargument name="maxYear" type="string" required="false" default="2030">
<cfargument name="discountRate" type="string" required="false" default="">
<!--- Company Arguments --->
<cfargument name="Company1" type="string" required="false" default="">
<!---Define Variables--->
<cfset var Production="">
<!---Do Search--->
<cfquery name="Production" datasource="myDB" result="result">
SELECT PriceCase
<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, CompanyID</cfif>
<cfif ARGUMENTS.countryIncl IS "True">, Country</cfif>
<cfif ARGUMENTS.regionIncl IS "True">, Region</cfif>
<cfif ARGUMENTS.basinIncl IS "True">, Basin</cfif>
<cfif ARGUMENTS.fieldIncl IS "True"> , Field, FieldID</cfif>
<cfif ARGUMENTS.waterCatIncl IS "True">, WaterCat, WaterCatSortOrder</cfif>
<cfif ARGUMENTS.waterDepthIncl IS "True">, FieldWaterDepthFt</cfif>
<cfif ARGUMENTS.APICatIncl IS "True">, APICat, APICatSortOrder</cfif>
<cfif ARGUMENTS.APIGravityIncl IS "True">, APIGravity</cfif>
<cfif ARGUMENTS.maturityIncl IS "True">, ProjectCertainty, ProjectCertaintySortOrder</cfif>
<cfif ARGUMENTS.statusIncl IS "True">, CurrentStatus</cfif>
<cfif ARGUMENTS.sourceRockIncl IS "True">, SourceRock</cfif>
<cfif ARGUMENTS.productionSystemIncl IS "True">, ProductionSystem</cfif>
<cfif ARGUMENTS.gasQualityIncl IS "True">, GasQuality</cfif>
<cfif ARGUMENTS.harshConditionIncl IS "True">, HarshCondition</cfif>
<cfif ARGUMENTS.processingIncl IS "True">, Processing</cfif>
<cfif ARGUMENTS.recoveryCatIncl IS "True">, RecoveryCategory</cfif>
<cfif ARGUMENTS.operatedIncl IS "True">, Operated</cfif>
<cfif ARGUMENTS.OECDCatIncl IS "True">, OECDCat</cfif>
, Coalesce(Round(([1995]),4),0) AS y1995
, Coalesce(Round(([1996]),4),0) AS y1996
, Coalesce(Round(([1997]),4),0) AS y1997
, Coalesce(Round(([1998]),4),0) AS y1998
, Coalesce(Round(([1999]),4),0) AS y1999
, Coalesce(Round(([2000]),4),0) AS y2000
, Coalesce(Round(([2001]),4),0) AS y2001
, Coalesce(Round(([2002]),4),0) AS y2002
, Coalesce(Round(([2003]),4),0) AS y2003
, Coalesce(Round(([2004]),4),0) AS y2004
, Coalesce(Round(([2005]),4),0) AS y2005
, Coalesce(Round(([2006]),4),0) AS y2006
, Coalesce(Round(([2007]),4),0) AS y2007
, Coalesce(Round(([2008]),4),0) AS y2008
, Coalesce(Round(([2009]),4),0) AS y2009
, Coalesce(Round(([2010]),4),0) AS y2010
, Coalesce(Round(([2011]),4),0) AS y2011
, Coalesce(Round(([2012]),4),0) AS y2012
, Coalesce(Round(([2013]),4),0) AS y2013
, Coalesce(Round(([2014]),4),0) AS y2014
, Coalesce(Round(([2015]),4),0) AS y2015
, Coalesce(Round(([2016]),4),0) AS y2016
, Coalesce(Round(([2017]),4),0) AS y2017
, Coalesce(Round(([2018]),4),0) AS y2018
, Coalesce(Round(([2019]),4),0) AS y2019
, Coalesce(Round(([2020]),4),0) AS y2020
, Coalesce(Round(([2021]),4),0) AS y2021
, Coalesce(Round(([2022]),4),0) AS y2022
, Coalesce(Round(([2023]),4),0) AS y2023
, Coalesce(Round(([2024]),4),0) AS y2024
, Coalesce(Round(([2025]),4),0) AS y2025
, Coalesce(Round(([2026]),4),0) AS y2026
, Coalesce(Round(([2027]),4),0) AS y2027
, Coalesce(Round(([2028]),4),0) AS y2028
, Coalesce(Round(([2029]),4),0) AS y2029
, Coalesce(Round(([2030]),4),0) AS y2030
FROM
(SELECT FieldModelResult.PriceCase
, FieldModelResult.MYear
<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, AdjustedWI.Company, AdjustedWI.CompanyID</cfif>
<cfif ARGUMENTS.countryIncl IS "True">, Country.Country</cfif>
<cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
<cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
<cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
<cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
<cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
<cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
<cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
<cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
<cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status AS CurrentStatus</cfif>
<cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
<cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
<cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
<cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
<cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
<cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
<cfif ARGUMENTS.operatedIncl IS "True">, CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END AS Operated</cfif>
<cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>
, <cfif ARGUMENTS.ProductionTypeSelector IS "Net Boe">ROUND(COALESCE(SUM(FieldModelResult.NetBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif>* AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Gas">ROUND(COALESCE(SUM(FieldModelResult.NetGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Net Oil">ROUND(COALESCE(SUM(FieldModelResult.NetOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Boe">ROUND(COALESCE(SUM(FieldModelResult.GrossBoeOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Gas">ROUND(COALESCE(SUM(FieldModelResult.GrossGasOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 35.31 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> ProductionData
<cfelseif ARGUMENTS.ProductionTypeSelector IS "Gross Oil">ROUND(COALESCE(SUM(FieldModelResult.GrossOilOutput<cfif ARGUMENTS.ProductionVolumeSelector IS 2> / 6.29 </cfif> * AdjustedWI.AdjustedWI<cfif ARGUMENTS.ProductionUnitSelector IS 2> / 1000),0),4)<cfelse>),0),2)</cfif> AS ProductionData
</cfif>
FROM Field
INNER JOIN FieldModelResult ON Field.FieldID = FieldModelResult.FieldID
INNER JOIN AdjustedWI ON FieldModelResult.FieldID = AdjustedWI.FieldID AND FieldModelResult.MYear = AdjustedWI.MYear
INNER JOIN Country ON Field.CountryID = Country.CountryID
INNER JOIN FieldDetail ON Field.FieldID = FieldDetail.FieldID
WHERE
0=0
<cfif isDefined('Form.Company1')>AND (AdjustedWI.Company IN (<cfqueryparam value="#FORM.Company1#" cfsqltype="cf_sql_varchar" list="yes">))</cfif>
<cfif isDefined('Form.Country1')>AND Country.Country IN (<cfqueryparam value="#FORM.Country1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif isDefined('Form.Region1')>AND FieldDetail.Region IN (<cfqueryparam value="#FORM.Region1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif isDefined('Form.Basin1')>AND FieldDetail.Basin IN (<cfqueryparam value="#FORM.Basin1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif isDefined('Form.Field1')>AND Field.Field IN (<cfqueryparam value="#FORM.Field1#" cfsqltype="cf_sql_varchar" list="yes">)</cfif>
<cfif NOT isDefined('FORM.EquityIncl')>AND AdjustedWI.EquitySource = 1</cfif>
<cfif isDefined('FORM.StatusSelector')>AND FieldModelResult.Status IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.StatusSelector#" list="yes">)</cfif>
AND (FieldModelResult.PriceCase = <cfqueryparam value="#ARGUMENTS.PriceCaseSelector#" cfsqltype="cf_sql_varchar">)
<cfif isDefined('FORM.waterCatSelector')>AND FieldDetail.WaterCatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.waterCatSelector#" list="yes">)</cfif>
<cfif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS NOT ""> AND (FieldDetail.FieldWaterDepthFt BETWEEN <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.waterDepthLow IS NOT "" AND ARGUMENTS.waterDepthHigh IS ""> AND (FieldDetail.FieldWaterDepthFT >= <cfqueryparam value="#ARGUMENTS.waterDepthLow#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.waterDepthLow IS "" AND ARGUMENTS.waterDepthHigh IS NOT ""> AND (FieldDetail.FieldWaterDepthFt <= <cfqueryparam value="#ARGUMENTS.waterDepthHigh#" cfsqltype="cf_sql_integer">)
</cfif>
<cfif isDefined('FORM.APICatSelector')>AND FieldDetail.APICatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.APICatSelector#" list="yes">)</cfif>
<cfif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS NOT ""> AND (FieldDetail.APIGravity BETWEEN <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.APIGravityLow IS NOT "" AND ARGUMENTS.APIGravityHigh IS ""> AND (FieldDetail.APIGravity >= <cfqueryparam value="#ARGUMENTS.APIGravityLow#" cfsqltype="cf_sql_integer">)
<cfelseif ARGUMENTS.APIGravityLow IS "" AND ARGUMENTS.APIGravityHigh IS NOT ""> AND (FieldDetail.APIGravity <= <cfqueryparam value="#ARGUMENTS.APIGravityHigh#" cfsqltype="cf_sql_integer">)
</cfif>
<cfif isDefined('FORM.ProjectCertaintySelector')>AND FieldDetail.ProjectCertaintyID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProjectCertaintySelector#" list="yes">)</cfif>
<cfif isDefined('FORM.SourceRockSelector')>AND FieldDetail.SourceRockID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.SourceRockSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.ProductionSystemSelector')>AND FieldDetail.ProductionSystemID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProductionSystemSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.GasQualitySelector')>AND FieldDetail.GasQualityID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.GasQualitySelector#" list="yes">)</cfif>
<cfif isDefined('FORM.HarshConditionSelector')>AND FieldDetail.HarshConditionID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.HarshConditionSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.ProcessingSelector')>AND FieldDetail.ProcessingID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ProcessingSelector#" list="yes">)</cfif>
<cfif isDefined('FORM.RecoveryCategorySelector')>AND FieldDetail.RecoveryCategoryID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.RecoveryCategorySelector#" list="yes">)</cfif>
<cfif isDefined('FORM.OperatedCategorySelector')>
<cfif listLen(FORM.OperatedCategorySelector) EQ 3>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) LIKE '%')
</cfif>
<cfif listLen(FORM.OperatedCategorySelector) EQ 2>
<cfif listContainsNoCase(FORM.OperatedCategorySelector,1) AND listContainsNoCase(FORM.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,1) AND listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Unknown')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,2) AND listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Non-Operated' OR (CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>
<cfif listLen(FORM.OperatedCategorySelector) EQ 1>
<cfif listContainsNoCase(FORM.OperatedCategorySelector,1)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,2)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Non-Operated')
<cfelseif listContainsNoCase(FORM.OperatedCategorySelector,3)>AND ((CASE WHEN FieldDetail.Operator = AdjustedWI.Company THEN 'Operated'
WHEN FieldDetail.Operator != AdjustedWI.Company THEN 'Non-Operated'
ELSE 'Unknown' END) = 'Unknown')
</cfif>
</cfif>
</cfif>
<cfif isDefined('FORM.OECDCategorySelector')>AND FieldDetail.OECDCatID IN (<cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.OECDCategorySelector#" list="yes">)</cfif>
AND (FieldModelResult.MYear BETWEEN <cfqueryparam value="#FORM.minYear#" cfsqltype="cf_sql_integer"> AND <cfqueryparam value="#FORM.maxYear#" cfsqltype="cf_sql_integer">)
GROUP BY FieldModelResult.PriceCase
, FieldModelResult.MYear
<cfif ARGUMENTS.Company1 IS NOT "" OR ARGUMENTS.companyIncl IS "True">, Company, AdjustedWI.CompanyID</cfif>
<cfif ARGUMENTS.countryIncl IS NOT "">, Country.Country</cfif>
<cfif ARGUMENTS.regionIncl IS "True">, FieldDetail.Region</cfif>
<cfif ARGUMENTS.basinIncl IS "True">, FieldDetail.Basin</cfif>
<cfif ARGUMENTS.fieldIncl IS "True">, Field.Field , Field.FieldID</cfif>
<cfif ARGUMENTS.waterCatIncl IS "True">, FieldDetail.WaterCat, FieldDetail.WaterCatSortOrder</cfif>
<cfif ARGUMENTS.waterDepthIncl IS "True">, FieldDetail.FieldWaterDepthFt</cfif>
<cfif ARGUMENTS.APICatIncl IS "True">, FieldDetail.APICat, FieldDetail.APICatSortOrder</cfif>
<cfif ARGUMENTS.APIGravityIncl IS "True">, FieldDetail.APIGravity</cfif>
<cfif ARGUMENTS.maturityIncl IS "True">, FieldDetail.ProjectCertainty, FieldDetail.ProjectCertaintySortOrder</cfif>
<cfif ARGUMENTS.statusIncl IS "True">, FieldModelResult.Status</cfif>
<cfif ARGUMENTS.sourceRockIncl IS "True">, FieldDetail.SourceRock</cfif>
<cfif ARGUMENTS.productionSystemIncl IS "True">, FieldDetail.ProductionSystem</cfif>
<cfif ARGUMENTS.gasQualityIncl IS "True">, FieldDetail.GasQuality</cfif>
<cfif ARGUMENTS.harshConditionIncl IS "True">, FieldDetail.HarshCondition</cfif>
<cfif ARGUMENTS.processingIncl IS "True">, FieldDetail.Processing</cfif>
<cfif ARGUMENTS.recoveryCatIncl IS "True">, FieldDetail.RecoveryCategory</cfif>
<cfif ARGUMENTS.operatedIncl IS "True">, FieldDetail.Operator</cfif>
<cfif ARGUMENTS.OECDCatIncl IS "True">, FieldDetail.OECDCat</cfif>) q1
PIVOT
(SUM(ProductionData) FOR q1.MYear IN
([1995],[1996],[1997],[1998],[1999],[2000],[2001],[2002],[2003],[2004],[2005],[2006],[2007],[2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020],[2021],[2022],[2023],[2024],[2025],[2026],[2027],[2028],[2029],[2030])) AS pvt
<cfif gridsortcolumn neq ''>
order by #gridsortcolumn# #gridsortdirection#
</cfif>
</cfquery>
<cfreturn queryconvertforgrid(Production,page,pagesize)/>
</cffunction>
---CFM---
<div style="width:1000px; clear:both;" align="center">
<cfoutput>
<cfform name="tableform">
<cfgrid format="html" name="grid_Tables" pagesize="25" selectmode="row"
bind="cfc:cfc.Production.getProduction2({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
<cfif isDefined('Form.Company1') OR isDefined('FORM.companyIncl')><cfgridcolumn name="Company" header="Company"></cfif>
<cfif isDefined('FORM.countryIncl')><cfgridcolumn name="Country" header="Country"></cfif>
<cfif isDefined('FORM.regionIncl')><cfgridcolumn name="Region" header="Region"></cfif>
<cfif isDefined('FORM.basinIncl')><cfgridcolumn name="Basin" header="Basin"></cfif>
<cfif isDefined('FORM.OECDCatIncl')><cfgridcolumn name="OECDCat" header="OECD Category"></cfif>
<cfif isDefined('FORM.fieldIncl')><cfgridcolumn name="Field" header="Field"></cfif>
<cfif isDefined('FORM.operatedIncl')><cfgridcolumn name="Operated" header="Operated Category"></cfif>
<cfif isDefined('FORM.waterCatIncl')><cfgridcolumn name="WaterCat" header="Water Depth Category"></cfif>
<cfif isDefined('FORM.waterDepthIncl')><cfgridcolumn name="FieldWaterDepthFt" header="Water Depth (Ft)"></cfif>
<cfif isDefined('FORM.APICatIncl')><cfgridcolumn name="APICat" header="API Category"></cfif>
<cfif isDefined('FORM.APIGravityIncl')><cfgridcolumn name="APIGravity" header="API Gravity"></cfif>
<cfif isDefined('FORM.maturityIncl')><cfgridcolumn name="ProjectCertainty" header="Project Maturity"></cfif>
<cfif isDefined('FORM.statusIncl')><cfgridcolumn name="CurrentStatus" header="Status"></cfif>
<cfif isDefined('FORM.sourceRockIncl')><cfgridcolumn name="SourceRock" header="Source Rock"></cfif>
<cfif isDefined('FORM.productionSystemIncl')><cfgridcolumn name="ProductionSystem" header="Production System"></cfif>
<cfif isDefined('FORM.gasQualityIncl')><cfgridcolumn name="GasQuality" header="Gas Quality"></cfif>
<cfif isDefined('FORM.harshConditionIncl')><cfgridcolumn name="HarshCondition" header="Harsh Conditions"></cfif>
<cfif isDefined('FORM.processingIncl')><cfgridcolumn name="Processing" header="Processing"></cfif>
<cfif isDefined('FORM.recoveryCatIncl')><cfgridcolumn name="RecoveryCategory" header="Recovery Category"></cfif>
<cfif 1995 GTE #FORM.minYear# AND 1995 LTE #FORM.maxYear#><cfgridcolumn name="y1995" header="1995"></cfif>
<cfif 1996 GTE #FORM.minYear# AND 1996 LTE #FORM.maxYear#><cfgridcolumn name="y1996" header="1996"></cfif>
<cfif 1997 GTE #FORM.minYear# AND 1997 LTE #FORM.maxYear#><cfgridcolumn name="y1997" header="1997"></cfif>
<cfif 1998 GTE #FORM.minYear# AND 1998 LTE #FORM.maxYear#><cfgridcolumn name="y1998" header="1998"></cfif>
<cfif 1999 GTE #FORM.minYear# AND 1999 LTE #FORM.maxYear#><cfgridcolumn name="y1999" header="1999"></cfif>
<cfif 2000 GTE #FORM.minYear# AND 2000 LTE #FORM.maxYear#><cfgridcolumn name="y2000" header="2000"></cfif>
<cfif 2001 GTE #FORM.minYear# AND 2001 LTE #FORM.maxYear#><cfgridcolumn name="y2001" header="2001"></cfif>
<cfif 2002 GTE #FORM.minYear# AND 2002 LTE #FORM.maxYear#><cfgridcolumn name="y2002" header="2002"></cfif>
<cfif 2003 GTE #FORM.minYear# AND 2003 LTE #FORM.maxYear#><cfgridcolumn name="y2003" header="2003"></cfif>
<cfif 2004 GTE #FORM.minYear# AND 2004 LTE #FORM.maxYear#><cfgridcolumn name="y2004" header="2004"></cfif>
<cfif 2005 GTE #FORM.minYear# AND 2005 LTE #FORM.maxYear#><cfgridcolumn name="y2005" header="2005"></cfif>
<cfif 2006 GTE #FORM.minYear# AND 2006 LTE #FORM.maxYear#><cfgridcolumn name="y2006" header="2006"></cfif>
<cfif 2007 GTE #FORM.minYear# AND 2007 LTE #FORM.maxYear#><cfgridcolumn name="y2007" header="2007"></cfif>
<cfif 2008 GTE #FORM.minYear# AND 2008 LTE #FORM.maxYear#><cfgridcolumn name="y2008" header="2008"></cfif>
<cfif 2009 GTE #FORM.minYear# AND 2009 LTE #FORM.maxYear#><cfgridcolumn name="y2009" header="2009"></cfif>
<cfif 2010 GTE #FORM.minYear# AND 2010 LTE #FORM.maxYear#><cfgridcolumn name="y2010" header="2010"></cfif>
<cfif 2011 GTE #FORM.minYear# AND 2011 LTE #FORM.maxYear#><cfgridcolumn name="y2011" header="2011"></cfif>
<cfif 2012 GTE #FORM.minYear# AND 2012 LTE #FORM.maxYear#><cfgridcolumn name="y2012" header="2012"></cfif>
<cfif 2013 GTE #FORM.minYear# AND 2013 LTE #FORM.maxYear#><cfgridcolumn name="y2013" header="2013"></cfif>
<cfif 2014 GTE #FORM.minYear# AND 2014 LTE #FORM.maxYear#><cfgridcolumn name="y2014" header="2014"></cfif>
<cfif 2015 GTE #FORM.minYear# AND 2015 LTE #FORM.maxYear#><cfgridcolumn name="y2015" header="2015"></cfif>
<cfif 2016 GTE #FORM.minYear# AND 2016 LTE #FORM.maxYear#><cfgridcolumn name="y2016" header="2016"></cfif>
<cfif 2017 GTE #FORM.minYear# AND 2017 LTE #FORM.maxYear#><cfgridcolumn name="y2017" header="2017"></cfif>
<cfif 2018 GTE #FORM.minYear# AND 2018 LTE #FORM.maxYear#><cfgridcolumn name="y2018" header="2018"></cfif>
<cfif 2019 GTE #FORM.minYear# AND 2019 LTE #FORM.maxYear#><cfgridcolumn name="y2019" header="2019"></cfif>
<cfif 2020 GTE #FORM.minYear# AND 2020 LTE #FORM.maxYear#><cfgridcolumn name="y2020" header="2020"></cfif>
<cfif 2021 GTE #FORM.minYear# AND 2021 LTE #FORM.maxYear#><cfgridcolumn name="y2021" header="2021"></cfif>
<cfif 2022 GTE #FORM.minYear# AND 2022 LTE #FORM.maxYear#><cfgridcolumn name="y2022" header="2022"></cfif>
<cfif 2023 GTE #FORM.minYear# AND 2023 LTE #FORM.maxYear#><cfgridcolumn name="y2023" header="2023"></cfif>
<cfif 2024 GTE #FORM.minYear# AND 2024 LTE #FORM.maxYear#><cfgridcolumn name="y2024" header="2024"></cfif>
<cfif 2025 GTE #FORM.minYear# AND 2025 LTE #FORM.maxYear#><cfgridcolumn name="y2025" header="2025"></cfif>
<cfif 2026 GTE #FORM.minYear# AND 2026 LTE #FORM.maxYear#><cfgridcolumn name="y2026" header="2026"></cfif>
<cfif 2027 GTE #FORM.minYear# AND 2027 LTE #FORM.maxYear#><cfgridcolumn name="y2027" header="2027"></cfif>
<cfif 2028 GTE #FORM.minYear# AND 2028 LTE #FORM.maxYear#><cfgridcolumn name="y2028" header="2028"></cfif>
<cfif 2029 GTE #FORM.minYear# AND 2029 LTE #FORM.maxYear#><cfgridcolumn name="y2029" header="2029"></cfif>
<cfif 2030 GTE #FORM.minYear# AND 2030 LTE #FORM.maxYear#><cfgridcolumn name="y2030" header="2030"></cfif>
</cfgrid>
</cfform>
</cfoutput>
</div>
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
by: azadisaryevPosted on 2009-10-18 at 23:58:48ID: 25603017
do not put your additional arguments in curvy braces. just pass then as is, e.g:
etProducti on2({cfgri dpage},{cf gridpagesi ze},{cfgri dsortcolum n},{cfgrid sortdirect ion}, companyIncl)"
bind="cfc:cfc.Production.g
iirc, you need to use curvy braces only if you are passing a reference to another form field and/or a built-in parameter like for example cfgridpage.
one thing to keep in mind: you can't pass a comma-delimited list as argument. you must change list delimiters to something else (i.e. | a pipe character) or the binding will fail. use listchangedelims() cf function if you need to change listdelimiters.
Azadi