I'm trying to build a filter definition on the profile resource extension.
This is so that users have a much simpler filter to use when building queries that use linked data.
The filter definition is like this:
My data model looks like this:
Essentially I'm trying to build a filter that returns profiles that have an order record where order date is on or after xxx
And the contains an order item record where product name comtains xxxx.
However, when trying to publish - I am getting the following error:The field 'orderItems/products/productName' has not been found for the parameter 'productName_parameter' of filter 'orderedXSkuInLastXMonths' in custom resource 'profile'.However, I tried replacing the productName_parameter with a hardcoded string and the filter publishes OK and returns the expected data.
Can anyone advise why this might be happening?
Were you able to resolve this query with the given solution? Do let us know.