Which Page correspond to wich ID

[Jacynthe_Thibault]

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_ID	ID	LAST_VIEW_DATE	SPACE_KEY	USER_KEY	CONTENT_TYPE	user_key.1	username	lower_username
2639467	12200	2 mai 2023	SpaceX	ff8080817bab80a2017bd147680003	PAGE	ff8080817bab80a2017bd17680003	njoi	njoi
1156057	344	2 mai 2023	SpaceY	e4e4824c5d6705d1015957530002	PAGE	e4e4824c5d6705d10154957530002	jkiu	jkiu
2127301	1223	2 mai 2023	SpaceZ	e4e4824caa9601429fab118100c4	PAGE	e4e4824c429faa9601429118100c4	dfh	dfh

Thanks

[Ken McClean]

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]

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