Table Join - Timesheet Categories with Requests

[BobbyB]

Hello, I need to pull off Timesheet entries but need to view details of any linked requests.  When I tried to Join Requests with Timesheet Categories I didn't see any related fields to join.  My current Timesheet report has Timesheet Categories joined with Timesheet Values but I also need info from the Requests table.  Is there anyway to do this?

 

Many thanks,

Bobby

@Alisha

[Alberto M]

@BobbyB, I got the requests joined to categories through the timesheet values table. Joining the requests table with the timesheet values table and then joining the timesheet values with the categories.

Will this be useful for you?

 

 

[BobbyB]

Thanks @Alberto M, but every time I try to add in the requests table it puts in a project table....very annoying......

 

or 

 

If I put in Requests as the first table it won't show any 'Join' actions....

Unsure why it's doing this...

 

Thanks,

Bobby

@Alisha

 

 

 

 

 

 

 

 

[Alberto M]

@BobbyB, I'm not sure if this have any impact, but I've designed the reports in the Timesheet app. Are you doing the same?

 

[BobbyB]

Thanks @Alberto M, I've managed now to get it working with Requests at the beginning by using your joins, thanks again for your help

 

Bobby

 

@Alisha

[Alberto M]

@BobbyB, glad to help  

[George Warren]

@BobbyB @Alberto M - You don't happen to know how to pull in the team of the person logging the time? I assume there would need to be a join from the accounts table to an organisation or team table, is there any documentation for table relationships?
Its just where we have tickets passed between teams, we cant just use the team that the ticket ended up assigned to.