Recently I was analyzing a number of Component Interface meta data and below are few simple SQL queries I formed and thought would be useful. However, all these queries are based on PSBCDEFN and PSBCITEM tables.
SQL Query to find search records in a CI:
SELECT SEARCHRECNAME, ADDSRCHRECNAME
FROM PSBCDEFN
WHERE BCNAME = :1 -- Component Interface name
SQL Query to find out the records exposed by a CI:
SELECT distinct recname
FROM PSBCITEM
WHERE BCNAME = :1 -- Component Interface name
This query also returns the search record.
SQL Query to find out the Component associated with a Component Interface:
SELECT BCPGNAME,MARKET,MENUNAME
FROM PSBCDEFN
WHERE BCNAME = :1 -- Component Interface name
SQL Query to find search records in a CI:
SELECT SEARCHRECNAME, ADDSRCHRECNAME
FROM PSBCDEFN
WHERE BCNAME = :1 -- Component Interface name
SQL Query to find out the records exposed by a CI:
SELECT distinct recname
FROM PSBCITEM
WHERE BCNAME = :1 -- Component Interface name
This query also returns the search record.
SQL Query to find out the Component associated with a Component Interface:
SELECT BCPGNAME,MARKET,MENUNAME
FROM PSBCDEFN
WHERE BCNAME = :1 -- Component Interface name
No comments:
Post a Comment