Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

search in all trash spaces

kohopir975
Contributor
December 4, 2022 edited

Hi

Is there anyway to search through all trash spaces?

 

Any idea?

Thanks,

2 answers

1 vote
David Freitez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 4, 2022

Hi @kohopir975

An idea, since it is Confluence on Server, I would try to search in the database. Here is a link of how it could be achieve, please note that the SQL would vary so you can get your desired search:

https://confluence.atlassian.com/confkb/how-to-perform-a-confluence-site-search-for-keywords-and-links-through-the-database-830284252.html

Hopefully this idea gives you a hint.

Regards,
David

0 votes
Sebastian Krzewiński
Community Champion
December 5, 2022

Hi @kohopir975 

 

You can make a list of all pages in trash by SQL query:

select dateadd(s, convert(bigint,EVENT_AT)/1000,'1970-01-01') as 'Date', cnt.TITLE, usrm.username from dbo.AO_7B47A5_EVENT eve
join CONTENT cnt on cnt.CONTENTID=eve.CONTENT_ID
join user_mapping usrm on usrm.user_key=eve.USER_KEY
where eve.NAME='page_trashed';

Regards,

Seba 

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian community, job interviews, interview tips, career advice, interview preparation, job search, interview experiences, hiring process, atlassian careers, community discussion, interview best practices

Interview Tips & Pet Peeves ✍️

Join the discussion on interview best practices and common pitfalls. Share your experiences and learn from others in the Atlassian Community.

Share you experiences!
AUG Leaders

Atlassian Community Events