Query Creation Services

Query creation services are used by client applications to create and save a new query.

SOAP Query Creation Services

This table lists the Query Creation Services:

Service Operation Name Description

QAS_RECORDS_OPER

Returns the list of records, along with descriptions, that are accessible to the user.

QAS_HIERARCHY_RECORDS_OPER

Returns the list of hierarchy records, if any, along with their descriptions.

QAS_RELATED_RECORDS_OPER

Returns the list of related records of all the fields in the record.

QAS_RECORD_DEFN_OPER

Returns the definition of a given record, including field descriptions and key information.

QAS_TREES_OPER

Returns the list of PeopleSoft trees that are accessible to the user.

QAS_TREE_DETAILS_OPER

Returns the tree details, including setID, effective date, and the list of all the nodes.

QAS_FIELDS_OPER

Returns the fields from all records that are accessible to the user.

QAS_FIELD_PROPS_OPER

Returns the properties of a given field.

QAS_QUERY_DETAILS_OPER

Returns the complete details of an existing query in XML format.

QAS_SAVE_QUERY_OPER

Validates and verifies XML-format query and saves the query in the PeopleSoft database.

QAS_QUERY_DELETE_OPER

Deletes the query from the PeopleSoft database.

QAS_CREATE_CPQ_OPER

Returns a message that contains the SQL of the Composite Query.

RESTful Query Creation Services

This table lists the Query Creation Services:

Service Operation Name Description

QAS_RECORDS_REST_GET

Returns the list of records, along with descriptions, that are accessible to the user.

QAS_RECORD_DEFN_REST_GET

Returns the definition of a given record, including field descriptions and key information.

QAS_HIERARCHY_RECORDS_REST_GET

Returns the list of hierarchy records, if any, along with their descriptions.

QAS_RELATED_RECORDS_REST_GET

Returns the list of related records of all the fields in the record.

QAS_FIELDS_REST_GET

Returns the fields from all records that are accessible to the user.

QAS_FIELDS_PROPS_REST_GET

Returns the properties of a given field.

QAS_TREES_REST_GET

Returns the list of PeopleSoft trees that are accessible to the user.

QAS_TREE_DETAILS_REST_GET

Returns the tree details, including setID, effective date, and the list of all the nodes.

QAS_QUERY_DELETE_REST_DELETE

Deletes the query from the PeopleSoft database.

QAS_SAVE_QUERY_REST_POST

Validates and verifies XML-format query and saves the query in the PeopleSoft database.