Search for a Page's Creator OR for Pages with No Content

Star Date: Sunny Afternoon 0.1

Chaps,

I want to do the following:

  1. find all the pages created by a certain user
  2. find all pages that have either no content or less than, say, 20 words

I've had a look in the user docs and here and can't find anything that gives me what I'm looking for.

Do you have the answer to my questions? If so, please respond by entering your answer below.

Thanks in advance.

2 answers

This widget could not be displayed.

Assuming we are using a later version, the following SQL will work for creator. Depending on the DB type it may need to be altered (I am using MySQL).

SELECT * FROM content WHERE CREATOR='username' AND PREVVER IS NULL AND CONTENTTYPE='PAGE';

And then this should bring back smaller pages that have less then 50 characters but can be adjusted of course. And again, may need to be adjusted depenind on the DB in use.

SELECT C.TITLE, C.CONTENTID FROM BODYCONTENT B, content C WHERE C.PREVVER IS NULL AND C.CONTENTTYPE='PAGE' AND length(B.BODY)<50;

Andrew, thanks, I'll investigate that and see what the IT team can do.

Cheers.

This widget could not be displayed.

The Reporting plugin from ServiceRocket (nee CustomWare) is capable of doing the analysis you've requested.

This recipe would be a good start point for #2: http://docs.servicerocket.com/display/REPORT/Listing+Contents+with+Specific+Text+or+Macro

If you already have this plugin, let us know and I can offer you some more tips.

Charles,

No we don't, but I'll investigate it.

Cheers.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in United States

Local Atlassian Research Workshop opportunity on Sep. 28th

We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...

33 views 0 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you