CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • where's the activity_type table?
Pages: [1]

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

myles

  • I post frequently
  • ***
  • Posts: 263
  • Karma: 11
where's the activity_type table?
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

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 20
    • Rajan's Blogs
Re: where's the activity_type table?
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

  • I post frequently
  • ***
  • Posts: 263
  • Karma: 11
Re: where's the activity_type table?
February 23, 2011, 04:24:54 am
Fantastic, thanks

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • where's the activity_type table?

This forum was archived on 2017-11-26.