I have the following use case.
Find all opportunities whose "estimated close date" is within 7 days of today and update one of its fields.
I thought of implementing this via Process Builder but looks like the process builder cannot simply do a mass processing without any DML entry criteria.
Am I right ?.
Can the above mentioned requirement can be implemented via process builder ?
What are other alternatives (I can think of batch apex....is there something else?)
EDIT : Adding more info
Opportunity O has a 1:1 lookup relationship with Asset A.
A's parent Object is DeltaBuild D.
D has a date field "Complete Date".
This complete date in D is available in O via cross object formula field (O.X)
Our use case is that all opportunities where O.X is within a week from today() then a field update has to happen and an email alert is to be sent.
I believe that this process cannot be done via TimeBased WF because we will not know when D.CompleteDate field will be populated.
Also we can't base this timebased wf even from DeltaBuild Object also because D has 1:many relationship with Asset A.
If our use case can indeed be done via timebased wf then I and my client will be happy..:)
Would appreciate any pointers :)