List indexes

The List index feature helps the administrator take control of how the objects ( documents, folders, emails and records ) are indexed in the Lucene search engine.

On the main screen, a table is shown with the Lucene indexed fields for each object.

Common indexed fields:

FieldDescription

#

Number

_hibernate_class

The hibernate class name:

  • com.openkm.dao.bean.NodeFolder
  • com.openkm.dao.bean.NodeDocument
  • com.openkm.dao.bean.NodeMail
  • com.openkm.dao.bean.NodeRecord

uuid

Object's unique identifier.

parent

Parent node.

context

Context values:

  • okm_root
  • okm_metadata
  • okm_categories
  • okm_thesaurus
  • okm_templates
  • okm_personal
  • okm_mail
  • okm_personal
  • okm_trash

tenant

Tenant identifier.

author

ID of the authoring user.

created

Indicates when the object was created.

name

Object's name.

userPermission

User permissions.

rolePermission

Role permissions.

Depending on the type of object ( _hibernate_class ), there may be more indexed fields.

Search indexes

  • On the top right, click on Search indexes button.
  • In the input box, copy an object's UUID (from the desktop view, you can get any object's UUID from the Properties tab: select the UUID and press CTRL+C to copy).
  • Click on the Search button.
  • From the table list, click on List icon.

The filtering input box uses the syntax FIELD:value. Here are some examples:

  • uuid:ce3338a5-b1ec-481b-9d59-f5aeb3fcf42b
  • name:invoice.*
  • text:telephone

Let's see an example. Imagine you have two documents called "Parana.doc" and "Parana.pdf". You can locate them by this search:

name:paran*

But be careful, because using quotation marks you won't get any results:

name:"paran*"

If you want to locate all PDF documents whose name starts with "Paran", the correct query is:

name:paran*pdf

This query would also work (note the dot before the extension):

name:paran*.pdf

But this query will fail because you cannot use a * or ? symbol as the first character of a search. This is a Lucene limitation.

name:*pdf

If you want to look up documents with a given extension, I would recommend using the MIME Type property this way:

mimeType:application/pdf

In this query we are looking for all documents whose name starts with "parana" and that have a keyword called "dog":

name:parana* AND keyword:song

You can learn more about query syntax at Lucene Query Syntax.

Enable show terms

When Show terms is enabled, an extra field named terms is shown on document objects with the terms used by the Lucene search engine for indexing that document.

  • On the top right, click on Show terms button.

Disable show terms

  • On the top right, click on Show terms button.