Jump to content

Table Join - Timesheet Categories with Requests


BobbyB

Recommended Posts

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

Link to comment
Share on other sites

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

 

image.png.08e4789a5571d91ccde958fd9453ac2d.png

or 

image.png.2e23f7d4b9d568c9eea1d49cfd388c2b.png

 

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

image.png.da0d6383c84a7e6a70e2d874faa3e126.png

Unsure why it's doing this...

 

Thanks,

Bobby

@Alisha

 

 

 

 

 

 

 

 

image.png

image.png

Link to comment
Share on other sites

  • 2 years later...

@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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...