I have TESTS apex collection and I need to save total amount from classic report collection into P58_TOTAL page item

this is the query used in classic report :

select seq_id Serial , 
       c001 TEST_NO ,
       c002 TEST_NAME , 
       c003 SECTION,
       c004 QTY,
       c005 TEST_PRICE , 
       c006 as "TEST VAT 15%", 
       c007 TEST_TOTAL ,
       c008 SAMPLE_TYPE
from apex_collections 
where collection_name = 'TESTS'

I tried the following query to get total from the collection

1- changed type to SELECT LIST

2- I used the SQL query

select sum(c005+c006) , sum(c005+c006) A
from apex_collections 
where collection_name = 'TESTS'

but the total not show always empty in P58_TOTAL what is the missing ?

I need to save test total from classic report into total amount page item ?

I have TESTS apex collection and I need to save total amount from classic report collection into P58_TOTAL page item

this is the query used in classic report :

select seq_id Serial , 
       c001 TEST_NO ,
       c002 TEST_NAME , 
       c003 SECTION,
       c004 QTY,
       c005 TEST_PRICE , 
       c006 as "TEST VAT 15%", 
       c007 TEST_TOTAL ,
       c008 SAMPLE_TYPE
from apex_collections 
where collection_name = 'TESTS'

I tried the following query to get total from the collection

1- changed type to SELECT LIST

2- I used the SQL query

select sum(c005+c006) , sum(c005+c006) A
from apex_collections 
where collection_name = 'TESTS'

but the total not show always empty in P58_TOTAL what is the missing ?

I need to save test total from classic report into total amount page item ?

• oracle-apex

Share Improve this question Follow asked Mar 23 at 12:37 AbdullahAbdullah 1,0331414 silver badges2929 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 1

At what point is the collection populated and at what point is the query run to populate the page item ? It sounds as if the page item query runs before the collection is populated. Run the page in debug and investigate this - it will be visible there. If this is the issue then the solution could be to populate the page item using a computation that executes after the process which populates the collection.

I solved it by using to_number and I created dynamic action

execute server side code when populate the collection

this is the code :

select sum(to_number(c007)) into :P58_TOTAL
from apex_collections
where collection_name = 'TESTS' ;