Skip to Content
0
Former Member
Sep 19, 2011 at 06:39 PM

Problem with Selection Criterea Syntax

25 Views

For some reason this part of my select statement is not showing in the SQL query. Any ideas? Only the BI_CUR_HISTORY_SW="Y" value is making it to the criterea. BI_USAGE is not there

Selection formula:

If {?p_Annual_Budget_Billing_Accounts} = "Yes"  Then

//Annual Account
    ({BI_AR.BI_CONS_CLASS_CD} = "A")

Else If {?p_Annual_Budget_Billing_Accounts} = "No" then

//Exclude All Annual Accounts (But include B, or Balanced Billing Accounts).
    ({BI_AR.BI_CONS_CLASS_CD} <> "A";

//Usage History 
    {BI_HIST_USAGE.BI_USAGE} = {?p_kwhUsage};
    {BI_HISTORY.BI_CUR_HIST_SW} = "Y")

//USE ONLY TO VERIFY GROSS NUMBER OF METERS / ACCOUNTS
Else If {?p_Annual_Budget_Billing_Accounts} = "Both" then

//Active Meters
({BI_MTR_INV.BI_MTR_STAT_CD} = 1)

SQL Where Clause:

 WHERE  "BI_TYPE_SERVICE"."BI_SRV_STAT_CD"=1 AND ("BI_HISTORY"."BI_REV_YRMO">=201107 AND "BI_HISTORY"."BI_REV_YRMO"<=201108) AND "BI_HISTORY"."BI_CUR_HIST_SW"='Y'

 ORDER BY "BI_AR"."BI_CONS_CLASS_CD" DESC, "BI_RDG"."BI_ACCT", "BI_MTR_INV"."BI_MTR_NBR", "BI_HIST_USAGE"."BI_REV_YRMO"