Jump to content

Recommended Posts

Posted

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

Posted

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

 

image.thumb.png.702f8f91f9425084b33610ca3e32a58c.png

image.thumb.png.1c36f774f67e060f633ee89de2c3c494.png

 

  • Like 1
Posted

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

  • 2 years later...
Posted

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

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