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

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.

  • 0

    Hi Russel Vasquez,

    Go to database check for the table leads_cstm table you can find all the custom field for leads module

    Thanks & Regards 

    G Varun Kumar

  • 0 in reply to Varun Kumar

    Hello G Varun Kumar, thank you. I check it and give a feed back.

  • 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

  • 0 in reply to Varun Kumar

    Thank you G Varun Kumar for the help, I already got it and able to generate report including all the custom field. Only the email data is missing. Thank you again.