i was looking through the documentation and saw that under Filtering, it is possible to do joins as shown in the image below.
Is there an additional field for the JOIN clause? If not, how does one create a JOIN clause inside the WHERE text box? Could you provide a sample?
@Andrew Elsey : I think what they meant is to use a subquery (such as IN or EXISTS) in the WHERE clause that simulates a join, since you can't actually modify the query before the WHERE clause.
For example, if there's a dependent entity like EmailAttachments, the filter for it would look like:
EmailId IN ( SELECT Id FROM OSUSR_5np_Email WHERE [To] LIKE '%eduardo.pocas@infosistema.com%' )
This ensures only attachments related to the filtered emails are migrated, preserving referential integrity.
Hi Andrew,
Siya's answer above is correct.
I'd like to add that we are in the process of adding a new feature capability into DMM, related to the filter cascade, which will be available in a future DMM version currently planned for the end of the Summer.
Thank you!