Error when trying to create filter on Profile extension resource (using other custom resources)

[davidh2892249]

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

[davidh2892249]

Any ideas @ramon_bisswanger @DavidKangni

[SatheeskannaK]

Can you check on how it looks under PARAMETERS tab of filter,

Thanks, Sathees

[davidh2892249]

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)

[SatheeskannaK]

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

[davidh2892249]

hi @SatheeskannaK. I have deleted and rebuilt and the error when publishing remains. As I mentioned, the parameter using a column from the orders table (orderDate) is fine. It's when using further linked data. Profile --> (1:N) Orders --> (1:N) Order Items (N:1) <-- Products. Could you try replicating using custom resources with this type of relationship?

[SatheeskannaK]

Can you clarify on cardinality defined from profile -> orders custom resource? Is that 1 cardinality simple link or (0 or 1 simple link).

[davidh2892249]

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.

[Sukrity_Wadhwa]

Hi @davidh2892249,

Were you able to resolve this query with the given solution? Do let us know.

Thanks!

[davidh2892249]

Hi @Sukrity_Wadhwa, sadly not. There seems to be an issue/limitation when trying to paramaterise a field that lives on a schema more than one link beyond the profile table? As i have been mentioning, the filter works fine if you hardcode the attribute (rather than setting as a parameter). If you can have this checked with someone, that would be great.

[Sukrity_Wadhwa]

Sure! I will escalate this further. Thanks!