PSOPERREST_VW

(SQL View)
Index Back

Show REST service operations.

This view filters out REST operations tied to MAP layouts.

SELECT A.IB_OPERATIONNAME , A.DESCR FROM PSOPERATION A , PSOPRVERDFN B WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND A.IB_REST_SERVICE <> 0 AND A.IB_RESTMETHOD = 'GET' AND B.IBDOCLAYOUTNAME = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description