List indexes

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

On the main screen, a table shows the Lucene-indexed fields of 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 author.

created

Indicates when the object was created.

name

Object name.

userPermission

User permissions.

rolePermission

Role permissions.

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

Search indexes

  • On the top right, click on Search indexes button.
  • In the input box, paste an object's UUID (from the desktop view you can get any object's UUID on the Properties tab; select the UUID and press CTRL+C to copy).
  • Click 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 with 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 names start 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 recommend using the MIME type property this way:

mimeType:application/pdf

In this query, we are looking for all documents whose names start 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, extra fields named terms are shown on document objects with the terms used by the Lucene search engine to index that document.

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

Disable show terms

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