Hi,
I'm receiving this error on one of my screens, please could someone help?
The Data Fetcher screen component on this screen is reporting the following Error: unexpected token: 'TaskQuery4'
Formula -
"SELECT Subject, Id, Activity_Completed_Date__c, ActivityDate, Call_Reason__c, CreatedDate, Outcome__c, Owner_Name__c, Task_Type__c, Status, OwnerId, WhatId, WhoId FROM Task WHERE WhatId != null AND WhatId ='"+{!
OpportunityTable4.outputSelectedRow.Id}+"' ORDER BY CreatedDate DESC"
Data Fetcher -
Hello @Alex MacRae
, I will suggest couple of things :
1. Can you print the value of
OpportunityTable4.outputSelectedRow.Idin the same screen ? I am guessing value is not present.
2. If you are able to get the value as per step 1, then execute this query separately using the printed value .
SELECT Subject, Id, Activity_Completed_Date__c, ActivityDate, Call_Reason__c, CreatedDate, Outcome__c, Owner_Name__c, Task_Type__c, Status, OwnerId, WhatId, WhoId FROM Task WHERE WhatId != null AND WhatId ='"+{!
OpportunityTable4.outputSelectedRow.Id
}+"' ORDER BY CreatedDate DESC
Let me know how it goes.
Kind Regards,