2 Replies Latest reply: Nov 9, 2012 10:46 AM by 973535 RSS

    Stopwords and queries using sections

    973535
      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