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