Hi everyone,
I am developing an internal search engine in my team, allowing my users to query data and download them as a file. So far I implemented this using the combination of Interactive Report (IR) and Oracle Text (OT):
- I used OT to handle the search terms and query the data
- I used IR to display the search results. It also allows my team to download search results using Actions > Download option.
The problem with this approach is, the search results in IR table is not intuitive for my users because it is displayed in columns, and there are lots of them (>20 columns) which requires my users to scroll horizontally a lot. They prefer the results just like the Google search results UI:
- search keywords highlighted
- data displayed not in columns, but in structured format using HTML and CSS
I recently learned that I can format the search results in HTML and CSS to be more intuitive using CTX_DOC.MARKUP package. Now my only concern is, how can I provide the download option on top of this marked-up display? Is there an API or library to integrate the Apex' download feature with the OT search?
Any suggestion will be appreciated, thanks!