Documentation Center

Save the Query

The following saves the query.

INSERT INTO "QUERYTOOL" ("FORM_ID", "FORM_NAME", "CREATED_BY", "LAST_MODIFIED_BY", "LAST_MODIFIED_DATE", 
                         "COMMENTS", "FORM", "CATEGORY") 
VALUES ( 1, 'PROPERTY_SHEET_QUERY_FOR_MODULE', ' HP Trng', 'sysadmin', 
       'sysadmin', Today's DATE, 'query' , 'Public' );

Running the query results in the display of the Query Form.

Example:

Query Form

When the report has been displayed, the user can click on the WhereUsed icon to locate the selected object. The following Contenta Server commands are used (executed using the Contenta API):

find all|#objid

A Where Used Report displays as the result of Contenta Server Find command—see the example below.

Example:

Where Used Report