Report with deleted opportunities

[PGI]

Hello,

I have a problem with a report on opportunities: when I look at my report, it contains opportunities that have been deleted.

How can we get a report that includes only un-deleted opportunities?

Thank you for your help,

PGI

[tanya]

Hello
Do you develop your report or created it with GUI? By default deleted records aren't included in reports

[PGI]

Hello,

I am using a report created with the GUI. So it's probably a bug..

[tanya]

could you reproduce it on demo?
did you modify core files?

[PGI]

Hello,

Yes, I just created it in the demo: report "test".
This is a report that counts products by opportunity. So I linked opportunities to products.

I added products in 4 opportunities. Then I deleted the opportunity "1000 USD". This deleted opportunities / products still appears in the report.

You see it?

[tanya]

Yes, thanks.
I will answer, if have any news

[PGI]

Hello,

Until the problem is solved, do you know what modification I can make in the PHP files to correct my report?

thank you very much

Best regards

[tanya]

The easiest way is to add

[{
    "id": "b0f12faaa9d3f",
    "name": "opportunity.deleted",
    "params": {
        "type": "isFalse",
        "field": "opportunity.deleted",
        "attribute": "opportunity.deleted"
    }
}]

in database table 'report' to filters_data_list column in your report. But after it your report can't be modified with UI

Have no time to deep digging in source code

[PGI]

Hello, Thank you, I will try! ;-)