Is there a way to pull in parent case properties into case exports?
For example, let's say there is a parent case for a mother ("mother") and a child case for a child ("child"). For a "child" case export, I want to be able to include the "name" case property associated with the parent "mother" case.
I realize I could just duplicate the case property onto the child case when it's created, but doing that for many case properties does not seem ideal and then they could get out of sync. For example, if a case property gets updated on the parent, there is no way (without advanced save to case functionality) to have it update the corresponding field on the child case. I realize I could update the case property on the child case anytime a form for the child case is submitted, but still not an ideal solution.
Thank you,
Alejandro