I am trying to locate the database schema so that I can create reports. Can you advise me on where it is located?

more ▼
asked Jul 09 '13 at 03:24 PM themood11 0 themood11 gravatar image
(comments are locked)
10|3000 characters needed characters left

We currently do not have a schema or a table diagram but the tables in OnTime should be fairly intuitively named. Features for Feature, and FeatureCustomFields, WorkLogs, Projects, etc. If you have any specific questions regarding data or tables in the database please let us know and I'd be happy to point you in the right direction

more ▼
answered Jul 09 '13 at 03:46 PM Brett_AxosoftSupport ♦♦ 3.1k Brett_AxosoftSupport gravatar image
themood11 gravatar image themood11 Jul 09 '13 at 06:31 PM

I am trying to identify how UserId (from the User table) is joined to other tables (For example, AssignedToId & ReportedById from the Features table). I want to be able to pull in the names for the report that I am building.

Brett_AxosoftSupport gravatar image Brett_AxosoftSupport ♦♦ Jul 10 '13 at 02:12 PM

You would just need to join the users table to the features table using the userid as the key. You should then be able to pull the name from the joined table to use for your query.

(comments are locked)
10|3000 characters needed characters left
Your answer

Up to 20 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Social Q&A