Can I query the CollabNet TeamForge database?

Yes, you can query the database if you are a site administrator or have been given access to System Tools by another site administrator. You can raise a database query by using the Admin > System Tools > Ad Hoc Database Query page.

In the Ad Hoc Database Query page, type the "select" query and click the Run Query button. The query is executed against the CollabNet TeamForge database and the results are dispayed.

Note: The results of your query may be limited or your query session may time-out as per the settings in the site-options.conf file.

You can submit read-only queries of the format: SELECT [FROM][WHERE][GROUP BY] [HAVING] [ORDER BY].

Tip: 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.

Note: This feature is not supported by Oracle at the backend.