diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 7dabca9d..6169d1c5 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4886,6 +4886,7 @@ GROUP BY periodenddate, knowledgedate, fund, invccy, custacctname, port, strat HAVING invccy IN ('EUR', 'USD') AND custacctname IN (SELECT cash_account FROM accounts2 WHERE account_type = 'Cash' AND active) ORDER BY periodenddate desc, fund; +-- no strategy = cash, we're trying to make sure the otc valuations are calculated, not cash CREATE OR REPLACE VIEW citco_otc_valuations AS SELECT cr.period_end_date AS periodenddate, cr.knowledge_date as knowledgedate, |