Sparx Systems Forum

Pro Cloud Server / Prolaborate / WebEA => PCS General Board => Topic started by: Guillaume on May 02, 2022, 04:36:23 pm

Title: Custom report on Prolaborate DB content
Post by: Guillaume on May 02, 2022, 04:36:23 pm

Hello,

Is there a way to query Prolaborate database using the custom Reports widgets in v3 or v4 ?

Thanks,
Guillaume

Title: Re: Custom report on Prolaborate DB content
Post by: OpenIT Solutions on May 03, 2022, 06:25:33 pm

Hi,

Depends on where your prolaborate and sparx repos are stored. I have both on same SQL Server DB. So i can use the following SQL (as an example)

SELECt emailid as name FROM Prolaborate.dbo.users

(where prolaborate is the name of my prolaborate database).

Title: Re: Custom report on Prolaborate DB content
Post by: Guillaume on June 10, 2022, 05:41:59 pm

Thanks, this is very useful !  :D

Title: Re: Custom report on Prolaborate DB content
Post by: Arshad on June 10, 2022, 10:00:55 pm

Quote from: Guillaume on May 02, 2022, 04:36:23 pm

Is there a way to query the Prolaborate database using the custom Reports widgets in v3 or v4?
 

Hi Guillaume, At the moment only EA resources can be added to the custom reports.


Arshad