• support@sinequa.com
  • 0 Points
  • Member since 2017

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0

We have a lead associated with a campaign and we can check it is ok via the user interface.

But when trying to programmatically retrieve this relationship via SOQL e.g.

SELECT Campaign__c, Campaign__r.Name, Campaign__r.Id, Owner.Name, Name FROM Lead where name ='TheUserName' 

Campaign__r.Name is null

However, the following SOQL

SELECT Campaign__c,Campaign__r.Name, Campaign__r.Id, Owner.Name, Name, SystemModstamp FROM Lead where Campaign__r.Name <> ''

returns results and shows it works fine for the other campaigns.

Do you have any idea why it doesn't work for this specific campaign?

Thanks in advance