Which Page correspond to wich ID

Jacynthe.Thibault May 5, 2023

Hi,

 

We run this request to have the users who have seen the pages lats time.

 

SELECT *

FROM "AO_92296B_AORECENTLY_VIEWED"

JOIN user_mapping u ON u.user_key = user_key

ORDER BY "LAST_VIEW_DATE" DESC;

 

It gives something like this, my question is how can I know which ID corresponds with which page?

CONTENT_IDIDLAST_VIEW_DATESPACE_KEYUSER_KEYCONTENT_TYPEuser_key.1usernamelower_username
2639467122002 mai 2023SpaceXff8080817bab80a2017bd147680003PAGEff8080817bab80a2017bd17680003njoinjoi
11560573442 mai 2023SpaceYe4e4824c5d6705d1015957530002PAGEe4e4824c5d6705d10154957530002jkiujkiu
212730112232 mai 2023SpaceZe4e4824caa9601429fab118100c4PAGEe4e4824c429faa9601429118100c4dfhdfh


Thanks

1 answer

0 votes
Ken McClean
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.
May 7, 2023

It's been a while since I looked at the database.  It used to be that in Confluence, the table that contains the correlation between ID and page name is the CONTENT table.   Maybe check and see if that table still exists, and do a join if so.

Jacynthe.Thibault May 9, 2023

Thanks I have the answer with ChatJPT who gives me a powershell script to retreive the page url.  :)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events