How to get all possible values for `RCSUnderlyingProductGenealogy`

Hi! I'd like to figure out how to get all possible values for `RCSUnderlyingProductGenealogy`, to be able to easily search for commodities.

The filter part of my query is this:

`( (SearchAllCategoryv2 eq 'Commodities' and RCSUnderlyingProductGenealogy eq 'U:8') and (RCSUnderlyingProductGenealogy eq 'U:D\\U:5S' and (not (CallPutOption xeq 'Call') and not (CallPutOption xeq 'Put'))))`

Thank you!

Find more posts tagged with

python

workspace

#technology

refinitiv-data-libraries

Accepted answers

nick.zincone

Hi @mark.szulyovszky

You can use Navigators to pull out all possible values for this property.

For example:

response = search.Definition(
    top = 0,
    filter = "SearchAllCategoryv2 eq 'Commodities' and not(CallPutOption xeq 'Call') and " \
             "not (CallPutOption xeq 'Put')",
    navigators = "RCSUnderlyingProductGenealogy"
).get_data()
response.data.raw["Navigators"]["RCSUnderlyingProductGenealogy"]["Buckets"]

You can find many examples within GitHub.

All comments

nick.zincone

Hi @mark.szulyovszky

You can use Navigators to pull out all possible values for this property.

For example:

response = search.Definition(
    top = 0,
    filter = "SearchAllCategoryv2 eq 'Commodities' and not(CallPutOption xeq 'Call') and " \
             "not (CallPutOption xeq 'Put')",
    navigators = "RCSUnderlyingProductGenealogy"
).get_data()
response.data.raw["Navigators"]["RCSUnderlyingProductGenealogy"]["Buckets"]

You can find many examples within GitHub.

EXPLORE OUR SITES