You can raise a database query using the Admin > System Tools > Ad Hoc Database Query page.
In the Ad Hoc Database Query page, select a data store,
Operational Datastore or
Datamart, type the “select” query and click Run Query. The query is executed against the CollabNet TeamForge database and the results are dispayed.
For security reasons, the
password_history tables of the operational datastore are restricted for ad hoc querying from the Admin > System Tools > Ad Hoc Database Query page. Alternatively, use the following views,
password_history_view, for retrieving all other data but passwords.
You can submit read-only queries of the format:
SELECT [FROM][WHERE][GROUP BY] [HAVING] [ORDER BY]
You can use the following special keywords while drafting the query:
- “\d” or “show tables” - To list all the tables.
- “\d <table name> - To view the description of a specific table.
- “select * from <table name> - To view all the contents of a specific table.