3 queries found for "MD Table Field"

Retrieve all Fields and Tables for Account MO

SELECT T.MAINT_OBJ_CD,
  T.TBL_NAME,
  TL.DESCR,
  T.TBL_ROLE_FLG,
  F.FLD_NAME,
  FL.DESCRLONG,
  FL.LABEL_LONG ,
  F.REQUIRED_SW,
  F.NULLABLE_SW,
  F.VALIDATE_SW
FROM CI_MD_MO M ,
  CI_MD_MO_TBL T ,
  CI_MD_TBL_L TL ,
  CI_MD_TBL_FLD F ,
  CI_MD_FLD_L FL
WHERE M.MAINT_OBJ_CD LIKE '%ACCOUNT%'
AND T.MAINT_OBJ_CD = M.MAINT_OBJ_CD
AND F.TBL_NAME     = T.TBL_NAME
AND F.TBL_NAME     = TL.TBL_NAME
AND FL.FLD_NAME    = F.FLD_NAME
ORDER BY TBL_NAME;

uploaded by Nuno Rodrigues

Get custom metadata fields from a metadata custom table

--Query to select custom metadata fields from a metadata custom table
SELECT *
FROM CI_MD_FLD
WHERE FLD_NAME IN
  (SELECT FLD_NAME
  FROM CI_MD_TBL_FLD
  WHERE TBL_NAME='TABLE_NAME'
  AND OWNER_FLG ='CM'
  )

uploaded by Venkata Sai Bhargav Kakunuri

Get custom metadata fields descriptions from a metadata custom table

--Query to select custom metadata fields descriptions from a metadata custom table
SELECT *
FROM CI_MD_FLD_L
WHERE FLD_NAME IN
  (SELECT FLD_NAME
  FROM CI_MD_TBL_FLD
  WHERE TBL_NAME='TABLE_NAME'
  AND OWNER_FLG ='CM'
  )

uploaded by Venkata Sai Bhargav Kakunuri