CiviCRM Community Forums (archive)

I am trying to write some basic views integration for CiviCase. I am struggling to implement the Case Type field using civicrm_handler_field_pseudo_constant. It looks to me as though this is because the case_type_id field in civicrm_case table is implemented as a varchar(128) rather than an int(10) FK. Does anyone know why this might be?

The original spec called for multivalued case types. But in practice usually what you have is a primary single-valued case type, and then a secondary case type(s) field which is multi-valued, and which may or may not affect the prepopulation of activity sets.

There is no built-in feature for the secondary case type(s), and the multivaluedness of the primary one is just left over from the original spec.

That would certainly make my life easier if there is no reason not to.

Alice