Coalesce function doesn't seem to work

Avatar
  • updated
  • Can't answer

select TRADE_DATE,
coalesce((select
TransactTime from Bloomberg.BBGVCONTrades
where tradedate=TradeHub.trade.TRADE_DATE
and CUSIP=TradeHub.trade.cusip
and quantity=TradeHub.trade.PAR_OR_SHARES
and execprice=TradeHub.trade.EXECUTED_PRICE_LOCAL
and tradername In('ADE',
'REN',
'BEN',
'BAR'
) ),
(select
tradedate||timeofTrade from msrb.RTRSDailyTrade
where tradedate||timeofTrade=TradeHub.trade.TRADE_DATE
and CUSIP=TradeHub.trade.cusip
and ParTraded=TradeHub.trade.PAR_OR_SHARES
and DollarPrice=TradeHub.trade.EXECUTED_PRICE_LOCAL),EXECUTION_TIME),
'N/A' as "Type of Order",
EXECUTING_BROKER_HOUSE_CODE,
ISIN,
SEDOL,
TRADE_TYPE_HOUSE_CODE,
PAR_OR_SHARES,
EXECUTING_BROKER_HOUSE_CODE,
NET_AMOUNT_LOCAL
from TradeHub.trade
where ACCOUNT_HOUSE_CODE=123 and OMS_ACCOUNT_CODE='ABCD'

Please help! This is working in other tools

A strange error lots of lines but at end says

Could Not find matching selectable for Trade.PAR_OR_SHARES in view e.Trade.nodeID=3 

Avatar
Andrey Zavyalov, PM

Hello,

This is not a bug in the software. Please review the underlying data and correct your query accordingly.

Avatar
Andrey Zavyalov, PM
  • Answered
Avatar
Andrey Zavyalov, PM
  • Can't answer