Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
ctx_doc_markup with mutli_column_datastore problem

Hello
We have created a multi column text index on our table :
exec ctx_ddl.create_preference('alexer', 'AUTO_LEXER'
exec ctx_ddl.set_attribute('alexer', 'BASE_LETTER', 'YES');
exec ctx_ddl.create_preference('table_pref', 'MULTI_COLUMN_DATASTORE');
exec ctx_ddl.set_attribute('table_pref','COLUMNS','ID,DESIGNATION,COMMENT_ADJUST');
create index TIND1 on ATABLE(TEXT_IND_COL) indextype is ctxsys.context
parameters ('DATASTORE TABLE_PREF LEXER alexer SYNC(on commit)');
We are now trying to use the ctx_doc.markup package to make a marked up document.
ctx_doc.markup (index_name => indexName,
textkey => keyVal,
text_query => textToSearch,
restab => vclob,
tagset => 'HTML_DEFAULT');
The problem we have is that the markup is also marking the automatically added tags as well as the text
ex. For a row in the table where the column
ID = 'id value'
DESIGNATION = 'desig value'
COMMENT_ADJUST = 'Adjust value'
running a query with contains 'AD%' results in the COMMENT_ADJUST tag being marked up as well as its value. The result from the ctx_doc.markup is :
<ID>
id value
</ID>
<DESIGNATION>
desig value
</DESIGNATION>
<COMMENT_<B>AD</B>JUST>
<B>Ad</B>just value
</COMENT_<B>AD</B>JUST>
Is there a way to not mark up the automatically added tags ?
(Oracle Database 12c , 12.1.0.2.0)
Thanks
Paul