Open a portal page taking a value from another page

Hi Gurus,

I’m looking to achieve below using global variable but not getting or could do the right thing.

I’ve created a hyperlink in a in a page button - page 1
Now through hyperlink I’m trying to open another page - pag2

The above is happening and I’ve assign roles to teh user who will access page1 and page2.

Now page2 shows user specfic data as in the data source I’ve put :UserName to a table column liek below

where col1 = ‘:UserName’
So only user can see his data .

Now a user who’s in page1 wnats to navigate to pag2 and and I wanna pass a specific value to sho that col1 = ‘:UserName’ can satify and teh page can open.

Aby help in this is well appreciated !!!