Berto2002 Posted April 19, 2023 Posted April 19, 2023 I have a report which draws-out the latest Update (buz activities) on a Request and presents it alongside the Request ID and other information. It has the following joined tables: The data goes into PowerBI which filters and displays the Activity content information if the User who added the Update has a Job Title (this effectively excludes sys_bpm_manager updates: Now, an end User might make a Comment against an existing Timeline entry and my question is where/how are those comments stored in the database so I can add them in to my scheme also? Any help appreciated.
AlexTumber Posted April 19, 2023 Posted April 19, 2023 @Berto2002 the table where comments is stored is called h_buz_comments. The foreign key in this table is h_activity_id. This should give you what you need to create your additional join. Alex 1
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now