I am trying to build a simple search query using the Python API:
rd.discovery.search( view = rd.discovery.Views.EQUITY_QUOTES, query = "garuda indonesia", top = 100, filter = "(AssetState ne 'DC' and SearchAllCategoryv2 eq 'Equities')", select = "DTSubjectName,ExchangeName,Ticker ,Gics,SearchAllCategory" )
This works fine, except for "Ticker", that does not provide any data back...
I have tried to follow the instructions of using Workspace to add an extra column. Below you can see my screen as I have done this and added some additional columns too.
I am fairly sure this is a bug, but when I select the last row and "Export Query", I do not get any of the additional fields. They are available and work, but they are not provided.
rd.discovery.search( view = rd.discovery.Views.GOV_CORP_INSTRUMENTS, query = "Garuda Indonesia (Persero) Tbk PT", top = 10, filter = "((DbType eq 'GOVT' or DbType eq 'CORP' or DbType eq 'AGNC' or DbType eq 'OMUN' or DbType eq 'OTHR') and IsActive eq true and (FIViewTicker eq 'GIAA'))", select = "RIC,EJVAssetID,DTSubjectName,BusinessEntity,PI,SearchAllCategoryv3,SearchAllCategoryv2,SearchAllCategory,DBSTicker,CouponRate,MaturityDate,IssueDate,ISIN,RCSCurrencyLeaf,RCSCountryLeaf,DbTypeDescription,InstrumentTypeDescription,RCSCouponTypeGenealogy,FaceIssuedUSD,RCSBondGradeLeaf,FIViewTicker", order_by = "InstrumentTypeDescription" )
So my questions are:
1. Why are the user-added fields not in the Export Query screen on Workspace?
2. Could you tell me the correct field for "Ticker", as I cannot find that.
Thank you!