Skip to Content
0
Jun 07, 2018 at 05:24 PM

Concatenation or references / attributes in flexible search

58 Views

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