sql - Oracle Apex column link from LOV values -

sql - Oracle Apex column link from LOV values -

can please advise if below possible. using oracle 11g , apex 4.2.6.

i have info grid brings tasks master table. show task name via lov.

i trying add together links, via column links. must turn off lov create work. give me link. not helpful.

example below.

<a href="f?p=103:5:7907259112753::no::p5_mast_id:44193">44193</a>

is there way, can still utilize lov. homecoming value gives me id link, display value gives me anchor text.

example below.

<a href="f?p=103:5:7907259112753::no::p5_mast_id: 44193">weekend</a>

many thanks

i'm used apex 4.1, approach should work.

you don't need lov. study query should include both mast_id , task_name columns. hide task_name column , set mast_id linking column. if set link text (under column link) #task_name#, should desired result. display as should left @ default (display text etc).

sql oracle oracle-apex apex lov