Apex Code Development You need to sign in to do that
Don't have an account?
Swerz Report is timing out
Hi folks,
I am working on a report which should give me all the opportunities which moved back in stages. There are total 5 stages in which the opportunities can be. So I am looking for opportunities which, say, were in stage 5 initially and moved to stages 4, 3, 2 or 1, or were in stage 4 initially and moved to stages 3, 2, or 1 and so on.
I am using the below filters:
1) Opportunity status equals Active
2) From Stage equals 2
3) To Stage equals 1
4) From Stage equals 3
5) To Stage equals 1, 2
6) From Stage equals 4
7) To Stage equals 1, 2, 3
8) From Stage equals 5
9) To Stage equals 1, 2, 3, 4
1 AND ((2 and 3) or (4 and 5) or (6 and 7) or (8 and 9))
Now this report never gets generated. Times out all the time. Maybe due to so many opportunities on which to put these many filters.
Can anyone pls help me optimize the performance.
I am working on a report which should give me all the opportunities which moved back in stages. There are total 5 stages in which the opportunities can be. So I am looking for opportunities which, say, were in stage 5 initially and moved to stages 4, 3, 2 or 1, or were in stage 4 initially and moved to stages 3, 2, or 1 and so on.
I am using the below filters:
1) Opportunity status equals Active
2) From Stage equals 2
3) To Stage equals 1
4) From Stage equals 3
5) To Stage equals 1, 2
6) From Stage equals 4
7) To Stage equals 1, 2, 3
8) From Stage equals 5
9) To Stage equals 1, 2, 3, 4
1 AND ((2 and 3) or (4 and 5) or (6 and 7) or (8 and 9))
Now this report never gets generated. Times out all the time. Maybe due to so many opportunities on which to put these many filters.
Can anyone pls help me optimize the performance.