This discussion is archived
2 Replies Latest reply: Nov 9, 2012 8:46 AM by 973535 RSS

Stopwords and queries using sections

973535 Newbie
Currently Being Moderated
Hello,

I have defined a full text index as follow :

begin
ctx_ddl.create_stoplist('mystop');
ctx_ddl.add_stopword('mystop', 'fred');
end;

begin CTX_DDL.DROP_SECTION_GROUP('xmlgroup'); end;
go
begin CTX_DDL.add_mdata_section('xmlgroup','site','site');end;
go

CREATE INDEX TEST_IX ON AUTHOR (FIRST_NAME) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('stoplist mystop section group xmlgroup')
go


select FIRST_NAME from AUTHOR where contains(FIRST_NAME,'fred' ) > 0
0 answers (Fine for me)

But
select FIRST_NAME from AUTHOR where contains(FIRST_NAME,'mdata(site,paris) AND ("fred")' ) > 0
-> Fred
-> Fred
-> Fred


Do you know a way for this stoplist to be take into account in this kind of queries ?

Thanks for your help.

Kind regards,
Fred

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points