Rollup of opportunity contact role

[agnaramasi]

Hello,
I am trying to create a rollup on the opportunity to count the number of contact roles a certain type that have been assigned. I get an error when I deploy the trigger stating that the object does not support triggers. I get the same error if I attempt to use scheduled mode.
I understand that opportunity contact roles do not support triggers, but shouldn't scheduled mode still be possible?
Many thanks for your wonderful tool.
Jonathon

[agnaramasi]

Here is a screenshot. I selected "Scheduled" mode in this example.

[aheber]

That is because Salesforce doesn't support having triggers on that object.
You can vote to support the idea to change that: https://success.salesforce.com/ideaview?id=08730000000BrdvAAC

You might want to try and do it as a scheduled job rather than realtime. I haven't tried it, but that would be my next step.

[agnaramasi]

The same error happens when I set to scheduled mode. I appreciate any suggestions you can provide!

[aheber]

Oops! I missed that, sorry.

[agnaramasi]

Do I need to press "Deploy" before I can schedule the RollupJob class?

[afawcett]

Schedule mode still needs the triggers unfortunately, as it records changes to the child records the scheduled job processes.

[afawcett]

@aheber Thanks btw for picking this one up! :-)

[afawcett]

I'm sorry, currently schedule mode still requires a trigger to log the records changed for the job to pick up. I did ponder long and hard about this design decision, and in the end could not find a way to do it without. The Replication API came close, but does not give events on deletion of records. Sorry, i will keep an eye out in the future for new features of the platform and/or ideas to remove this requirement.

[agnaramasi]

Really appreciate the effort! Thanks Andrew,
Jonathon
On Sep 3, 2014 4:22 AM, "Andrew Fawcett" notifications@github.com wrote:

I'm sorry, currently schedule mode still requires a trigger to log the
records changed for the job to pick up. I did ponder long and hard about
this design decision, and in the end could not find a way to do it without.
The Replication API came close, but does not give events on deletion of
records. Sorry, i will keep an eye out in the future for new features of
the platform and/or ideas to remove this requirement.

—
Reply to this email directly or view it on GitHub
#59 (comment)
.

[andykallio]

Just want to show my support for a solution here. I voted for https://success.salesforce.com/ideaview?id=08730000000BrdvAAC years ago, and I have tried to vote for it again several times since! I seem to butt heads with this a couple times a year...guess it's time to migrate to a custom object.

[afawcett]

Just upvoted! 👍

[tenacoder]

Are we able to do a realtime Rollup of opportunity contact role now?

[DanDonin]

That object doesn't support triggers :(

…

On Jul 11, 2017 4:31 PM, "Tena Wolver" ***@***.***> wrote: Are we able to Rollup of opportunity contact role now? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#59 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/APXKqnx6Kcjgy3jiaOJQt2FEpvmRorOzks5sNAXCgaJpZM4CY-e-> .

[tenacoder]

Thanks for confirming that.