Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Join us for our next Adobe Campaign Community Q&A Coffee Break, on Thursday, February 9th @ 9.30 am IST & 9 am PT

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


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:



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?






10 Replies


Community Advisor

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





Thanks, Sathees



Level 5

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)



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.













Profile query with filter:







Thanks, Sathees


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?


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).


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)



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.



Hi @davidh2892249,

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



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.