Query export not working to build query string

JeremyJGreen

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!

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

https://community.developers.refinitiv.com/discussion/comment/101055#Comment_101055

Jirapongse

Dec 28, 2022

@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.

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.