Salesforce SOSL: match ids to master-detail fields -
ladies , gents, have created junction object (name_callcontactmap_c) describes many:many relationship between custom object (call) , contact. object has 2 master-detail fields, 1 refers contact record , 1 custom call record. hoping call work:
find {a0aa0000007mjkhmag} returning name__callcontactmap__c(name__contact__r.firstname,name__contact__r.lastname)
as stands call returns 0 records , no error. there matching record. needless can find using soql, it's "scanning objects @ once" feature in sosl want use there many different junction objects linking many different kinds of object.
from docs
sosl enables search text, email, , phone fields multiple objects simultaneously
the limitation you're hitting id fields not considered text fields. said approach can work if mirror record id in text field accessible in sosl searches.
Comments
Post a Comment