❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Preserve checkbox in an Interactive Report with Select All option
Bhavin
Hello Vinish, Just to let you know - I have gone through full conversation and implemented accordingly. It is all working fine and also inserted the selected records into new db table. I am near the solution just need to sort out few issues: (1) on a click record is accurately added in the collectioRead more
Hello Vinish,
Just to let you know - I have gone through full conversation and implemented accordingly. It is all working fine and also inserted the selected records into new db table.
I am near the solution just need to sort out few issues:
(1) on a click record is accurately added in the collection (EMP_COLLECTION) but if I unchecked a record that needs to remove/delete from the collection (EMP_COLLECTION). How to implement this one?
(2) I have Pagination of Type - Page - (Report with Pagination) so how to preserve selected checkbox/records?
Kind Regards,
Bhavin
See lessPreserve checkbox in an Interactive Report with Select All option
Bhavin
Hi Vinish, Thank you so much for your reply and pointing to the right direction. How can I save the selected records into the new database table? There is a need to have a Button on a report (ig report on EMPLOYEES) like 'Load Employees' and then load all selected records into the new table, say EMPRead more
Hi Vinish,
Thank you so much for your reply and pointing to the right direction.
How can I save the selected records into the new database table? There is a need to have a Button on a report (ig report on EMPLOYEES) like 'Load Employees' and then load all selected records into the new table, say EMPLOYEES_NEW.
I am struggling here. Can you please help me?
See lessOracle SQL Query where not already exists
Bhavin
Many thanks for your prompt reply but this query won't work...! Any way I found the solution based on the above query: SELECT DISTINCT p.person_id ,c.contact_det_type_id ,c.description FROM per_contact_dets p ,contact_det_types_lk c WHERE p.person_id = :person_id AND c.contact_det_type_id NOT IN (SERead more
Many thanks for your prompt reply but this query won't work...!
Any way I found the solution based on the above query:
SELECT DISTINCT
See lessp.person_id
,c.contact_det_type_id
,c.description
FROM per_contact_dets p
,contact_det_types_lk c
WHERE p.person_id = :person_id
AND c.contact_det_type_id NOT IN (SELECT p1.contact_det_type_id
FROM per_contact_dets p1
WHERE p1.person_id = p.person_id)
;
Wizard Style Form in Apex
Bhavin
Many thanks Farooq, I will have a look.
Many thanks Farooq, I will have a look.
See lessWizard Style Form in Apex
Bhavin
Hi Vinish, Many thanks for your prompt reply and providing the instant solution. I have checked there is no header process in my page. I think (not sure) the issue is setting the Source of the page item. By default Wizard does not set the Source for the page item so in Source attribute, Type is setRead more
Hi Vinish,
Many thanks for your prompt reply and providing the instant solution.
I have checked there is no header process in my page.
I think (not sure) the issue is setting the Source of the page item.
By default Wizard does not set the Source for the page item so in Source attribute, Type is set to NULL and Used is set to Only when current value in session state is Null.
And in my case I have set the Type to Database Column and Used is set to Always, replacing any existing value in session state.
See lessWizard Style Form in Apex
Bhavin
Hi Vinish, Yes, Cache option is blank. I have also checked the Order Processing wizard on Sample Database Application, that one also doing the same behaviour, cleared out the data. Is there any way not to clear out the data? My settings for a branch:
Hi Vinish,
Yes, Cache option is blank. I have also checked the Order Processing wizard on Sample Database Application, that one also doing the same behaviour, cleared out the data. Is there any way not to clear out the data?
My settings for a branch:
See lessWizard Style Form in Apex
Bhavin
Hello Vinish, I have implemented the same method for all the pages but when I click the PREVIOUS button and go to previous page I loose the data. I have also created a branch to go to the previous page.
Hello Vinish,
I have implemented the same method for all the pages but when I click the PREVIOUS button and go to previous page I loose the data. I have also created a branch to go to the previous page.
See lessWizard Style Form in Apex
Bhavin
Hello Vinish, Further to my earlier message everything is working fine except when I click the PREVIOUS button I am losing the Page Item values (especially for FORM page) which I have already entered. How can I keep the page item values even I do back and forth in wizard? Your help would be appreciaRead more
Hello Vinish,
Further to my earlier message everything is working fine except when I click the PREVIOUS button I am losing the Page Item values (especially for FORM page) which I have already entered.
How can I keep the page item values even I do back and forth in wizard?
Your help would be appreciated.
See lessWizard Style Form in Apex
Bhavin
Hello Vinish sir, My apologies for not coming back earlier as I was not well. I have implemented the steps as you have mentioned earlier by creating a normal table...I can confirm that it's all working fine with IG on a normal temp table and then inserting data from temp table to actual table. ManyRead more
Hello Vinish sir,
My apologies for not coming back earlier as I was not well. I have implemented the steps as you have mentioned earlier by creating a normal table...I can confirm that it's all working fine with IG on a normal temp table and then inserting data from temp table to actual table.
Many thanks for your all help and support.
See lessWizard Style Form in Apex
Bhavin
Hi Vinish, I have tried the solution as you have suggested but I am struggling in IG. I assume Global Temp Table only works for single entry (not sure) but for multi rows we have to use Apex Collection. Would it be possible for you to make a demo on this?
Hi Vinish,
I have tried the solution as you have suggested but I am struggling in IG. I assume Global Temp Table only works for single entry (not sure) but for multi rows we have to use Apex Collection.
Would it be possible for you to make a demo on this?
See less