2013-09-10

Confluence: Search for things skipping the shipped "search engine"

Using Atlassian Confluence, and have to report on exact things, like "How many, and which pages refer to a given phrase"?
This searches through all the latest version of all the pages:
1
2
3
4
5
6
7
8
9
10
SELECT DISTINCT
FROM
   CONTENT
INNER JOIN BODYCONTENT USING(contentid)
WHERE
   prevver      IS NULL
   AND SPACEID  IS NOT NULL
   AND PARENTID IS NOT NULL
   AND REGEXP_LIKE(BODY, 'internal-webserver\d(\.example\.com)?\\public', 'i');

No comments :

Post a Comment