Advertisement
roganhamby

Removing Extra Languages in OPAC

Dec 30th, 2013
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- I've been asked a couple of times about removing all the extra languages in the OPAC search options
  2.  
  3. select * from config.coded_value_map where ctype = 'item_lang';
  4.  
  5. -- this will give you what languages are in there, go through, and select the ones to keep and then put them in the list below
  6. -- when I ran it I had 460 entries
  7.  
  8. update config.coded_value_map
  9. set opac_visible = FALSE
  10. where ctype = 'item_lang'
  11. and code not in ('ara','chi','eng','enm','ang','fre','ger','gre','heb','gle','jpn','rus','sgn','spa','yid','vie')
  12. ;
  13.  
  14. -- 16
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement