Skip to content
  • Register

    • rdp.SearchViews max rows

    [Deleted User]
    [Deleted User] Newcomer
    in Refinitiv Data Platform

    Consider the following call:

    df = rdp.Search.search(
    view = rdp.SearchViews.MunicipalInstruments, # a view is a logical partitition of the dataset
    top = 10000,
    filter = "Country eq 'US'",
    select = "IssuerName,CUSIP,Country,MaturityDate,IssueDate,IsActive,Ticker")

    If I set top to 10k, I get 10k rows. If I set it to a higher value (or not set it at all), I get zero rows. Can you tell me how to set it so I get all rows here. There seem to be more than 10k rows.

    Tagged:

    Best Answer

    • nick.zincone
      nick.zincone admin
      Answer ✓

      Hi @jonathan.legrand

      There are a few ways you can deal with results that exceed the limit. I would encourage you to read some of the suggestions outlined within the Limits Section within that article. I would also recommend you refer to the Limits Notebook for some more complex examples.

      When working with Search, it is quite common for the results to contain hits that are not relevant. Because Search offers powerful filtering expressions, you can eliminate a lot of the hits server-side, thus narrowing down results. In the event the hit count exceeds the limit, despite filtering as much of the result server-side, you can utilize Navigators to logically group requests so you can intelligently break them into buckets. This is a more complex use case but the Notebook I linked to above demonstrates this capability.

    Answers

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register

    Quick Links

    Categories