Re: Context Gurus! please help!!! <b>retrieve unique words per policy index<b>

From: Garrett Kaminaga <gkaminag__at__us.oracle.com>
Date: Wed, 04 Nov 1998 15:41:16 -0800
Message-ID: <3640E61C.C6782BCC@_us.oracle.com>

bonanos_at_yahoo.com wrote:
>
> Is there a way to get all the unique words out of a context policy index.
>

You can get the list of words, but not the occurrences. There is a table DR_XXXXX_I1T1 (sometimes DR_XXXXX_I1T2 -- XXXXX is the policy number, which you can get from ctx_user_policies)

The column word_text has the indexed words. There is some duplication, so be sure to place a distinct on the select. Depending on the version, you might have a word_type column. You want word_type = 0 ONLY.

This applies only to 2.X of ConText and is not documented structure (we reserve the right to change the structure)

We are considering such a "vocabulary browse" functionality for future versions of ConText.

--

---

Garrett Kaminaga                          Oracle ConText Server Group
---------------------------------------------------------------------

Note: remove underscores to get real email address Standard disclaimers apply -- all posts are personal opinion Received on Wed Nov 04 1998 - 17:41:16 CST