tag:blogger.com,1999:blog-7204411147499359498.post1202684116130099911..comments2022-02-25T11:39:10.722-05:00Comments on TRIRIGA Development: Impact of Changing List ValuesRob Zombronhttp://www.blogger.com/profile/14515979904589988419noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7204411147499359498.post-72273763990585481332011-08-16T09:44:36.547-04:002011-08-16T09:44:36.547-04:00Thanks Eric!Thanks Eric!Rob Zombronhttps://www.blogger.com/profile/14515979904589988419noreply@blogger.comtag:blogger.com,1999:blog-7204411147499359498.post-5453971984014874762011-08-16T09:42:53.828-04:002011-08-16T09:42:53.828-04:00That'll actually give you all the list fields ...That'll actually give you all the list fields with that name (e.g. "triTaxPaidToLI"); if you want all the fields referencing that list (e.g. the "triTaxPaidTo" list), it would be:<br /><br /><br />SELECT<br /> ibs.name "Business Object",<br /> atr.sub_category_name "Section",<br /> atr.atr_name "Field",<br /> atr.atr_default_value "Default Value"<br />FROM ibs_spec_value_meta_data atr<br />JOIN ibs_spec_type ibs ON<br /> ibs.spec_template_id = atr.spec_template_id<br />JOIN list_master l ON<br /> l.list_id = atr.list_id<br />WHERE atr.atr_type = 'List' AND<br /> l.list_name = 'triTaxPaidTo'<br />ORDER BY 1, 2, 3Eric Glasshttps://www.blogger.com/profile/10011593105478501920noreply@blogger.com