Hi there,
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?
Thanks
David
Views
Replies
Total Likes
Views
Replies
Total Likes
Can you check on how it looks under PARAMETERS tab of filter,
Thanks, Sathees
Views
Replies
Total Likes
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)
Views
Replies
Total Likes
Hi @davidh2892249,
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:
Thanks, Sathees
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
hi @SatheeskannaK.
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.
Views
Replies
Total Likes
Hi @davidh2892249,
Were you able to resolve this query with the given solution? Do let us know.
Thanks!
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes