APEX

Hello,

I have being playing around with tooltips and incororating Jquery tooltips in Apex applications but not all that much luck...

I have an sql report, one of those fields is comments...

What I would like is that the report does NOT show the comments column rather when the user hovers there mouse over the row, the comment for that particular row is shown as an comment. If there is no comment, then nothing should be shown..ie.e. no tooltip.

I have tried using the APEX_ITEM.HIDDEN API but no luck...perhaps someone can explain how this should be done.

---------

select esap_sid
,substr(filename,instr(filename,'/',1)+1) filename
,xap.private_to_user
,xap.private_to_role
,xap.obsolete
,xap.created_by
,xap.created_on
,apex_item.hidden(1,xap.comments)
,role_name
from xmaf.xxxe_apex_attachments xap
,XXXE_PROD_REPL_REQUESTS_V prr
where 1=1
and xap.pr_sid = prr.pr_sid
and ((((private_to_user IS NULL)
or (private_to_user = 'Y'
and xap.created_by = apex_custom_auth.get_username))
and (private_to_role = 'Y'
and role_name IN (select role_name
from apps.XXXE_PR_USER_ROLES
where user_name =apex_custom_auth.get_username)))
OR( exists (select 'Admin User'
from apps.XXXE_PR_USER_ROLES
where user_name =apex_custom_auth.get_username
and role_name = 'ADMIN')))
order by esap_sid asc

---------------