Catalogue of topics (?)

  • Nobody/Anonymous


    sorry for my english, but it's easier for me to talk anbout chicks and computers in this language, than to use specific librarian jargon.

    I need to do the catalogue of all topics that are in the database in fields "Topical term or geographic name as entry element: (1 to 5)". I prefere to add it in the start page for every user, to help him find a book from specific topic (as you can see here:\). How to get those data from the database and sort it alphabetically?


    • Hans van der Weij

      See SQL code below. Note that this will only work for OpenBiblio 0.4.0 - 0.6.0 and that the next version (1.0) will have a different database structure.

      I think it's a good idea to present the public some kind of list of topics for a library. When confronted with an OPAC, someone will try only a few search phrases at best. For finding "known items", this may work, but guessing keywords is not efficient for a discovery process. Selecting topics from a list, as in your current implementation, would be more convenient.

      I can see a possible disadvantage if the list becomes longer, but I'm not sure how orientation and navigation could be improved.
      Perhaps the public would appreciate a printed list?
      A while ago I announced a report written for the OpenBiblio reports system that can be helpful too:
      The report is finished and OK, but not yet published.

      select distinct topic1 as topic
      from biblio
      where topic1 !=''
      select distinct topic2 as topic
      from biblio
      where topic2 !=''
      select distinct topic3 as topic
      from biblio
      where topic3 !=''
      select distinct topic4 as topic
      from biblio
      where topic4 !=''
      select distinct topic5 as topic
      from biblio
      where topic5 !=''
      order by topic

      Good luck,



Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks