Author Topic: Role and Current Employer Details (Read 731 times)

bhupendra · December 10, 2012, 03:55:40 am

Hello ,

I am new to civicrm, I am facing a prob

1. In participant table role_id is defined but not getting the role in ref table , where this locate. I want role name.
2. which table contain the filed current employer. I want to show this in front end but not getting where this actually stored.

Thanks

lcdweb · December 10, 2012, 06:13:01 am

1: not sure what you mean by "not getting the role in ref table". the role_id in civicrm_participant will reference the value column in civicrm_option_value where option group is the id in _option_group for participant_role. note that role_id may take multiple values, separated by the separator constant. so you can't do a straight join (unless you know with certainty that your records only ever have one value for that field)

2. the current employer ID is civicrm_contact.employer_id. the organization name is cached in civicrm_contact.organization_name

CiviCRM Community Forums (archive)

News:

Author Topic: Role and Current Employer Details (Read 731 times)

bhupendra

Role and Current Employer Details

lcdweb

Re: Role and Current Employer Details