Resolution | For the subform fields used in various applications:
SELECT FD .field_id, FT. field_name, mt.module_name as ApplicationName, mt.module_id, FT.field_desc , FD .Alias, ASO. aso_status_name, FDS.search_default_field , FDS .required, FD. field_help_options FROM tblIVFieldDef FD JOIN tblLevel L ON FD .level_id = L .level_id JOIN tblModule M ON M .module_id = L .module_id JOIN tblModuleTranslation mt ON mt.module_id = M.module_id JOIN tblFieldTranslation FT ON FT .field_id = FD .field_id JOIN tblIVFieldDefSubform FDS ON FDS .field_id = FD .field_id JOIN tblASOStatus ASO ON ASO .aso_status = FD .aso_status WHERE FD .field_type_id = 24
For the actual subforms:
SELECT mt.module_name AS SubFormName , FT.field_name AS FieldsOnSubForm , mt.module_desc AS SubFormDesc, M.Alias AS SubFormalias FROM tblModule M JOIN tblModuleTranslation mt ON mt.module_id = m.module_id JOIN tblLevel L ON M .module_id = L .module_id JOIN tblIVFieldDef FD ON FD .level_id = L .level_id JOIN tblFieldTranslation FT ON FT .field_id = FD .field_id WHERE M .module_type_id = 5
|