Author Topic: Syntax for Contact is in Trash (Read 1145 times)

Shai · May 15, 2012, 06:47:39 am

Hi,

I'm searching using the search builder using:

Individual --> Contact is in Trash --> = --> 1

That returns 0 records when I know there are about 20 that have been trashed.

Ideas?

Shai

Hershel · May 15, 2012, 09:48:33 am

Can you confirm your figure of 20 by looking in the DB for contacts with is_deleted = 1 ?

Shai · May 15, 2012, 10:34:42 am

Hershel,

Thanks for the response.

My my db I ran:

Code: [Select]

SELECT id from civicrm_contact WHERE is_deleted = 1
returns 1,329 rows. (It appears that I had been inadvertently deleting instead of "permanently deleting" a lot more than I had thought. Hence my need for this!)

Also, I just went to drupal.demo.civicrm.org and had the same result:

First I deleted 50 contacts. Then I went to form builder and searched on:

Quote

Individual --> Contact is in Trash --> = --> 1

and got:

Quote

No matches found for:
Contact is in Trash = "1" ...AND...
Contact Type - 'Individual'

Shai

Hershel · May 15, 2012, 10:36:44 am

I just went to

http://drupal.demo.civicrm.org/civicrm/contact/search/advanced?reset=1

I.E. Advanced Search. I selected "Search in Trash" and clicked Search.

I got 51 results.

Shai · May 15, 2012, 11:06:02 am

Great, thanks. I had never noticed that box before. And in fact, I to do a Firefox search of the page to find it! Amazing how you can miss what is in front of you.

Since the search builder's "Individual --> Contact is in Trash --> = --> 1" is not working, should I file a bug report?

Shai

Hershel · May 15, 2012, 11:42:23 am

Contact is in Trash IS NOT NULL

finds 113 records.

Shai · May 15, 2012, 02:24:44 pm

WTF???

How do you explain the discrepency?

Advanced search search in trash returns 51 records (which are the ones that I put in the trash).

Contents in Trash is Not Null returns 113 records, some of them in the Trash and some not.

Hershel · May 16, 2012, 04:49:18 am

I used Trash is Not Null just as an experiment. In the DB it's a 1 or 0 so zero is actually "not null." I'm not sure how it's meant to work. Hopefully someone else can answer here.

Hershel · May 17, 2012, 07:34:36 am

Quote from: Hershel on May 16, 2012, 04:49:18 am

Hopefully someone else can answer here.

But if not, I would suggest you post an Issue.

Donald Lobo · May 17, 2012, 10:31:39 am

Note that search builder is not being actively maintained or bug fixed. We are looking for someone in the community to take over that funcitonality

lobo

CiviCRM Community Forums (archive)

News: