Differences

This shows you the differences between two versions of the page.

--- documentation:facet_idx_def_example [2010/06/15 16:15] – created miker
+++ documentation:facet_idx_def_example [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 51: / Line 51: @@
 <code sql>
-INSERT INTO metabib.identifier_field_entry (field, source, value, index_vector)
+INSERT INTO metabib.facet_entry (field, source, value)
   SELECT  CURRVAL('config.metabib_field_id_seq'::regclass),  -- Returns the id of the indexing definition inserted above
           mfr.record,                                        -- The source MARC record from which the data will be extracted
-          value,                                             -- Coalesce all 947$t data into a single space-separated string for initial index population
+          UPPERCASE(BTRIM(value,'[]'))                       -- Normalize 947$t data using the same logic as the defined above for initial index population
-          ''                                                 -- For facet fields, it is important to set the index_vector column to the empty string
     FROM  metabib.real_full_rec AS mfr        -- The internal table holding a flattened version of the bibliographic record
     WHERE mfr.tag = '947' AND subfield = 't'; -- Include only subfield t from 947 tags
@@ Line 108: / Line 107: @@
     WHERE cin.name = 'Replace';           -- The normalizers we care about for this field
-INSERT INTO metabib.identifier_field_entry (field, source, value, index_vector)
+INSERT INTO metabib.facet_entry (field, source, value)
   SELECT  CURRVAL('config.metabib_field_id_seq'::regclass),  -- Returns the id of the indexing definition inserted above
           mfr.record,                                        -- The source MARC record from which the data will be extracted
-          value,                                             -- Data from 947$t, each row separately
+          UPPERCASE(BTRIM(value,'[]'))                       -- Normalize 947$t data using the same logic as the defined above for initial index population
-          ''                                                 -- For facet fields, it is important to set the index_vector column to the empty string
     FROM  metabib.real_full_rec AS mfr        -- The internal table holding a flattened version of the bibliographic record
     WHERE mfr.tag = '947' AND subfield = 't'; -- Include only subfield t from 947 tags