Home » Developer & Programmer » Application Express & MOD_PLSQL » help with WHERE CLAUSE on report (4.0)
help with WHERE CLAUSE on report [message #551147] Sun, 15 April 2012 20:06 Go to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
where (CALL_STATUS = 'Open') AND (CALL_ASSIGNEE = :APP_USER)


I need to filter the report so CALL_ASSIGNEE = USER_FULLNAME (HELPDESK_USER).... WHERE :APP_USER IS USER_FULLNAMES LOGIN NAME (USER_LOGIN) (HELPDESK_USER TABLE) Confused



USER_FULLNAME AND USER_LOGIN ARE ON USER TABLE... CALL_ASSIGNEE AND CALL_STATUS ARE ON THE HELPDESK_CALL TABLE...

[Updated on: Sun, 15 April 2012 20:07]

Report message to a moderator

Re: help with WHERE CLAUSE on report [message #551167 is a reply to message #551147] Mon, 16 April 2012 01:30 Go to previous messageGo to next message
Littlefoot
Messages: 19633
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
where call_status = 'Open'
  and call_asignee = (select user_fullname
                      from helpdesk_user
                      where user_login = :APP_USER
                     )
Re: help with WHERE CLAUSE on report [message #551222 is a reply to message #551167] Mon, 16 April 2012 07:16 Go to previous message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
thank you that works well ! hope it helps others too
Previous Topic: authorization schemes not allowing any access to the page
Next Topic: Error in intalling apex.
Goto Forum:
  


Current Time: Mon Sep 22 11:29:56 CDT 2014

Total time taken to generate the page: 0.09537 seconds