Header Ads

  • Recent Posts

    SQL queries to find the Component, its search record, add search record of a PeopleSoft component interface


    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



    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad