OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » help with WHERE CLAUSE on report

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » help with WHERE CLAUSE on report (4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help with WHERE CLAUSE on report [message #551147]

Sun, 15 April 2012 20:06

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

Littlefoot
Messages: 21795
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
                     )

Report message to a moderator

Re: help with WHERE CLAUSE on report [message #551222 is a reply to message #551167]

Mon, 16 April 2012 07:16

newprogrammerSQ
Messages: 48
Registered: April 2012

Member

thank you that works well ! hope it helps others too

Report message to a moderator

Previous Topic:	authorization schemes not allowing any access to the page
Next Topic:	Error in intalling apex.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 01 13:48:52 CST 2023