Query export not working to build query string

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)

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.

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