Announcement

Collapse
No announcement yet.

Report with deleted opportunities

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Report with deleted opportunities

    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

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

    Comment


    • #3
      Hello,

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

      Comment


      • #4
        could you reproduce it on demo?
        did you modify core files?

        Comment


        • #5
          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?

          Comment


          • #6
            Yes, thanks.
            I will answer, if have any news

            Comment


            • #7
              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

              Comment


              • #8
                The easiest way is to add
                Code:
                [{
                    "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

                Comment


                • #9

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

                  Comment

                  Working...
                  X