CiviCRM Community Forums (archive)

In the civicrm_option_value table, there are a few tantalizing fields I've never known how to use:

  `grouping` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Use to sort and/or set display properties for sub-set(s) of options within an option group. EXAMPLE: Use for college_interest field, to differentiate partners from non-partners.',
  `filter` int(10) unsigned DEFAULT NULL COMMENT 'Bitwise logic can be used to create subsets of options within an option_group for different uses.',

  `is_optgroup` tinyint(4) DEFAULT '0' COMMENT 'Is this row simply a display header? Expected usage is to render these as OPTGROUP tags within a SELECT field list of options?',

I have a case now where I would like to filter the option values for electoral constituencies (we call them ridings, US calls them districts) based on the province. Is there documentation on this somewhere? There are no default entries in the option_value table with is_optgroup set, though the grouping is used for case_status and label_form (avery labels). filter<>0 (ie, 1, occasionally 2 or 3) for options in activity_type, participant_role, contact_edit_options, redaction_rule, email_greeting, postal_greeting and addressee option groups.

If someone could explain how these fields are / could be used I would document in wiki.

Thanks.