hi I am changing the VA of tabular records through post-query. I have a display non-DB field, to which the VA is not getting applied. my code in post-query is something like the below; if :mprh_status = 'O' then --Open MPR :m_status := 'Open'; set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_O'); set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_OPEN'); set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_OPEN'); set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_OPEN'); set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_OPEN'); elsif :mprh_status = 'C' then --Closed/Cancel MPR :m_status := 'Close'; set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_C'); set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_CLOSE'); set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_CLOSE'); set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_CLOSE'); set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_CLOSE'); elsif :mprh_status = 'A' then --Approved MPR :m_status := 'Approved'; set_item_instance_property('m_status',current_record, visual_attribute, 'VA_MPR_A'); set_item_instance_property('mprh_no',current_record, visual_attribute, 'VA_MPR_APPROVED'); set_item_instance_property('mprh_date',current_record, visual_attribute, 'VA_MPR_APPROVED'); set_item_instance_property('m_acnt_name', current_record, visual_attribute, 'VA_MPR_APPROVED'); set_item_instance_property('mprh_remarks', current_record, visual_attribute, 'VA_MPR_APPROVED'); end if; what surprises me is just m_acnt_name VA does not get changed at runtime, which is a non-DB field. Check my media for screenshots of my problem. thanks
Discy Latest Questions
Hi Sir jii, Need to add the sum of column total at run time in IG report when in click add row button. Can you Please suggest.
Hi, I am working on the breadcrumb. I have problem to display the breadcrumb on multiple parents and child. Example. 1 .parent pages 1 -> 2 ->3 child 7 2.Parent Pages 4 -> 5 ->6 child 7. In above example finally both parents are accessing child 7. Thanks prasad
Hi Sir jii, How to display the page item value in XML report can you please suggest. Suppose i have passed the page item value as 2022 i need to display in XML report.
Hi sir, I created an IR report report and assigned one of the column type as link working perfect, if i convert the report to pivot the link is not displaying in pivot report can u please suggest.
Hello, I want to write a plsql procedure block to generate a CSV file using manual data as well as data from one table, using utl_file package and cursors. Please check the attachment. The table has records of a few lines only which has data and I want to add time column(column A) as you can see in the attachment where it will have time data after every 5 mins and for any time if a table has records, the procedure has to take the data into the file. Thanks, Bansari
I have a SQL Query inside button that will return multiple data. The Interactive Grid also got it own SQL Query. How do I populate/add these data into an Interactive Grid that already have data without replacing existing data in the Interactive Grid?.
I have a colleague that is using a collection in one of his pages. However, when he runs the query: Select * from apex_collections; No rows are returned. Any idea why no rows are found? Thanks.
Hi sir jii, How to hide Rows in IR Report when column values is null. Can you please suggest.
Vinish, this may be an inappropriate topic here. If it is, please delete it and let me know... If you, or anyone you know of, might be interested in this I'd also LOVE to hear from you 🙂 We have a small application written in VFP using Web Connection to deliver the UI to the WEB (Only three screens). The back end uses VFP tables, but essentially writes data eventually to Oracle Database. We want to move this app onto APEX, effectively cutting out the "Middle Man" (VFP). If anyone is interested in this, please contact me.