Troubleshooting - Discussions
Q1 How to fetch all discussions of the repository via Database
Description
A customer requested to fetch all the discussions of the repository in Prolaborate.
Note
The feature to view all discussions by Admin will be available in the upcoming Prolaborate version. As of now, until version 5.2, this feature is not available. Therefore, we can fetch all the discussions of the repository via the Database.
Step by Step instructions
Fetching Repository ID from the Database
a. Open MySQL or MsSql Database.
b. Locate the Prolaborate Database, for example, Prolab v4.4.2.15.
c. Navigate to the dbo.repositories table and Right-click on the table and choose "Select top 1000 Rows."
d. In the result page Identify the repository ID of the repository you want to fetch discussions from.
Fetching Discussions
a. Once you have the Repository ID copied, right-click on the Prolaborate Database and click "New query."
b. In the new query window, execute the following query:
select * from collaborations where Repository_Id = 'RepoID'
Note:
Ensure to replace 'RepoID' with the actual Repository ID you obtained.
Executing this query will fetch all discussions associated with the specified repository.
Reference Tickets
Tags
View All Discussion via Db, Repository ID, RepoID, MySql MsSql, Discussions, Repository Discussions.
Related Articles
FAQs - Discussions
Q1: I wish to opt out of the discussion threads related to the Package 1 and be part of Package 2 only. Please share the steps to achieve the same. A:If your aim is just to be free from the notifications of discussions, you can enable the ...Troubleshooting - Migration
Q1:Database Migration Issue Description Prolaborate schema error while trying to perform a backup via Prolaborate service manager. Resolution - If you are getting this error, check the database table. - The Migration might not work properly if tables ...Prolaborate Collaboration – FAQs and Troubleshooting Guide
1. Tagging and Notifications in Prolaborate Discussions Q1: Why can’t Read-only users be tagged in Prolaborate discussions? Users require Collaborate access to participate in discussions (tagging, commenting). Read-only users are limited to viewing ...Troubleshooting - Manage Users
Q1: Change User's Login Email to a Different Email Address Description The customer has submitted a request to update the login account from PCuthbert@meaa.mea.com to AUmat@meaa.mea.com. Step by Step instructions Step 1: Log in to your Prolaborate ...Troubleshooting - Repository Migration
Q1:Cloud connection issue while trying to connect using Enterprise Architect Description The customer has reported database connection error while trying to connect to the cloud using Enterprise Architect. Resolution - End EA by clicking on 'Exit ...