Forums - Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 318 subscribers
  • Views 1307 views
  • Users 0 members are here
Forum Actions
Related

What table can show me a relate field?

Juan Felipe Zuluaga Gómez

Hi people.

I wanna update some registers with a bad id in a relate field, the problem is, where (what table) can I see this relation on BD? for example, I have a relate field between Products and Sellers, in the field Product->Seller, I have the id of the seller. Some register is bad created, I wanna update these registers.

This field isn't a relationship between modules, is just a "relate" field.

Greetings.

Parents
  • 0

    If the related field is created as a custom field you find it in table products_cstm which is linked to table products with the coulumn id_c.

    You get all out-of-the-box fields and custom fields by the SQL statement

    SELECT p.*, pc.* from products p 
      left join products_cstm pc 
      on p.id=pc.id_c 
    where p.deleted=0

    The field name is derived from the modulename of the field. So if the Seller is related to modules Accounts the columnname would be account_id_c if there was no other field related to Accounts before.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Reply
  • 0

    If the related field is created as a custom field you find it in table products_cstm which is linked to table products with the coulumn id_c.

    You get all out-of-the-box fields and custom fields by the SQL statement

    SELECT p.*, pc.* from products p 
      left join products_cstm pc 
      on p.id=pc.id_c 
    where p.deleted=0

    The field name is derived from the modulename of the field. So if the Seller is related to modules Accounts the columnname would be account_id_c if there was no other field related to Accounts before.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Children
No Data