Filter condition from store table

[betterapp]

Hello

We have Data Port and filter condition like this:

As I know this filter condition use query table.

Is it possible to use somehow store table for specified field ?

[BlackbitDevs]

There is a checkbox directly above the filter condition field to configure if inheritance shall be used for the database queries (aka if query or store tables should be used):

Currently there is no convenience helper to filter a single field from the store table why other condition parts use the query table. But of course you could do this with a subselect.

If you do not want to use a subselect you could remove the SendToSAP = '1' condition part and add a raw data field with data query selector withoutInheritance:SendToSAP. Then in attribute mapping you could check its value skip this item if value != 1. But of course this will cause quite a high load as the raw data processing then gets started also for objects which would have been filtered out by the SendToSAP = '1' SQL condition right at the beginning.

So I would recommend to disable the Using inheritance checkbox if the whole query shall be based in store table. And if not, I would use a subselect.