I am trying to write a query to find all child records of a parent record. I know I can do this with a SOQL on each child object, but I want to do something slicker.
For example, my parent object is called Parent_Object__c, and on every child Object, there is a lookup relationship aptly named
I'd like a SOSL query similar to this:
id myRecordId='a09E000000NSo9K'; list<list<sObject>> myResult = [FIND :myRecordId IN ALL FIELDS RETURNING Child_Object_1__c, Child_Object_2__c, Child_Object_3__c];
But when I try this, I don't get any results. Does SOSL not search lookup relationships?