Custom Field (Users)

[Anahi]

Hi People, I have this problem:
I created a custom field relate to Users. It created the following things in the database:

Table: fields_meta_data
Row1: Opportunitiesresponsablecomercial_c, responsablecomercial_c, LBL_RESPONSABLECOMERCIAL, Responsable Comercial, Responsable Comercial, Opportunities, relate, 255, 1, NULL, 2008-09-10 20:44:21.000, 0, 0, 0, 0, 0, NULL, Users, user_id_c, NULL
Row2: Opportunitiesuser_id_c, user_id_c, LBL_LIST_RELATED_TO, NULL, NULL, Opportunities, id, 36, 0, NULL, 2008-06-30 20:02:49.000, 0, 0, 0, 0, 0, NULL
Table: opportunities_cstm
Column1: user_id_c
Column2: responsablecomercial_c

I added this custom field in the Opportunities module. I can save a user in this field, but I've not been able to use this field in the Advanced Search of the Opportunities. When I select a user there and press Search, it gives an error: SQL Error : Invalid column name 'responsablecomercial_c'.
What I did is to check which the query is executed when I press Search, and the query is looking for the responsablecomercial_c column in the opportunities table (opportunities.responsablecomercial_c like ...).

Could anyone help me with this problem?

Thanks a lot,

[andopes]

Hi Anahi

Add the attached file into modules/Users/metadata/
Then go to Admin -> Studio -> Users -> Fields
Create the required fields and add the fields into layout editing the modules/Users/EditView.html and modules/Users/DetailView.html

Cheers

[Anahi]

Hi Andre, thanks for you answer.
If I want to create de field in the Opportunities module, will I need to save the studio.php file into modules/Opportunities/metadata/?
And then, the field which I will create should be relate to Users module?
Thanks,

[andopes]

Hi Anahi

It is not necessary. You can normally create custom fields in Opportunities module.
By default the Users module is not available into dropdown option for creating a relate field, so you can add the option into record_type_display dropdown into include/language/en_us.lang.php:

     'Users' => 'Users', 
  

You can remove this entry after creating the custom field.

Cheers