I had a woman dorf in my military, Sarvesh the Potter.
One day, she was injured by skeletal troglodytes and rendered unconscious, while her child (who she carried with her) was killed. (she was part of the backup military and thus was not properly armored)
After she was brought to the infirmary and fixed up, she stood there continuously cancelling her "seek infant" job because the infant wasn't available.
Eventually she started to dehydrate to death, so out of pity, I told her (or rather her squad) to go stand around in the graveyard in hopes that she find some closure. At that point she did finally move away from her bed in the hospital (she hadn't moved a bunch), and at that point I learned that she actually had NOT been fixed up: she still needed sutures, a cast, and a crutch, and had been refusing treatment until she could find her child. So she crawled down the central stairway... and down past the cemetary, toward the caverns.
She won't eat or drink despite that she's dying of both, she won't go to her child even if I point her right at the corpse, and she won't let herself get fixed up in the hospital.
When she's in active military service, she tries to crawl down to the caverns.
When she's in civilian mode, she stands (or rather, lies) perfectly still, pining for her unavailable child.
What do I do
EDIT: after letting her crawl down into the caverns, she realized she was dying of sobriety and went to get a friggin' drink; now she's collecting her equipment, I guess. Still tracking her.
EDIT
2: I'm having trouble diagnosing this dwarf's sanity. After regathering her gear, she got a drink, visited the hospital and was given a crutch and a band-aid, and then she went to man her post like a drunk dorf should. She's apparently a fully functional military dorf again; as a civilian, she's still troubled. She isn't continuously failing to Seek Infant anymore, but she seems to have dulled reflexes (even more so than the other drunks). It took her four days to realize she was hungry, and during that time she didn't exactly jump to her metalworking.