Counting the Number of Folders present in a project area in RRC
Hi,
I just wanted to check if there is any easier way to count the number of folders present in a project area in RRC rather than manual counting.
We are doing a performance benchmarking for a patch recently received from IBM support where only 100 folders are visible in the Project Area. If there are more than 100 folders, the folders disappear. Post applying this patch, we are not seeing the problem. However, we want to give out a number (of folders) for project areas in production environments.
2 answers
You can also use the SPARQL query below to count the number of folders in a given RM project area. The steps for accessing the SPARQL Query editor vary between 4.x and 5.0.
4.x: Go to http{s}://<server>:<port>/rm/rmadin -> Advanced Properties -> set com.ibm.rdm.fronting.server.debug.enabled to "true" and click "Update Property" to set the value
Then go back to rm/rmadmin -> SPARQL Query
5.0: Go to http{s}://<server>:<port>/rm/admin -> Debug -> SPARQL Query
Enter the query below, making sure to change the server URL to match your server URL.
PREFIX dc: <http://purl.org/dc/terms/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rm: <http://www.ibm.com/xmlns/rdm/rdf/>
PREFIX nav: <http://com.ibm.rdm/navigation#>
PREFIX jfs: <http://jazz.net/xmlns/foundation/1.0/>
SELECT ?Folder
WHERE {
?Folder dc:isPartOf <https://<server>:<port>/rm/folders> .
}
LIMIT 1
Just select the "pre-count" option and select your project from the dropdown, and run the query. Your result will be the count of folders in the project you selected.
In the screenshot below, I've run the query against a project with 5 folders (well really 6, because of the root folder), so the result returned from the query is 6. Hope it helps,
4.x: Go to http{s}://<server>:<port>/rm/rmadin -> Advanced Properties -> set com.ibm.rdm.fronting.server.debug.enabled to "true" and click "Update Property" to set the value
Then go back to rm/rmadmin -> SPARQL Query
5.0: Go to http{s}://<server>:<port>/rm/admin -> Debug -> SPARQL Query
Enter the query below, making sure to change the server URL to match your server URL.
PREFIX dc: <http://purl.org/dc/terms/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rm: <http://www.ibm.com/xmlns/rdm/rdf/>
PREFIX nav: <http://com.ibm.rdm/navigation#>
PREFIX jfs: <http://jazz.net/xmlns/foundation/1.0/>
SELECT ?Folder
WHERE {
?Folder dc:isPartOf <https://<server>:<port>/rm/folders> .
}
LIMIT 1
Just select the "pre-count" option and select your project from the dropdown, and run the query. Your result will be the count of folders in the project you selected.
In the screenshot below, I've run the query against a project with 5 folders (well really 6, because of the root folder), so the result returned from the query is 6. Hope it helps,
Comments
showing 5 of 7
show 2 more comments
Comments
long TRUONG
Jun 13 '14, 6:00 p.m.long TRUONG
Jun 13 '14, 9:33 p.m.Yash Doshi
Jun 18 '14, 7:15 a.m.