Hello, we have this subqyery in our system
...AND {selectionItemAlias:pk} NOT IN
({{ SELECT {selectionItemImpexStatus:OWNER}
FROM {PimImportExportStatus AS selectionItemImpexStatus }
WHERE ({selectionItemImpexStatus:lastSuccessDate} > {selectionItemAlias:modifiedtime})
we would like to exclude some more stuff in the WHERE clause of the above subquery using this constraint:
AND {selectionItemImpexStatus:lastSuccessDate} > {selectionItemImpexStatus:OWNER:product:modifiedtime)}
But how can we reference the attributes directly in the Flex Search? What can be the solution?
Many thanks in advance,
Sven