Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

New APEX tree documentation - get selected value

Pavel_pDec 13 2015 — edited Dec 16 2015

Hello,

I've been playing for some time with the new APEX tree and besides the sample application I haven't found anything at all about it. Unfortunately after few quite painful hours I'm not even able to get it's value (at least I suppose that it should be somehow possible to get value of a selected node). The only documentation I was able to find was this:

SQL Query

Enter the SQL source for this component.

Examples

 select case when connect_by_isleaf = 1 then 0 when level = 1 then 1 else -1 end as status, level, ename as title, 'icon-tree-folder' as icon, empno as value, ename as tooltip, null  as link from emp start with mgr is null connect by prior empno = mgr order siblings by ename 

Additional Information

  • Type: SQL Statement
  • Supported Bind Variables: Application, Page Items and System Variables
  • Minimum Columns: 7
  • Maximum Columns: 7

So please, any ideas how to get value of a selected node would be highly appreciated. There is already one similar question here APEX 5.0 Tree but the proposed solution redirects to the same page and sets item values via the link. I don't want to redirect anything anywhere, I would just like to read value of a selected node.

Thanks a lot,

Pavel

This post has been answered by Pavel_p on Dec 14 2015
Jump to Answer

Comments

Stick

Here is an alert that we run:

SELECT distinct

a.segment1

,b.line_num

,b.need_by_date

,to_CHAR(b.creation_date, 'dd-mon-rr')

,d.email_address

,max(f.action_date)

,(trunc(sysdate) - trunc(f.action_date))

,d.Full_name

INTO

&reqnum

,&linenum

,&needdate

,&creatdate

,&email

,&appdate

,&dayswait

,&name

FROM

PO_REQUISITION_HEADERs_all a

,PO_REQUISITION_LINES_all b

,PO_REQ_DISTRIBUTIONS_all c

,hr_employees d

,po_action_history f

where

       suggested_buyer_id is not null

and b.requisition_line_id = c.requisition_line_id

and a.authorization_status = 'APPROVED'

and a.requisition_header_id = b.requisition_header_id

and suggested_buyer_id = d.employee_id

and b.source_type_code = 'VENDOR'

and a.org_id =405

and NVL(b.modified_by_agent_flag,'N') = 'N'

and b.line_location_id is null

and f.object_id = a.requisition_header_id

and f.object_type_code = 'REQUISITION'

and f.action_code = 'APPROVE'

and nvl(b.cancel_flag, 'N') = 'N' -----is null

and nvl(b.closed_code, 'N') = 'N' -----is null

and f.sequence_num = (select max(e.sequence_num)

     from po_action_history e

     where e.object_id = a.requisition_header_id

       and e.object_type_code = 'REQUISITION')    

and nvl(a.TRANSFERRED_TO_OE_FLAG, 'N') = 'N'

and (trunc(sysdate) - trunc(f.action_date)) >= 6

group by a.segment1 ,b.line_num ,b.need_by_date ,b.creation_date

,d.email_address ,f.action_date, d.full_name

order by 8,3

Hope this helps

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 13 2016
Added on Dec 13 2015
10 comments
10,130 views