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
AUG Leaders

Atlassian Community Events