Thread Details
  • State Not Answered
  • Replies 4 replies
  • Subscribers 354 subscribers
  • Views 614 views
  • Users 0 members are here
Forum Actions
Related

Custom Field Location

Russel Vasquez

Hello Everyone!

Can you help me? I'm just working on custom query for Leads Module. My problem is I can't find all the custom field we use and also the email field.

Where or what table name does custom field belongs? and why email field is not included in all column of Leads?

Thanks in advance.

Parents Reply Children
  • 0 in reply to Russel Vasquez

    Hi Russel,

    In addition to Varun's Reply, I would like to add a few things to this. As he mentioned whenever a custom field is created in any module sugar creates a custom table in the database. It stores all the custom fields (which ends with _c) in the custom tables only. So for the leads, all the custom tables will be stored in the leads_cstm table only. Similarly, if it accounts all the custom fields will be stored in the accounts_cstm table and respectively for all the modules.

    And Sugar will not store the email addresses directly in the main module. It has a separate set of tables for storing all native email addresses of different modules. Please go through this link to know more about how Sugar stores email addresses of various modules in the Database.

    Hope this information helps you:)

    Thanks and Regards,

    PK,

    www.bhea.com