get_fields_using_attribute.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 15 行

select
 ss.section_id,
 ss.section_name,
 ssi.party_id,
 a.attribute_id,
 a.attribute_name
from
 ui_screen_section_info ssi,
 ui_screen_section ss,
 ui_attribute a
where
 a.attribute_id = ssi.attribute_id and
 ss.section_id = ssi.section_id and
 a.attribute_id = 7802;