Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display Oracle Text search results and download them as file

DannyS-OracleNov 6 2017 — edited Dec 1 2017

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):

  1. I used OT to handle the search terms and query the data
  2. 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:

  1. search keywords highlighted
  2. 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!

This post has been answered by fac586 on Nov 7 2017
Jump to Answer

Comments

Gianni Ceresa

Hi,

I'm not really sure to understand what your question is about as you talk about dimension first and then about a prompt on a column ....

If you have a "Year" column which is used in a prompt and instead of YYYY you want to display YY-YY (so 2017 => 20-17 etc.) then it will be a string, and you can simple cast the year as string and then use substring to split the first 2 characters , concatenate the '-' and add the last 2 characters.

But it will not be "Year" anymore, it will be the formula you wrote as string. So all depends what you want to do with it.

Martin van Donselaar

Not exactly sure what you mean but if you generally want years to display as YY-YY then the best way to do this is to add a column containing this value to your time dimension.

user11440683

Beware of putting function logic on time measures that you then use as filters.

This will have a very real impact on performance.

Better is either to have the values populated in the format that you want in the data warehouse, or if that is not possible then tell the end user population to live with it, the trade off on speed is not worth the cosmetic appearance!

3427784

Thank you all, we were able to efficiently convince our customers this unnecessary cosmetic change will lower performance and was able to keep it in the same format as a year should!

Christian Berg-0racle

WTH just happened? A customer listened to community advice? Lollipops for everyone!

3427784

LOL, I was thinking the same. A bold move but worked out due to the technical advice provided on this thread regarding unnecessary changes! Cheers to all !

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 29 2017
Added on Nov 6 2017
4 comments
304 views