Query export not working to build query string

finance.eikon2

I am trying to export a search query in Eikon, and the fields I choose are:

However, the code provided by the Export Query does not contain the fields I added.

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 all the variables I choose?

Thank you!

Find more posts tagged with

query-string

#technology

Accepted answers

All comments

raksina.samasiri

Hi @finance.eikon2 ,

Regarding the first question, we need to check with the product team about the application behavior, I'll raise a ticket to helpdesk on your behalf and they will contact you to provide more information.

The second question, correct field can be found in CodeCreator application inside Workspace.

For example, the code below can be used

import refinitiv.data as rd
rd.open_session()

# Exported query, get only OA Perm ID for the next step
df = rd.discovery.search(
    view = rd.discovery.Views.ORGANISATIONS,
    top = 1000,
    filter = "( SearchAllCategoryv2 eq 'Companies/Issuers')",
    select = "OAPermID"
)

# Make a list of OA Perm ID from the output dataframe
rics_list = df['OAPermID'].dropna().tolist()

# With the list created, retrieve the data
df2 = rd.get_data(
    universe=rics_list,
    fields=['TR.CommonName', 'TR.SICIndustry', 'TR.TRBCIndustryCode', 'TR.NAICSSectorCode', 'TR.NAICSIndustryGroupCode']
)
display(df2)

finance.eikon2

Thank you very much for your help!

However, I am looking for all the company's information. Could you help me get the data without reaching the 10,000 limit?

raksina.samasiri

Hi @finance.eikon2 ,

I forgot to mention that it is recommended to apply the filters to scope the result to be the data you're interested in, this will improve performance of the coding as well. Hence, in case the result is more than 10,000 rows, which is the limit of result row in the search function, you're recommended to add more filter to specific the result

However, the example of retrieing data with more than 10000 results can be found in section 2) Using the Search function to retrieve the data in article Searching for KungFu Bonds (Chinese-issued U.S. dollars bonds) with the Data Library - Search function

In this case, as number of the result is exceeding 10,000 records, which is the maximum number of top parameter. We're going to use Content Layer code instead, so we can find the number of result of each label in selected filter with navigators parameter, then retrieve the data in chunk divided by label(s) that their result number aren't exceed the maximum number of top parameter.

finance.eikon2

Hi @raksina.samasiri Thank you so much again! let me think about it.

raksina.samasiri

For reference, ticket number 14090532 was raised on your behalf to ask about the first question and helpdesk will contact you soon regarding this

raksina.samasiri

You're welcome

EXPLORE OUR SITES