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.
Query: SELECT * FROM [nt:unstructured] AS s WHERE (ISDESCENDANTNODE(s, [/etc/commerce/products/myProject/en/devices])) and s.derivedInventoryStatus = 'BackOrder'
Errors:
An error occurred while explaining the query.
The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped.
org.apache.jackrabbit.oak.query.FilterIterators.checkReadLimit(FilterIterators.java:70)
org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor.fetchNext(Cursors.java:341)
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @Abhishekty
I believe this is an indexing issue only. You need to create an index for derivedInventoryStatus property.
Note: you can change [nt:unstructured] in your query to type of node you are searching for eg: [cq:Page],if required.
you can try below link for creating index: https://experienceleague.adobe.com/docs/experience-manager-65/deploying/deploying/queries-and-indexi...
Thanks!
Hi @Abhishekty
I believe this is an indexing issue only. You need to create an index for derivedInventoryStatus property.
Note: you can change [nt:unstructured] in your query to type of node you are searching for eg: [cq:Page],if required.
you can try below link for creating index: https://experienceleague.adobe.com/docs/experience-manager-65/deploying/deploying/queries-and-indexi...
Thanks!
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 ("derivedinventorystatus": "String.class")
Thanks.
Views
Likes
Replies