Expand my Community achievements bar.

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

Avatar

Level 5

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:

davidh2892249_0-1603991491420.png

 

My data model looks like this:

davidh2892249_1-1603991532669.png

 

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

 

10 Replies

Avatar

Community Advisor

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

SatheeskannaK_1-1604326793045.png

 

SatheeskannaK_0-1604326764331.png

 

Thanks, Sathees

 

Thanks, Sathees

Avatar

Level 5

hi @SatheeskannaK. Here is a screengrab. Looks ok?

davidh2892249_0-1604329254934.png

 

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)

 

Avatar

Community Advisor

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.

 

 

SatheeskannaK_0-1604331167723.png

 

 

SatheeskannaK_1-1604331167735.png

 

 

SatheeskannaK_2-1604331167744.png

 

 

 

Profile query with filter:

 

SatheeskannaK_3-1604331167747.png

 

 

SatheeskannaK_4-1604331167751.png

 

Thanks, Sathees

Thanks, Sathees

Avatar

Level 5
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?

Avatar

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

Avatar

Level 5

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)

 

davidh2892249_0-1604419736216.png


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.

Avatar

Administrator

Hi @davidh2892249,

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

Thanks!



Sukrity Wadhwa

Avatar

Level 5
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.

Avatar

Administrator
Sure! I will escalate this further. Thanks!


Sukrity Wadhwa