Hi @knstvk i guess this is related question. Is it possible to filter over related entities from secondary datasource? I have table A in primary database. Table B is related to table A and it is in secondary datbase.
I noticed, that filters are automatically created for related entities from main database. But they are not for secondary database related to A table.
Is there any way how to achieve this?
Hi Igor,
If you have A entity in one data store and B entity in another data store, then the generic Filter component for A will allow you to filter by B instances, but not by B attributes. This is because joining between A and B is impossible on the database level. So your filter will allow you to add B parameter as a LookupPicker field, but you won’t be able to drill-down to B attributes.
Regards,
Konstantin