Select Id From Event WHERE LastModifiedDate >= Last_N_Days:750 AND WhatId != NULL AND IsRecurrence = FALSE
Select Id From Event WHERE WhatId != NULL AND Call_Status__c = Scheduled AND LastModifiedDate >= Last_N_Days:90 AND IsRecurrence = FALSE
Select Id From Event WHERE WhatId != NULL AND LastModifiedDate >= Last_N_Days:750
답변 6개
Ab Initio is using a Salesforce connector through the Query components. It prompts me to input Salesforce credentials (Username,Pass,Security token) from there on out I can choose what Salesforce objects,fields, etc to query by. I should also add, I also have almost identitcal graphs querying other Salesforce objects like Notifications, Opportunites, and Contacts. Those all are working fine. One common outlier in these queries is the field "WhatId". Possibly causing an issue?
