Yes, I already did the same steps. but still facing the same issue.  

No, "s.derivedinventorystatus" is also not working.

I have written a query for that I have also define the index  and it is executing correctly but not getting results.my thought is, property which I am filtering that is set by in aem commerce a dropdown that why it is not able to match but if am filtering a property which set simple text then I am g...

 Thanks Rohit !! I have create the index and Exception has been resolved now but some how not getting any result. But if I am removing this query parameter (derivedInventoryStatus = 'BackOrder' ) from the query then I am getting complete result but that result having with Property value like this ("...

I have a one servlet call and using that I am executing one query but this query is giving me an exception and I found to in that query I am fetching the devices which having derivedInventoryStatus = 'BackOrder'. And derivedInventoryStatus property is set/coming from aem catalog drop downfield. Quer...

Hi @Vijayalakshmi_S ,If I am understand you correctly you are looking below one :  SELECT [promoid] FROM [nt:base] AS s WHERE (ISDESCENDANTNODE(s, [/etc/commerce/products/sprint/en/offers])) and (identifier is not null) This gernated from my below code: if (generateQuerySearchCriteria.equalsIgnoreCa...

@Vijayalakshmi_S  I have gernated the query and I have created the same node structure in oak:index folder.  Query: Filter(query=SELECT [promoid] FROM [nt:base] AS s WHERE (ISDESCENDANTNODE(s, [/etc/commerce/products/sprint/en/offers])) and (identifier is not null) , path=/etc/commerce/products/spri...

Hi @Kishore_Kumar_, I have gernated the query and I have created the same node structure in oak:index folder.  Query: Filter(query=SELECT [promoid] FROM [nt:base] AS s WHERE (ISDESCENDANTNODE(s, [/etc/commerce/products/sprint/en/offers])) and (identifier is not null) , path=/etc/commerce/products/sp...

Sure