Author Topic: Looking for event_id (Read 1036 times)

maarten · February 06, 2008, 02:22:56 pm

I have a question about the next piece of help info, that shows up when you want to add a url to an iCal feed:

Quote

"By default, the ical feed gets all events whose starting date is greater than or equal to the current date. However, you can modify this by passing additional parameters in the URL:

* start=YYYYMMDD - Specify a different starting date range for the events to be listed
* type=N - Specify a particular Event Type using the event_type_id value. (You can find these values by browsing the listing at Administer CiviCRM » Event Types.)

I have a question about the "(You can find these values by browsing the listing at Administer CiviCRM » Event Types.)". I can only find the "weights" and not the actual id. I can change the weights in the table, without changing the event_type_id in civicrm_event. So where can I find the real event_id of an event?

Kurund Jalmi · February 06, 2008, 11:39:01 pm

I am assuming you are using CiviCRM v1.9. We have added "Value" column in CiviCRM v2.0, that displays event_type_id.
So i think you will have to check database, "civicrm_option_value" table and the check "value" field corresponding to your event type.

Quote

SELECT * FROM `civicrm_option_value` where `option_group_id` = 14;

Above sql will give you all event types.

HTH

kurund

CiviCRM Community Forums (archive)

News:

Author Topic: Looking for event_id (Read 1036 times)

maarten

Looking for event_id

Kurund Jalmi

Re: Looking for event_id