SQLDepot

2 queries found for "Field"

Get MD Field

SELECT * FROM CI_MD_FLD WHERE FLD_NAME='FIELD_NAME'
uploaded by Venkata Sai Bhargav Kakunuri

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