If i had a query such as
response=search.Definition( filter = f"RCSUnderlyingProductName eq 'Corn' and ExchangeName eq 'GeoGrain' and DTSubjectName eq 'Ohio'", order_by = "ExpiryDate desc", top = 10000, select = "DTSubjectName, ExchangeName, RIC, RCSAssetCategoryLeaf, AssetState, ExpiryDate, UnderlyingQuoteRIC, FirstNoticeDay", ).get_data() geograin_df = response.data.df
to find GeoGrain RICs - but wanted to narrow it down by the first available date, is there some synatax that could be used to filter at this level.
Additionally in the above expression, I would like to filter the data for those without ExpiryDate (that is that return NaT (not a time)) - but cannot seem to work out what string or phrase to work with.
Apologies as my SQL is quite poor!
Cheers!