I made Cro-Eng dictionary using Interactive Report by joining two table columns of Croatian and English word. Now I want to remember every word that I write in the search field of Interactive Report by filling the table SEARCHEDWORDS which has two columns WORD and DATE, so that I can see all the searches that were made and the date they were made. Is it possible? Do I need triggers for that, or do I do it through processes in edit page of Interactive report? something like INSERT INTO SEARCHEDWORDS (WORD, DATE)
VALUES (?SOMETHING?, SYSDATE);
It's possible. You'll need to do the following:
1- Create a Application Process to handle the insert to your SEARCHWORDS table
2- Create a JS function that makes an AJAX call to your application process
3- Have a JS line that overwrites the IR search "Apply" button so that it first makes a call to your JS function.
Martin,thank you for help.
Since I have only basic experience with apex and none with writing Java Scripts or AJAX I'll ask some questions that could seem funny to you.
1- do I create App. Process in IR's Page Edit or SEARCHWORDS Page Edit? So in Source field of Edit Page Process I write just Sql code like Insert into...?
2- Where do I write this JS code? Is there some place within page edit where I can write it or..?
thank you so much Martin, it is for my diploma work so I would be really grateful. My dictionary can translate and IR suits me great for that, but my mentor wants that it also remembers every searched word that I write and the time of search so it can be stored in the SEARCHWORDS table for analysis or something. If you could do it step by step solution overview because I haven't customize any page processes yet, I'm beginner with Apex :)
Hi Martin, Thank you for the solution!
Just one question more. I suppose I make this On Demand Application process in Page Processing area of Page Edit Window of tir_search_filter_log report page by clicking the Create process mark. I tried to do that once with something else and after I choose On demand and sign the name of the process it sends me error : To create an on-demand page process, at least one application level process must be created with the type 'ON-DEMAND'.
You'll need to create the On Demand Application Process at the application level. To do this go into Shared Components / Application Processes / Click Create / Point: Set to On Demand...
Man you're a life saver!
I'll do that and get back to you how it went.
About the last step..I just write that in HTML Text Region Source of IR's page?
Since I'll have a few IR's for Cro_English, Cro-German and Cro-French dictionary I just write the same thing in every of those IR's HTML Regions and it will work?
What is that jQuery, is it only needed to watch example you've made or do I need it to do this HTML text or something? ( sorry if the question is stupid)
Sorry for bothering you again, but could you direct me where exactly would I add Java Script code in my IR page. I have created new region containing log table. Now, do i have to create new region- HTML, and add JS code in Source area or?