Queries
A set of queries are created for the Service Catalog during installation.
The following table provides a description of each query and identifies the Start Center that uses each query.
| Clause name | Description | Start Center Template |
|---|---|---|
| PMSCSRUSER | Service Requests created by the logged in User with status not equal to CLOSED | Template-PMSCSRU |
| PMSCSRVOFFSRACTIVE | Offerings with status not equal active | Template-PMSCSDGN |
| PMSCSRVOFFSRPENDING | Offerings with status equal pending | Template-PMSCSDM |
| PMSCSRWAPPR | Service Requests with status equal NEW, APPLM, APPFM | Template-PMSCOA |
| PMSCWAITAPPR | Work Orders with status equal WAPPR | Template-PMSCOA |
| PMSCWOOWNER | Work Orders owned by the logged in User | Template-PMSCOS |
| VIEWSR | View Service Request with status not equal CLOSED | Template-SELFSERVUSER |
| SCFAQ | Frequently Asked Questions | Template-SELFSERVUSER |