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 sfuser
and 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, sfuser_view
and password_history_view
, for retrieving all other data but passwords.
site-options.conf
file.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.