Query export not working to build query string

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!

Find more posts tagged with

query-string

rdp-api

#technology

Accepted answers

Jirapongse

@JeremyJGreen

You should use TickerSymbol instead of Ticker.

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,TickerSymbol,Gics,SearchAllCategory"
)

The output is:

For a question regarding the Export Query screen on Workspace, please contact the Refinitiv Workspace support team directly via MyRefinitiv to verify this functionality.

All comments

Jirapongse

@JeremyJGreen

You should use TickerSymbol instead of Ticker.

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,TickerSymbol,Gics,SearchAllCategory"
)

The output is:

For a question regarding the Export Query screen on Workspace, please contact the Refinitiv Workspace support team directly via MyRefinitiv to verify this functionality.

JeremyJGreen

Your reply is very much appreciated.

I raised the issue to the helpdesk and it does appear that the export query does not work on custom columns, or indeed some of the standard columns too.

EXPLORE OUR SITES