st.table_name, stf.field_name, sl2.title as language_title, stfl.title as field_title, stfl.description as field_description FROM sys_table st inner join sys_table_field stf on st.sys_table_id = stf.sys_table_id left join sys_table_field_lang stfl on stf.sys_table_field_id = stfl.sys_table_field_id left join sys_lang sl2 on stfl.sys_lang_id = sl2.sys_lang_id left join sys_table_lang stl on st.sys_table_id = stl.sys_table_id left join sys_lang sl1 on stl.sys_lang_id = sl1.sys_lang_id WHERE sl2.sys_lang_id = 1 /* and st.table_name = 'accession_inv_name' */ ORDER BY st.table_name, stf.field_ordinal /* comments */ (The sl2.sys_lang_id = 1 references English; see the section for details on determining the Language ID values.) SQL for Displaying Dataview Field Names /* (Primarily used by GG administrators; displays data stored in sys_dataview_field_lang) */ USE gringlobal; SELECT sd.dataview_name, sdl.title AS dataview_title, sdf.field_name, sl.title as language_title, sdfl.title as field_title, sdfl.description as field_description FROM
st.table_name, stf.field_name, sl2.title as language_title, stfl.title as field_title, stfl.description as field_description FROM sys_table st inner join sys_table_field stf on st.sys_table_id = stf.sys_table_id left join sys_table_field_lang stfl on stf.sys_table_field_id = stfl.sys_table_field_id left join sys_lang sl2 on stfl.sys_lang_id = sl2.sys_lang_id left join sys_table_lang stl on st.sys_table_id = stl.sys_table_id left join sys_lang sl1 on stl.sys_lang_id = sl1.sys_lang_id WHERE sl2.sys_lang_id = 1 /* and st.table_name = 'accession_inv_name' */ ORDER BY st.table_name, stf.field_ordinal /* comments */ (The sl2.sys_lang_id = 1 references English; see the section for details on determining the Language ID values.) SQL for Displaying Dataview Field Names /* (Primarily used by GG administrators; displays data stored in sys_dataview_field_lang) */ USE gringlobal; SELECT sd.dataview_name, sdl.title AS dataview_title, sdf.field_name, sl.title as language_title, sdfl.title as field_title, sdfl.description as field_description FROM
gg_language_guide.docx