Choose your data source as XPath. When selecting the entity you should find the object in your data view at the top and select the entity associated to it. It doesn’t necessarily have to be from the database when choosing the XPath Data source.
A retrieve by association retrieves the object from cache if available. XPath translates into SQL commands and is only available on DB level. You can’t filter cached objects by using XPath. They need to be in the database. To achieve your goal, you could select microflow as datasource and do your filtering inside the microflow.
Choose your data source as XPath. When selecting the entity you should find the object in your data view at the top and select the entity associated to it. It doesn’t necessarily have to be from the database when choosing the XPath Data source.