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);
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.
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 :)
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'.
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?