Author Topic: Create New Activity: civicrm_activity_create. Not found with Advanced Search (Read 1424 times)

ijames · October 06, 2008, 03:14:17 pm

Hi All,

I'm using Civicrm 2.0.1. Drupal 5.

I create Activities using the API civicrm_activity_create.

When I try to use Advanced Search to locate the activities created this way, it doesn't seem to work.

Looking at the civicrm_activity table, there seems to be no particular distinction from other records created within CiviCRM.

Yet when I go to a contact's activity and I hit the Save button within CiviCRM, it then gets found by Advanced Search.

I can't find a bug report or anything for this particular issue. Does somebody know what's going on here? What is the difference between the API and manual activity addition? How does Advanced search work? Is this a character encoding issue?

All I'm searching on is a particular Activity all other fields are left alone.

Thanks much!

James

Donald Lobo · October 06, 2008, 04:52:38 pm

can you cut-n-paste two activity records. One created by the API and one created via the UI. Please try to keep details the same

also what activity fields are you searching that does not display the API activities? (since a couple of other activity tables might be involved (civicrm_activity_assignment, civicrm_activity_target). Can we also the data dump for those two table for the two different activity id;

you might want to use the foll snippet (replace the id column with the right values)

Code: [Select]

select * from civicrm_activity where id in (1,2) \G;
select * from civicrm_activity_target where activity_id in (1,2) \G;
select * from civicrm_activity_assignment where activity_id in (1,2) \G;

thanx

lobo

ijames · October 06, 2008, 05:06:30 pm

Thanks Lobo!

It looks like it's got something to do with the civicrm_activity_target not being there. This is the "with" field? I hadn't included that in the parameters but now I'm suddenly running into other problems, probably unrelated, where my soap is not finding user_load?

What is the target table and link used for?

James

CiviCRM Community Forums (archive)

News:

Author Topic: Create New Activity: civicrm_activity_create. Not found with Advanced Search (Read 1424 times)

ijames

Create New Activity: civicrm_activity_create. Not found with Advanced Search

Donald Lobo

Re: Create New Activity: civicrm_activity_create. Not found with Advanced Search

ijames

Re: Create New Activity: civicrm_activity_create. Not found with Advanced Searc