| Report Filters and Filtering | |
Filters
Using the user-defined user parameters in WellSpring, filters can be used to report only assets which meet a certain criteria. For example, if you filtered on a user parameter such as "Operated", when the filter is applied, only assets that are operated would be included in any reported results.
Note: Be careful that your facilities are not included in your filters, as you will double count production. See My filtered reports seem to have higher numbers than they should in the FAQ.
If the "Consolidate Filter" option was selected, then a single consolidated report would be generated.
Building a Filter
To edit or add a filter, click on the "Filter" link on the top right reporting box. The filter editor will appear:
An existing filter can be edited (if you are the owner), or copied if you want to modify it.
Filters are defined using a condition in the function editor. If the asset satisfies the filter, then it will appear on the report.
Refer to User Defined Functions for more information on the type of functions that can be created.
The following are typical filter defintions
Well =@assettype('well')
Oil Well =@assettype('oilwell')
Gas Well =@assettype('gaswell')
Facility =@assettype('facility')
User Data Can also be used. The following filter function will filter on all assets that have Lease set to 'den'.
=@userdatalike('Lease','den')
Date based filters:
Asset Start Date > 2012
=@AssetStartDate() >= @Date(2012,1,1)
Asset On Production Date > June 2011
=@FirstProductionDate( ) >= @Date(2011,6,1)
Drill Start Date in 2012
Brackets around each term of AND statement are required
= (@DrillStartDate( ) >= @Date(2012,1,1)) & (@DrillStartDate( ) <= @Date(2012,12,31))
User Data date ‘Start Date’, after June 2011, and before January of 2012.
=@Scalar('Start Date') >= @Date(2011,6,1) & @Scalar('Start Date') < @Date(2012,1,1)
See also
Asset Filtering