Results 1 to 2 of 2

Thread: Deleted Record but appears in Report Query

  1. 2008-05-15, 02:46 PM #1
    joyful15
    joyful15 is offline Junior Member
    Join Date
    Mar 2008
    Posts
    2

    Default Deleted Record but appears in Report Query

    I deleted an opportunity for one of the contacts but when I run a report query the contact continues to appear. How can this be fixed?
    Reply With Quote Reply With Quote
  2. 2008-05-15, 02:50 PM #2
    mikesolomon
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: Deleted Record but appears in Report Query

    Quote Originally Posted by joyful15
    I deleted an opportunity for one of the contacts but when I run a report query the contact continues to appear. How can this be fixed?
    did you put in your sql statement 'where opportunities.deleted=0 ?

    When sugar deletes a record it sets the field deleted to 1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error retrieving record. This record may be deleted or you may not be authorized to v
    By mborucki in forum Help
    Replies: 8
    Last Post: 2008-06-03, 05:40 AM
  2. Error retrieving record. This record may be deleted or you may not be authorized to v
    By mazsola in forum Help
    Replies: 8
    Last Post: 2008-05-01, 09:22 PM
  3. export calender data and import to outlook using custom query report in zuckerreports
    By aheuermann in forum Help
    Replies: 1
    Last Post: 2006-08-03, 10:06 AM
  4. SugarCrm 4.0 Patch
    By mgamboa in forum General Discussion
    Replies: 0
    Last Post: 2005-12-21, 04:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules