Domain values and translations SF database

Userlevel 2
Badge +4

Sometimes when I am working on a dynamic model for example, it is difficult to figure out which database value for a domain in the SF database translates to a particular translation in the GUI. For example, figuring out the database value in the table col for column 'calculated_field_type' when it is an expression or when it is a calculated column can be quite tedious. I usually then look for a column in the UI with the particular value I am looking for, and then query the database to find out what database value is associated with this. 

What is the easiest way to figure this out? Is there a data dictionary somewhere I can refer to?


Best answer by J. de Lange 29 May 2024, 14:06

View original

2 replies

Userlevel 4
Badge +3

Hello Bram,

Unfortunately there is no easy way to figure this out currently. It is possible to query the SF database to find out the values of elements, their elemnt_id as well as their database value but that is currently the only way to do it.

If you want, you could create an idea for this and we can look into it in the future 😊

Kind regards,


Userlevel 3
Badge +4

I like to use this script to find the domain elements of the SF:

/*Use alt+f1 on a column in the SF to find the tab_id and col_id and enter them in the variables below*/
USE IAM_SoftwareFactory_dev
declare @tab_id tab_id = 'control_proc'
,@col_id col_id = 'development_status'
select e.dom_id, e.elemnt_id, e.db_value, t.transl, c.model_id , c.branch_id
from col c
join elemnt e
on e.model_id = c.model_id
and e.branch_id = c.branch_id
and e.dom_id = c.dom_id
join transl t
on t.model_id = e.model_id
and t.branch_id = e.branch_id
and t.transl_object_id = e.elemnt_id
where c.tab_id = @tab_id
and c.col_id =@col_id
and t.appl_lang_id = 'ENG'
and t.type_of_object = 2 /*domain element*/
order by c.model_id, c.branch_id, e.abs_order_no asc

Edit by Moderator: A Thinkstore solution is available called "Getting domain elements in SSMS shortcut”. You can download this into your Software Factory from the Thinkstore screen in the Software Factory.