Author Topic: where's the activity_type table? (Read 485 times)

myles · February 23, 2011, 03:12:47 am

Hi -

I need to manually change the status of all the inbound emails that have been created by users with status=scheduled rather than closed...

I was going to use look up the activity_type table to identify the id of the inbound email activity type (one we created earlier) - but I can't find the table!

What's it called!?

Rajan Mayekar · February 23, 2011, 03:31:55 am

Activity types comes from table civicrm_option_value for option_group_id = 2. ( option_group_id is foreign key for civicrm_option_group.id, for activity types civicrm_option_group.name = 'activity_type' )

So u will get the all activity type as

Code: [Select]

SELECT * FROM civicrm_option_value INNER JOIN civicrm_option_group ON civicrm_option_value.option_group_id = civicrm_option_group.id WHERE civicrm_option_group.name = 'activity_type';

Rajan

myles · February 23, 2011, 04:24:54 am

Fantastic, thanks

CiviCRM Community Forums (archive)

News:

Author Topic: where's the activity_type table? (Read 485 times)

myles

where's the activity_type table?

Rajan Mayekar

Re: where's the activity_type table?

myles

Re: where's the activity_type table?