Hi @grigorios.mamalis,

I would highly recommend you use the:

response = rdp.Search.search()

syntax when building out your search expressions. The syntax you are using is a convenient, simple syntax that returns a dataframe. The libraries are layered to provide more granular details - the syntax above is the API call at the content layer of the library.

When I ran your first example 'baseString1', it failed because the startswith only accepts properties supporting exact match:

What you can do instead is perhaps use the organization ID (Perm ID) for Credit Suisse to return the list of bonds. Below is an updated filter that provides this. I also included a couple of other conditions around the status, i.e whether the bond is active and whether it has matured.

filterStr = "DerivedCategory eq 'BOND' and ParentOAPermID eq '4295890672' and \
             IsActive eq true and AssetStatus ne 'MAT' and \
             OriginalIssueCurrency eq 'USD' and RIC ne null and ISIN ne null"

Apply the above filter, I received a total of 5456 rows.

Hi @grigorios.mamalis

I believe that your filter does not work as expected.

baseString1 = "DerivedCategory eq 'BOND' and startswith( IssuerLegalName, 'CREDIT SUISSE' ) and OriginalIssueCurrency eq 'USD' and RIC ne null and ISIN ne null"
baseString11 = "DerivedCategory eq 'BOND' and OriginalIssueCurrency eq 'USD' and RIC ne null and ISIN ne null"

baseString2 = "DerivedCategory eq 'BOND' and startswith( CommonName, 'CREDIT SUISSE' ) and OriginalIssueCurrency eq 'USD' and RIC ne null and ISIN ne null"
baseString22 = "DerivedCategory eq 'BOND' and OriginalIssueCurrency eq 'USD' and RIC ne null and ISIN ne null"

srchfields = "RIC,ISIN, FullName, CommonName,CompanyName, SeniorityType,NativeIdentifier,DerivedCategory,OriginalIssueCurrency,ParentIndustrySector, CouponCurrency, CouponTypeDescription"

GroupSize = 50

data1 = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=baseString1, top=GroupSize, select=srchfields)
data11 = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=baseString11, top=GroupSize, select=srchfields)

data2 = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=baseString2, top=GroupSize, select=srchfields)
data22 = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=baseString22, top=GroupSize, select=srchfields)

I added data11 and data22 which remove "and startswith( IssuerLegalName, 'CREDIT SUISSE' )" from your filter and it returned the result.

You can refer to this sample, https://github.com/Refinitiv-API-Samples/Example.RDPLibrary.Python.Search

Please see rdp.get_search_metadata(views)

You can use any fields which "Searchable" is true.

Hi @grigorios.mamalis,

If you haven't had a chance, I would take a look at this Search Article. It will provide you with some helpful hints and tricks to figure out how to build out your search criteria.

@chavalit.jintamalit Hi, well the point is that I wanted on purpose to retrieve data for given Bank and I wanted to repeat this procedure for a whole lot of Banks. Can you please reconsider your answer to take into account this?

Also, importantly I need to have a way to specify the names of the Banks in rdp space. I do have a list with names from EIKON GUI, but is there an attribute reflecting a Bank name that is valid across EIKON tools? (from GUI to dataplatform? I was thinking of IssuerLegalName or RIC or PermID but I need something that works for all cases. RIC and PermID do not seem to work in data platform e.g.)

Regarding rdp.get_search_metadata see P.S. section of my original e-mail where I say that this does not work for me in IntelliJ. In the meanwhile I found out that it works on CODEBK but I can only inspect it on that platform. Thanks

@ nick.zincone.1 · Many thanks for the hint regarding the PermID (that works nicely) and for the link with info.

@nick.zincone.1

by the way why does the below does not work? I took the "A:C9" from the

navigators = "RCSCouponTypeGenealogy"

# does not work:
filterStr = " DerivedCategory eq 'BOND'  and IsActive eq true and AssetStatus ne 'MAT'  and endsWith(RCSCouponTypeGenealogy, 'A:C9' ) and  ParentOAPermID  eq  '4295890672'"

srchfields = "RIC,ISIN, FullName, InstrumentTypeDescription, RCSCouponTypeGenealogy"

data_PermID = rdp.search(view=rdp.SearchViews.GovCorpInstruments, filter=filterStr, top=GroupSize, select=srchfields)

Thanks.

Hi @grigorios.mamalis,

The 'endsWith' should be 'endwith' (all lowercase).

Remember the advice above, don't use:

response = rdp.search() 

when building out your search algorithm. Instead use:

response = rdp.Search.search()

With the latter, you can interrogate the details, such as:

# status
response.status
# raw data (allows you to see navigator results
response.data.raw
# dataframe
response.data.df

Once you are happy with the outcome, then certainly use the

response = rdp.search()

Hi @nick.zincone.1 · , my bad. Many thanks for the correction regarding "endswith" as well as for the Search. Took note. All works fine.