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?
hi @SatheeskannaK. Here is a screengrab. Looks ok?
When compared with your example, my filter is obviously using data linked to orders.
But as I said, I think the filter itself is fine as it works perfectly if I replace the parameter for productName with a hardcoded value. (whilst keeping the orderDate param)
Can you try remove the filter and recreate again? and also i have created a filter and used within query activity using parameter and it works fine. Refer below screenshots.
Profile query with filter:
It's 1 cardinality simple link. The link is defined on the orders custom resource as below (using specific join conditions - custom customerId field on both tables)
There's no problem adding the param on an order table attribute. The filter works fine if just using orderDate for example.
I hope that makes sense.