oracle adf version 11.1.2.3

 

 

 how to make cascade  list  of lov 
  with query condition  equal item in other block  not in same block 
 

 

 like in detail block list

 

select delivery_id , delivery_name  from delivery_table 

where sales_order_number =_sales_header_number 

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

in detail table i not have value which i want to pass in query and also not have column 

the value will come from master table field

 

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

 

i create Transient attribute to make access from my list to it  in detail block

 

  and set the value for  Transient attribute   EL   using groovy 

 

adf.object.DcmAM.findViewObject('XxDcmCommInvoiceHeaderVO').currentRow.SoHeaderNumber   

 

but get this error

(oracle.jbo.expr.JIEvalException) JBO-25077: Name DcmAM not found in the given object: ViewRow [oracle.jbo.Key[null ]].

any other way to access item in master even its not database item 

 

 

 

solution is give this value to parameter   to access get any data field in  master table from detail 

 

adf.object.applicationModule.findViewObject("XxDcmCommInvoiceHeader1").currentRow.SoHeaderNumber

 

https://mjabr.wordpress.com/2011/04/01/cascade-list-of-values/

هذا الرابط به طريقة بسيطة 

 

oracle adf version 11.1.2.3

 

 

 how to make cascade  list  of lov 

  with query condition  equal item in other block  not in same block 

 

 

 like in detail block list

 

select delivery_id , delivery_name  from delivery_table 

where sales_order_number = _sales_header_number 

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

in detail table i not have value which i want to pass in query and also not have column 

the value will come from master table field

 

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

 

هل توصلت لحل؟

 

solution is give this value to parameter   to access get any data field in  master table from detail 

 

adf.object.applicationModule.findViewObject("XxDcmCommInvoiceHeader1").currentRow.SoHeaderNumber

 

ممكن توضح اكثر

mo7asb

يمكنك إنشاء متغير  داخل detail يمثل القيمة التي تحتاجها بحيث أنه عند إنشاء سجل جديد فتقوم بوضع قيمته من master